Transpose Split Stack

[carmendee]

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.

[Astounding]

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.

[stat_sas]

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;