How do you guys investigate where these additional rows came from?
I tried adding a variable in one of the data sets before doing the left join
data original_tbl_1; set table1;
testvar = 1;
run;
then in the following step I do the left join
I thought I could just find where 1 doesn't exist after I run the left join, but it turns out all the addition rows are also filled out with testvar =1
😞
Any advice on how I can go about doing this?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.