Help using Base SAS procedures

Problem with Sorting

Reply
Contributor
Posts: 28

Problem with Sorting

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.

Super User
Super User
Posts: 7,392

Re: Problem with Sorting

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;

Ask a Question
Discussion stats
  • 1 reply
  • 170 views
  • 0 likes
  • 2 in conversation