Hi. I don't know how to change the location of the data labels However, to modify the first data label so that instead of a '1' to get '1 [Reference]' this is what i suggest: data x;     set x;      if hr = 1 & ucl = 1 & lcl = 1 then label = . ;      else label = hr; run; /*more of your code*/ /*Then I changed the datalabel value to the 'label' variable:*/ proc sgplot data=x noautolegend tmplout = "&plot_path.\tmpl.sas";   scatter y=hr x=ct /yerrorupper=ucl yerrorlower=lcl           datalabel=label datalabelattrs = (size=10 color=black)             markerattrs=(size=10 symbol=squarefilled color=black)             errorbarattrs=(color=black); refline 1/ label=("1 [Reference]")axis = y labelloc = inside labelpos = min; yaxis minor values=(0.1 to 2.3 by 0.3) label='Hazard Ratio'; xaxis minor values=(1 to 4 by 1) label='BMI' ; run; Good luck! Anca. ... View more

I see. then ODS TAGSETS.EXCELXP is what you need. See here more helpful info: ... View more

So, then why don't your create an EXCEL file, instead of CSV? Something like this: %macro to_export(var = );     proc export data = sashelp.class (where=(sex="&var."))        outfile='file_path\Master_file.xls'        dbms=excel;        sheet="&var";     quit; %mend to_export; %to_export(var = F); %to_export(var = M); ... View more

I agree, there is no way to name your sheetname when using CSV. One work around it would be to name the file you are creating as the sheet-name. For exmaple: proc export data=mylib.susp_reasons_previous outfile=  'C:\Users\tiliev\Desktop\susp_reasons_previous.csv' replace;      sheet='susp_reasons_previous';run; Good luck! Anca. ... View more

Hi! Here is a piece of code that gets what you want but not very elegantly:smileyplain: /*read in your data*/ data in ; input no year sal; cards; 10 2001 100 10 2002 102 11 2001 90 11 2002 12 11 2003 13 23 2002  100 23 2003 112 run; /*I want to change data from 'long' to 'wide*/ /*first need to sort*/ proc sort data = in;by no;run; data temp;     set in;     by no;      /*create a couple of arrays, so now we have a column for each year and each sal*/     keep no yr2001-yr2003 t_sal2001-t_sal2003;     retain yr2001-yr2003 t_sal2001-t_sal2003;     array yr(2001:2003) yr2001-yr2003;     array t_sal(2001:2003) t_sal2001-t_sal2003;     if first.no then do;         do i = 2001 to 2003;             yr(i) = .;             t_sal(i) = .;         end;     end;     yr(year) = year;     t_sal(year) = sal; if last.no then output; run; /*using a couple of IF-THEN we fill in the missing year*/ data temp_1;     set temp;     if yr2003 = . then do;         if yr2002 ne . then yr2003 = yr2002;         if t_sal2002 ne . then t_sal2003 = t_sal2002;         n_entry2003 = "y";     end;     if yr2001 = . then do;         if yr2002 ne . then yr2001 = yr2002;         if t_sal2002 ne . then t_sal2001 = t_sal2002;         n_entry2001 = "y";     end; run; /*re-organize the data to long*/ data want;     set temp_1;     array yr(2001:2003) yr2001-yr2003;     array t_sal(2001:2003) t_sal2001-t_sal2003;     array n_entry(2001:2003) n_entry2001-n_entry2003;     do i = 2001 to 2003;         year = yr(i);         sal = t_sal(i);         new_entry = n_entry(i);         output;     end;     drop yr: t_sal: n_entry:; run; There are probably more compact, efficient way to accomplish this...but this should get you started. Good luck! Anca. ... View more

Thank you. ... View more

In your class statement you use 'reference = 1', which tells SAS that for the variable var1 the reference category is '1'. You need the param = ref to tell SAS to use that reference coding in parameter estimates. ---- ... View more

When I tried to run plots with Logistic with a data set that has more than 5000 observations I get this warning: ------------- WARNING: Some plots have more than 5000 observations and are suppressed.  Specify the          PLOTS(MAXPOINTS=NONE) option in the PROC LOGISTIC statement to display the plots. Did you try this? proc logistic data = my_data plots(maxpoints = none);      model...; ... View more

How about ODS GRAPHICS ON; proc logistic data = your_data plots = (all);      model y = x; run; In my case, the plots are saved on the C:\Documents and Settings\User Good luck, Anca. ... View more