Hi, I made a stacked bar chart using sgplot using the code below:   /*stacked by date*/ data stacked_v2; set loc.loc_inclus_vo; if loc1=1 then level1=1; else level1=0; if loc1=2 then level2=1; else level2=0; if loc1=3 then level3=1; else level3=0; if loc1=4 then level4=1; else level4=0; keep patient_site_uid episode_start_time level1 level2 level3 level4; /*stacked bar chart*/ proc sort data=stacked_v2; by patient_site_uid; proc transpose data=stacked_v2 out=long(where=(col1 ne 0)); by patient_site_uid episode_start_time; var level:; run; data level_data; set long; level = substr(compress(reverse(_name_)), 1, 1); run; /*stacked monthly bar chart*/ proc freq data=level_data; table episode_start_time * level / nopercent norow nocol; run; proc sort data=level_data; by episode_start_time level; data legend_order; retain Id 'Origin' Show 'Attrmap'; length Value $10 FillStyleElement $15; input value $ FillStyleElement $; datalines; 1 graphdata1 2 graphdata2 3 graphdata3 4 graphdata4 ; run; proc sgplot data=level_data dattrmap=legend_order; vbar episode_start_time/ group=level datalabel seglabel attrid=Origin; format episode_start_time MONYY7.; How can I change the legend so that instead of having levels= 1,2,3 or 4 for each stack in the legend, I can give names to each level (eg. level=1 become "nurse", level=2 become "doctor")? I've tried changing it at the data stacked_v2 step, but it doesn't work with further steps (since changing the numeric level to character doesn't work with further steps).   Thank you!  ... View more

Hi, My data looks like this:  patient_id start_date _name_ _label_ col1 level 1 16/01/2021 level1 level1 1 1 2 17/05/2020 level3 level3 1 3 3 21/02/2021 level1 level1 1 1 4 15/05/2020 level3 level3 1 3 5 13/06/2020 level3 level3 1 3 6 28/03/2020 level3 level3 1 3   I created a stacked histogram using this code:  proc sgplot data=level_data; histogram start_date/ group=level;   Each line is a patient with a date and a level. The histogram shows: x=start_date, y=number of patients, with stacks for each level (1 to 4) (see document). I have 2 problems:    1) Since my data is sorted by patient_ID and start_date, the stacks are in this order, from up to down: 1-3-2-4. I would like them to show up as, from up to down : 4-3-2-1. I have tried sorting the data by level but it doesn't give me the result I expect on the graph. 2) For x=April on the graph, the level1 group shows 95 patients, which I have confirmed in my data. However, the stack's height is obviously out of proportion ( too short), compared to the other groups levels of the same month. Why is that? I have tried increasing the y axis scale to 300, but the visual proportion of this group doesn't change.    Thank you ... View more

Hi, I'm trying to use proc export on SAS OnDemand to export a dataset to Excel. However, the file only shows up with .bdat extension in my "My SAS files" on my SAS server. How can I have it show up with .xlsx then download it?    Here's what I have used  proc export data= dbms=xlsx outfile=" " replace; run;   Thank you ... View more