DATA Step, Macro, Functions and more

How to Output Unsorted data

Reply
Contributor
Posts: 52

How to Output Unsorted data

Hi all,

I have Following data In which I want to output not sorted data in another dataset. How??

data  t2;

input subjid rowno tmpoint & $25.;

datalines;

101 1 4 hr

101 2 8 hr

101 3 12 hr

101 4 16 hr

102 1 4 hr

102 2 12 hr

102 3 16 hr

102 4 8 hr

run;

Your help will help me a lot.Thanks In Advance..

Regards,

Dishant

Contributor
Posts: 74

Re: How to Output Unsorted data

don't understand what do you want to do. Please eleobrate the same.

Contributor
Posts: 52

Re: How to Output Unsorted data

Hi,

I Have data like this,

data  t2;

input subjid rowno tmpoint & $25.;

datalines;

101 1 4 hr

101 2 8 hr

101 3 12 hr

101 4 16 hr

102 1 4 hr

102 3 12 hr

102 4 16 hr

102 2 8 hr

run;

Now In Upper data I want output those observations which are not sorted.How?

Contributor
Posts: 74

Re: How to Output Unsorted data

not sure but i think this will work .

data  t2;

input subjid rowno tmpoint & $25.;

datalines;

101 1 4 hr

101 2 8 hr

101 3 12 hr

101 4 16 hr

102 1 4 hr

102 3 12 hr

102 4 16 hr

102 2 8 hr

;

run;

data t2_1;

set t2;

by subjid;

retain cnt  0;

if first.subjid then cnt = 0;

cnt+1;

if cnt ~= rowno then output  t2_1;

run;

Contributor
Posts: 52

Re: How to Output Unsorted data

Hi Tarunkumar,

Thanks and Appreciate For your help and time. This Takes me a new level of Thinking .

Valued Guide
Posts: 2,174

Re: How to Output Unsorted data

Another thought:

Where order is defined by a numeric var, use the DIF() function like :

Data ordered unordered ;

Set your.data ;

by subjID ;

drop difff ;

Difff = dif( rowno ) ;

if first.subjid then output ordered ;

Else  if difff GE 0 then output ordered ;

else output unordered ;

Run ;

Message was edited by: Peter Crawford To fix typos after submitting

Ask a Question
Discussion stats
  • 5 replies
  • 289 views
  • 3 likes
  • 3 in conversation