Hi,
I got struck, help me on this.
I have a table Empldata (EMP_ID is in character format and Interest is in Numeric Format)
EMP_ID Interest
101 .2
202 .4
303 .7
404 .1
I have Another Table EMPL_Hierarachy (all columns are in Character format)
L1_ID(Empl ID) L2_ID (Reporting Manager ID) L3_ID (Senior Manager ID) L4_ID (Head of All Empls)
101 202 303 404
I need I output table like below
EMP_ID Interest L1_ID L2_ID L3_ID L4_ID
101 .2 101 202 303 404
202 .4 202 303 404
303 .7 303 404
404 .1 404
OR
EMP_ID Interest L1_ID L2_ID L3_ID L4_ID
101 .2 101 202 303 404
202 .4 202
303 .7 303
404 .1 404
Please can some body help me on this.
Thanks in Adavance
Teja
Assuming it's OK to give you exactly what you asked for ...
data want;
if _n_=1 then set EMPL_Hierarchy;
array L_ {4} L1_ID L2_ID L3_ID L4_ID;
set EmplData;
if _n_ > 1 then L_{_n_-1} = ' ';
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: