DATA Step, Macro, Functions and more

Rearranging data and then do proc report

Reply
Contributor
Posts: 44

Rearranging data and then do proc report

I have below dataset and need to arrange the first observation by group which I want to use in proc report in next step .. But somehow with First. I am unable to get Desiree output. Can somebody help me here

Dataset Have :

Key1 desc key2
1 Akshay Nagpur
1 Rahul Nagpur
1 Rajesh Nagpur


Desired Want Dataset as

Key1 Desc Key2
1 Akshay Nagpur
. Rahul
. Rajesh

Any help is really appreciated
Super User
Posts: 5,518

Re: Rearranging data and then do proc report

[ Edited ]
Posted in reply to yashpande

The good news:  it's easy to get the data values that you illustrated.

 

The bad news:

 

  • If you do change the data, there is no guarantee that PROC REPORT will work properly.  You will have to try it and see.
  • You haven't illustrated what should happen to KEY1, when there is a new value for KEY2.  So I will guess at that part.

 

proc sort data=have;

by key1 key2 desc;

run;

 

data want;

set have;

by key1 key2;

if first.key1=0 then key1=.;

if first.key2=0 then key2=' ';

run;

 

Start there, and see if it solves all the issues.  It might.

Super User
Posts: 10,046

Re: Rearranging data and then do proc report

Posted in reply to yashpande
As long as you apply ORDER option on KEY1 KEY2, you gonna get the result you want.


data have;
input Key1 desc $ key2 $;
cards;
1 Akshay Nagpur
1 Rahul Nagpur
1 Rajesh Nagpur
;
run;
proc report data=have nowd;
columns KEY1 desc KEY2;
define KEY1/order;
define KEY2/order;
run;

Ask a Question
Discussion stats
  • 2 replies
  • 197 views
  • 0 likes
  • 3 in conversation