topic Re: Transpose Split Stack in SAS Enterprise Guide

Transpose Split Stack

carmendee — Mon, 11 Jan 2016 17:52:06 GMT

Example data

Supervisor Empl Eval_Date Score

Johnson Smith 1/1/15 25

Johnson Miller 1/1/15 26

Hanson Poole 1/2/15 25

Desired Ouput:

Name Eval_Date Score

Johnson

Smith 1/1/15 25

Miller 1/1/15 26

Hanson

Poole 1/2/15 25

I'm trying to accomplish this without a proc but can if I need to.

Re: Transpose Split Stack

Astounding — Mon, 11 Jan 2016 17:58:27 GMT

I'm not certain that this is a good idea, but here's one way:

data want;

set have;

by Supervisor notsorted;

if first.Supervisor then do;

Name = Supervisor;

output;

end;

Name = Empl;

D = Eval_Date;

S = Score;

output;

keep Name D S;

rename D = Eval_Date;

rename S = Score;

run;

Good luck.

Re: Transpose Split Stack

stat_sas — Tue, 12 Jan 2016 15:31:20 GMT

Another way using sql

data have;
input Supervisor $ Empl $ Eval_Date anydtdte. Score;
format Eval_Date mmddyy8.;
datalines;
Johnson    Smith 1/1/15       25
Johnson    Miller 1/1/15       26
Hanson     Poole 1/2/15       25
;

proc sql;
select distinct supervisor as supervisor from have
union
select * from have
order by supervisor, empl;
quit;