Problem with Sorting

makset — Wed, 03 Dec 2014 12:02:31 GMT

Hello

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.

Re: Problem with Sorting

RW9 — Wed, 03 Dec 2014 12:49:55 GMT

Hi,

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:

data want;

set have;

retain all_priority;

if _n_=1 or priority ne . then all_priority=priority;

run;

proc sort data=want;

by all_priority 30_min;

run;

topic Re: Problem with Sorting in SAS Procedures

Problem with Sorting

Re: Problem with Sorting