I'm trying to plot an average transition/mean and SD chart with sgplot+limitstat. Elapsed time for the x-axis, use the variable VISITN. The visit numbers are 0 6 7. (Baseline, Week 6, Week 7) The time intervals on the x-axis are evenly spaced. It is as if you are displaying Baseline Week1 Week2. What should I do to reflect the actual time as shown in the figure? Please help me. == What I try/search == We CAN NOT do this with limitstat? There was a sample that went through 1 data step and used scatter, yerrorlower, yerrorupper instead of limitstat. https://www.sas.com/content/dam/SAS/ja_jp/doc/event/sas-user-groups/usergroups11-b-19.pdf (About Sample program, I also Thank to this site.) data TEST;
ID =1;TREAT ="Placebo";GENDER ="Male";CAT =3;Visit ="Baseline";Visitn =0;VAL =54.9;output;
ID =1;TREAT ="Placebo";GENDER ="Male";CAT =3;Visit ="Week 6";Visitn =6;VAL =52.4;output;
ID =1;TREAT ="Placebo";GENDER ="Male";CAT =3;Visit ="Week 7";Visitn =7;VAL =62.9;output;
ID =2;TREAT ="TAK-XXX XXmg";GENDER ="Female";CAT =3;Visit ="Baseline";Visitn =0;VAL =56.9;output;
ID =2;TREAT ="TAK-XXX XXmg";GENDER ="Female";CAT =3;Visit ="Week 6";Visitn =6;VAL =47.4;output;
ID =2;TREAT ="TAK-XXX XXmg";GENDER ="Female";CAT =3;Visit ="Week 7";Visitn =7;VAL =69.9;output;
ID =3;TREAT ="TAK-XXX XXmg";GENDER ="Male";CAT =1;Visit ="Baseline";Visitn =0;VAL =64.9;output;
ID =3;TREAT ="TAK-XXX XXmg";GENDER ="Male";CAT =1;Visit ="Week 6";Visitn =6;VAL =55.8;output;
ID =3;TREAT ="TAK-XXX XXmg";GENDER ="Male";CAT =1;Visit ="Week 7";Visitn =7;VAL =46.7;output;
ID =4;TREAT ="TAK-XXX XXmg";GENDER ="Male";CAT =2;Visit ="Baseline";Visitn =0;VAL =54.5;output;
ID =4;TREAT ="TAK-XXX XXmg";GENDER ="Male";CAT =2;Visit ="Week 6";Visitn =6;VAL =47.9;output;
ID =4;TREAT ="TAK-XXX XXmg";GENDER ="Male";CAT =2;Visit ="Week 7";Visitn =7;VAL =59.6;output;
ID =5;TREAT ="Placebo";GENDER ="Male";CAT =2;Visit ="Baseline";Visitn =0;VAL =39.6;output;
ID =5;TREAT ="Placebo";GENDER ="Male";CAT =2;Visit ="Week 6";Visitn =6;VAL =56.1;output;
ID =5;TREAT ="Placebo";GENDER ="Male";CAT =2;Visit ="Week 7";Visitn =7;VAL =42.1;output;
ID =6;TREAT ="TAK-XXX XXmg";GENDER ="Female";CAT =1;Visit ="Baseline";Visitn =0;VAL =50.3;output;
ID =6;TREAT ="TAK-XXX XXmg";GENDER ="Female";CAT =1;Visit ="Week 6";Visitn =6;VAL =52.3;output;
ID =6;TREAT ="TAK-XXX XXmg";GENDER ="Female";CAT =1;Visit ="Week 7";Visitn =7;VAL =63.5;output;
run;
proc sgplot data=TEST ;
vline VISIT /
response = VAL
group = TREAT
stat = mean
limitstat = stddev
numstd = 1
markers
markerattrs
= (symbol=circlefilled) ;
run ; Result what I want
... View more