Rearranging data and then do proc report

[yashpande]

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

[Astounding]

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.

[Ksharp]

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;