topic Re: Rearranging data and then do proc report in SAS Programming

Rearranging data and then do proc report

yashpande — Tue, 23 Aug 2016 17:16:36 GMT

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

Re: Rearranging data and then do proc report

Astounding — Tue, 23 Aug 2016 17:55:34 GMT

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.

Re: Rearranging data and then do proc report

Ksharp — Wed, 24 Aug 2016 02:29:09 GMT

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;