12-03-2014 07:02 AM
I have a little problem with sorting
I have tables with time series and piority as shown below
and I would sort it in the following way
Somehow it is in sas?
Thank you for your help.
12-03-2014 07:49 AM
Well, retain priority (typo>??), in a datastep, so that it appears on each row (if you don't want to keep it then new variable). Then sort by priority and 30 min:
if _n_=1 or priority ne . then all_priority=priority;
proc sort data=want;
by all_priority 30_min;