BookmarkSubscribeRSS Feed
ZRick
Obsidian | Level 7

Why following doesn't work? how do I fix it?

I want to left join first on p_id, then on instid. but you see the last row in h dataset in the resultant data set doesn't exist, which is not correct.


data t;

input instid p_id wt;

cards;

1 1 .5

1 2 .3

;

data h;

input instid p_id pv;

cards;

1 1 3

1 2 4

1 3 10

;

proc sql;

create table fnl as

select h.*, t.wt from t left join h on t.instid = h.instid and t.p_id = h.p_id

order by instid, p_id;

quit;

1 REPLY 1
PGStats
Opal | Level 21

That's the way it should be. If you want all lines from h then you should ask for a right join instead. - PG

PG

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

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