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
don't understand what do you want to do. Please eleobrate the same.
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?
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;
Hi Tarunkumar,
Thanks and Appreciate For your help and time. This Takes me a new level of Thinking .
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.