The output looks right:     ... View more

*Here is one way of doing it; title "Odds Ratios with 95% Wald Confidence Limits"; proc sgplot data=forest noautolegend; scatter y=Study x=oddsratio / xerrorlower=LowerCL xerrorupper=UpperCL markerattrs=(symbol=diamondfilled) datalabel=oddsratio datalabelattrs=(weight=bold); scatter y=study x=lowercl / datalabel = lowercl markerattrs=(size=0 color=crimson); scatter y=study x=uppercl / datalabel = uppercl markerattrs=(size=0 color=crimson); refline 1 / axis=x; * xaxis grid type=log label="Odds Ratio (log scale)"; /* specify log scale */ * yaxis grid display=(nolabel) discreteorder=data reverse; run; ... View more

@Reeza, I have a quick follow-up question: Is there a way to make xerrorlower and xerrorupper (i.e., odds ratio) values to appear above the tick marks? Many thanks! ... View more

The displayed output for this procedure can be found here: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/statug/statug_surveylogistic_details66.htm#statug_surveylogistic010268 You can chose the output tables with corresponding syntax. ... View more

I already built it with a continuous variable. Just trying to determine if there are additional benefits to be had from using time as an ordinal variable. ... View more

Thank you, this is a very nice website. The times are all in minutes. If I subtract the mean from times to center them, many will be negative. ... View more

@Reeza, could you please be more specific?   ... View more

%let &nrows = ..; *number of rows in you dataset; %macro new_rows; *makes new rows; %do i = 1 %to &nrows; 1) little row data set; data part1; set have; keep id date:; if _N_=&i; run; 2) delete empty cells; ods select nlevels; proc freq data=work.my_data nlevels; ods output nlevels=work.nlevels_my_data; run; proc sql; select TableVar into :empty_columns separated by "," from part1 where nnonmisslevels = 0; quit; proc sql; alter table part1 drop &emptycolumns; quit; 3) rename variables; data part1; set part1; https://communities.sas.com/t5/SAS-Programming/Rename-all-variables/td-p/500828?nobounce; 4) saving one row to be set; data row&i; set part1; run; %mend t; 5) set all rows; data whole; %macro setter; %do i=1 %to &nrows; row&i %end; run; %mend setter; ... View more

I will write pseudo-code for this. Keep only the ids and the dates. Take each row into a little dataset and delete all the missing date cells/columns. Rename the remaining date variables. Set the rows. Merge to the other part of the initial dataset (ids and the values). Deleting missing date cells is tricky because SAS does not do conditional variable drops. The info how to do that is here: https://sasexamplecode.com/how-to-identify-remove-empty-columns-in-sas/ ... View more

Thank you for helpful suggestions! A simple solution will do for now :). ... View more