If you want answer, you would better to post your example data to replicate your error. From the code you posted, why put genderid in VBAR since VBAR is in PANELBY ? You could try : vbar genderid / group=AdtlDemOrient stat=percent categoryorder=respasc groupdisplay=cluster seglabel datalabel; -----> vbar AdtlDemOrient / group=AdtlDemOrient stat=percent categoryorder=respasc groupdisplay=cluster seglabel datalabel; ... View more

@aigiss wrote: Hi there I did not mean to make you guess. I assumed the description above is sufficient to know what I wanted. But here is what I want.   In the genderid there are multiple subcategories Genderid =  Female Male  Unknown/Missing Transgender Male  etc...   What want to do is breakdown each subcategories to have a binary result: Female Y/N Male Y/N Unknown Y/N   Please let me know if you need more clarifications.  Mud. Clear as. Provide some data with values of the genderid as data step code or at least plain text pasted into a text box, not a picture (cannot code against pictures) and then show a manually created report /count of what you are expecting from that example data. Make sure the counts are different numbers so we can trace some logic.   ... View more

No worries, I initially mixed up the Y/N in my explanation. ... View more

In surveys, it is possible to assign different weights to different clusters or strata. So percent is computed without using the weights; weighted percent is computed using the weights. ... View more

I don't know why anyone would would attempt BRFSS or NHANES or similar data with Excel. Just getting the weights applied correctly can be a nightmare. If you go to the CDC websites for the data you should find SAS code to read text files into SAS or SAS data sets in transport format; helper code like Proc Format and typically some examples of basic summary statistics.   Start with the free online SAS Programming 1. If you are working with any of the public use data sets look for the SAS code, code books/data dictionaries and example analysis code. You can find a large number results just putting "SAS BRFSS" or "SAS NHANES" or similar into any search engine. Though again if using those I would start on the CDC website for project specific.     ... View more

If you have a SAS/Graph license, SAS ships US county borders/maps in the mapsgfk library. You can then use Proc Gmap or Proc SGmap to draw the county map, and color the counties using your data. I have several examples of North Carolina county maps in this collection - feel free to look at my code, and use that as a starting place for your California county map.   http://robslink.com/SAS/democd_nc/aaaindex.htm   ... View more

I haven't got any problem yet.    proc format; value fmt 11='11year' 12='12year' 13='13year' 14='14year' 15='15year' 16='16year' ; run; data class; set sashelp.class; format age fmt.; run; proc export data=class outfile='c:\temp\temp.csv' dbms=csv replace label; run;   ... View more