DATA Step, Macro, Functions and more

Setting Up Panel Data

Reply
New Contributor
Posts: 4

Setting Up Panel Data

[ Edited ]

I am having trouble setting up my data as a panel in SAS. My id variable is company ticker. As such, it is categorical in nature. Do I need to encode it before I set it up as a panel in SAS or is it okay to keep it as it is? 

In STATA I use encode for that purpose.

 

As seen from the following snapshot, 'symbol' is my id variable.

 

Data_Snapshot

Super User
Posts: 9,681

Re: Setting Up Panel Data

PROC TRANSPOSE:

 

 

proc transpose data=have out=want;

by date;

id symbol;

var trd_val;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 100 views
  • 0 likes
  • 2 in conversation