topic Re: data transformation into panel data in SAS Programming

data transformation into panel data

sasmaven — Thu, 28 Jun 2018 21:03:27 GMT

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

Re: data transformation into panel data

Astounding — Thu, 28 Jun 2018 21:14:46 GMT

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.

Re: data transformation into panel data

Reeza — Thu, 28 Jun 2018 21:36:19 GMT

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