BookmarkSubscribeRSS Feed
TejaSurapaneni
Lapis Lazuli | Level 10

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  

1 REPLY 1
Astounding
Opal | Level 21

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;

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

What is Bayesian Analysis?

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 564 views
  • 0 likes
  • 2 in conversation