DATA Step, Macro, Functions and more

data transformation into panel data

Reply
New Contributor
Posts: 2

data transformation into panel data

Hi everyone, 

 

I am trying to transform data into panel data to perform an analysis. 

I have data as "Have" and need to have "Want"

 

how would I do this in easy step?

 

"Have"

Dateamazonwalmart
1/1/2018         1,376            854
2/1/2018         1,283         7,496
3/1/2018            792         2,258

 

"Want"

DateClientvalue
1/1/2018amazon         1,376
2/1/2018amazon         1,283
3/1/2018amazon            792
1/1/2018walmart            854
2/1/2018walmart         7,496
3/1/2018walmart         2,258
Super User
Posts: 6,785

Re: data transformation into panel data

Does it need to be complicated?

 

data want;

set have;

length client $ 32;

client = 'amazon';

value = amazon;

output;

client = 'walmart';

value = walmart;

output;

keep date client value;

run;

 

proc sort data=want;

by client;

run;

 

If you have hundreds of clients, we can revisit other possibilities.

Super User
Posts: 23,771

Re: data transformation into panel data

PROC TRANSPOSE - wide to long is what you're looking for, the UCLA SAS tutorial page has examples of how to do this either with a data step or PROC TRANSPOSE. Your data is well structured for a PROC TRANSPOSE.

 


@sasmaven wrote:

Hi everyone, 

 

I am trying to transform data into panel data to perform an analysis. 

I have data as "Have" and need to have "Want"

 

how would I do this in easy step?

 

"Have"

Date amazon walmart
1/1/2018          1,376             854
2/1/2018          1,283          7,496
3/1/2018             792          2,258

 

"Want"

Date Client value
1/1/2018 amazon          1,376
2/1/2018 amazon          1,283
3/1/2018 amazon             792
1/1/2018 walmart             854
2/1/2018 walmart          7,496
3/1/2018 walmart          2,258

 

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