Help using Base SAS procedures

How to traspose a table?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 75
Accepted Solution

How to traspose a table?

Hallo, I have a table like this

Date                       ID               return

....

....

and I would like to transpose it to have something like

date                100048              100055

Can anyone tell me how can I get this? Thanks alot


Accepted Solutions
Solution
‎11-20-2012 07:30 PM
Respected Advisor
Posts: 4,641

Re: How to traspose a table?

This is a basic transposition problem. However, the resulting variable names cannot be numbers, with the following code, they will be like V100048 and V100055 :

proc sort data=have; by date; run;

proc transpose data=have out=want(drop=_Smiley Happy prefix=V;

by date;

id id;

var return;

run;

PG

PG

View solution in original post


All Replies
PROC Star
Posts: 7,357

Re: How to traspose a table?

How about?:

proc sort data=have;

  by date;

run;

proc transpose data=have out=want (drop=_Smiley Happy;

  var return;

  id id;

  by date;

run;

Solution
‎11-20-2012 07:30 PM
Respected Advisor
Posts: 4,641

Re: How to traspose a table?

This is a basic transposition problem. However, the resulting variable names cannot be numbers, with the following code, they will be like V100048 and V100055 :

proc sort data=have; by date; run;

proc transpose data=have out=want(drop=_Smiley Happy prefix=V;

by date;

id id;

var return;

run;

PG

PG
Frequent Contributor
Posts: 75

Re: How to traspose a table?

Thank you !!

Super User
Posts: 9,671

Re: How to traspose a table?

Assuming id is a numeric variable.

data have;
do date='31aug2011'd to '31dec2011'd;
 id=100048;return=2;
 output;
end;
do date='31jan1980'd to '30apr1980'd;
 id=100055;return=2;
 output;
end;
run;
proc sql;
 select distinct cats('have(rename=(return=_',id,') where=(id=',id,'))') into : list separated by ' ' 
  from have;
quit;
data want;
 merge &list ;
 by date ;
run;

Ksharp

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 221 views
  • 6 likes
  • 4 in conversation