Hi All, I have 3 datasets I want to merge where there is not a unique ID to all three. For example, DatasetA - VAR1 VAR2 VAR3 DatasetB - VAR1 VAR4 DatasetC - VAR2 VAR5 This code does not work: Data SetD;      merge DatasetA  DatasetB (in= VAR1) DatasetC (in=VAR2);      by VAR1 VAR2; run; What would work? ... View more

I have some data on adverse events that I'd like to show in sgplot. I want the xaxis to be ordered by descending frequency. When I use the CATEGORYORDER=RESPDESC it works. However, when I want to group the vbar this option is ignored.  proc sgplot data=AE_data;   vbar site_ID / CATEGORYORDER=RESPDESC group=severity ;  run; I do not want to use discreteorder=data because this will order the data by Site_ID, not by the frequency of site_id. How do I get an output with the vbar sorted by frequency of site_id? ... View more

Hi All, I want to plot large data valus on the yaxis (100,000,000 to 900,000,000). SGPLOT displays them as 2E8 - 8E8. How do I get it to display the actual value? I have tried applying a format (BEST12.0) and I have used the discrete option. The discrete option is OK, but I would prefer that the values displayed as (100,000,000 to 900,000,000 by 10,000,000). How do I do this? Thanks! Sarah ... View more

Hi All, I have an excel file like the Have file shown below. There is a merged city field that I'd like to unmerge so that the city data shows on each line. However, sometimes that merged field will be applicable to 2 lines, 3 lines, or only 1 line. How do I get the Want file below? Many Thanks, Sarah Have: City Building # Specs San Francisco, CA 121 A 154 BB 225 DC Athens, GA 2568 AA Chicago, IL 115 A 128 BBB Washington, DC 82 DC 87 AA Want: City Building # Specs San Francisco, CA 121 A San Francisco, CA 154 BB San Francisco, CA 225 DC Athens, GA 2568 AA Chicago, IL 115 A Chicago, IL 128 BBB Washington, DC 82 DC Washington, DC 87 AA ... View more

Hi All, I created a graph in SAS with 6 subgroups that SAS color codes by default. I would like to use these specific colors in other graphs and so need to know the rgb color codes that SAS is using. I've looked at this link that shows all the color codes in SAS (TS-DOC: TS-688 - Defining Colors using Hex Values) but I can't find the exact matches. I think it would be easier to see what codes SAS is already using, as my team likes these colors and doesn't want to change them. thanks, S ... View more