DATA Step, Macro, Functions and more

Rearranging data and then do proc report

Reply
Contributor
Posts: 40

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,085

Re: Rearranging data and then do proc report

[ Edited ]

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: 9,682

Re: Rearranging data and then do proc report

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
  • 170 views
  • 0 likes
  • 3 in conversation