I am working on spaghetti plot using proc sgplot, just wonder if there is a way to add the data value on each data point.  ... View more

dummy question about how to call a macro variable in a title statement.      %macro m(name=, data=); ods listing close;   ods rtf file=".../l_&name..rtf";   title '&name listing';   *** how can I call the "name" variable in title statement?   proc print data=&data noobs; var usubjid visit result ; run;   ods rtf close;   ods listing;   %mend;   %m(bmi, demo);   ... View more

I updated the data as below.   I need to assign baseline values for different groups based on the time points. For example, assign the value of the last record (value at Day 5) in the S1 group to the baseline value for the next group S2 except for baseline of S1 group which is assigned using the result at Day 1. There are about 30 subjects with 6 records (Day 1 to Day 9). Day 1 and Day 5 are for S1, Day 6 and Day 7 are for S2, and Day 8 and Day 9 for S3.   Any input/suggestions will be appreciated. The current data looks like this:   DATA dt; INPUT ID $ grp $ DAY result ; CARDS; 001 s1 1 4.1 001 s1 5 5.0 001 s2 6 3.5 001 s2 7 6.2 001 s3 8 2.5 001 s3 9 1.9 002 s1 1 4.3 002 s1 5 5.1 002 s2 6 3.5 002 s2 7 3.9 002 s3 8 2.5 002 s3 9 1.9 ; RUN;   new data should include baseline value like this- use the last obs of the group as the baseline value for the next group.  DATA newdt; INPUT ID $ grp $ DAY result baseline ; CARDS; 001 s1 1 4.1 4.1 001 s1 5 5.0 4.1 001 s2 6 3.5 5.0 001 s2 7 6.2 5.0 001 s3 8 2.5 6.2 001 s3 9 1.9 6.2 002 s1 1 4.3 4.3 002 s1 5 5.1 4.3 002 s2 6 3.5 5.1 002 s2 7 3.9 5.1 002 s3 8 2.5 3.9 002 s3 9 1.9 3.9 ; RUN;     ... View more