data have;
input Date :date9.;
format Date date9.;
datalines;
01oct2021
10oct2021
05oct2021
11oct2021
01oct2021
05oct2021
10oct2021
;
proc sort data = have nodupkey;
by Date;
run;
proc transpose data = have out = want prefix = d;
var Date;
run;
However, usually its not a good thing to do because it makes the next steps (the analysis, or the report) more difficult. Would you be kind enough to tell us what the next steps (analysis or report) will be?
I'd recommend adding an IDLABEL option here and have the label be the date.
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.