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;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.