topic Re: How to Output Unsorted data in SAS Programming

How to Output Unsorted data

dishant — Mon, 17 Feb 2014 06:28:47 GMT

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

Re: How to Output Unsorted data

TarunKumar — Mon, 17 Feb 2014 07:32:33 GMT

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

Re: How to Output Unsorted data

dishant — Mon, 17 Feb 2014 08:17:48 GMT

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?

Re: How to Output Unsorted data

TarunKumar — Mon, 17 Feb 2014 12:36:24 GMT

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;

Re: How to Output Unsorted data

dishant — Tue, 18 Feb 2014 04:32:53 GMT

Hi Tarunkumar,

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

Re: How to Output Unsorted data

Peter_C — Fri, 14 Mar 2014 16:42:14 GMT

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