options yearcutoff=1950; %macro y2kopt(date2); %if &date2 >= 14610 %then %do; options yearcutoff=2000; %end; %else %do; options yearcutoff=1900; %end; %mend; %let date=14610; options yearcutoff=1920; %y2kopt(&date) The SAS date for January 1, 2000, is 14610. What is the value of YEARCUTOFF when the macro Y2kopt finishes execution?    a.   1900  b.   1920  c.   1950  d.   2000 ... View more

Hi,  I'm experiencing two issues when I create CSV file 1- this window pops up and I don't want that to happen 2-I don't need the table to be created on the SAS system             ... View more

Hi,  I'm trying to output a CSV file and the macro can't be resolved for some reasons it output the macro without resolving     ods csvall file='R:Location\Adjudication Status Metrics_&date..csv';   in the destination that's the file name I got    Adjudication Status Metrics_&date.csv ... View more

  Hi,  I have this project and  I want to know if I would have the ability to color the cells by using  SAS. For example, if the billed to date is more than 75% the cell color should be red and delta is less than %25  also the cell color should be red. otherwise, it should be green.    Can you show me how a brief example of that if there is a way to do this???  ... View more

Hi,  I have this code data have; input study_name $ June July August; datalines; A 20 16 39 B 18 18 6 C 19 1 5 D 87 65 115 E 63 55 62 F 81 104 87 G 73 19 49 H 189 69 79 I 28 6 8 J 87 83 52 K 0 0 0 L 0 0 0 M 4 1 1 N 1 0 2 O 212 159 304 ; proc transpose data=have out=trans name=Month; by study_name; var June July August; run; Proc sgplot data=trans; vbar month / response=col1 group=study_name; yaxis grid display=(nolabel); Xaxis display=(nolabel); run;     which produces this result in the picture.  Note that the months in the bar chart are not displayed as they are in their order, they have alphabetical order.  I tried to find an option to change that but I couldn't find. Also, I don't need to display the study_name in the chart and don't know how to change the default.    ... View more

Hi,  I have a dataset which I want to create a bar chart looks like this    and this is the dataset I'm using          Obs study_name June July August 1 A 20 16 39 2 B 18 18 6 3 C 19 1 5 4 D 87 65 115 5 E 63 55 62 6 F 81 104 87 7 G 73 19 49 8 H 189 69 79 9 I 28 6 8 10 J 87 83 52 11 K 0 0 0 12 L 0 0 0 13 M 4 1 1 14 N 1 0 2 15 O 212 159 304       data have; input study_name $ June July August; datalines; A 20 16 39 B 18 18 6 C 19 1 5 D 87 65 115 E 63 55 62 F 81 104 87 G 73 19 49 H 189 69 79 I 28 6 8 J 87 83 52 K 0 0 0 L 0 0 0 M 4 1 1 N 1 0 2 O 212 159 304 ; ... View more

Hi,  I'm trying to subset the observations that match the criteria  by if statement but my code below  doesn't work  I know I can do it by where statement  but I also want to do it by if    data new; set have; if subject_id ne "%999%"; run; sample of the data    subject_id 200018001 200018002 200018003 200018005 200019999 200019999 200028001 200028002 200028005 200029999 200059999 200079999 200089999 200089999 200098001 200098002 200098003 200098004 200099999 200108001 200108002 200108003 200108004 200109999         ... View more