Hi,
I have a question related to SAS join.
I have a dataset one which has the variable country, year,state
Country year state match
USA 2017` CA Y USA 2017 PA y
USA 2016 TX y
I have dataset two which is a lookup table with few rows and has the columns country,year state , region.
Country year state region
USA 2017 CA R1 USA 2017 R2 USA 2017 PA R3
I am looking to attach region to the dataset one
Proc sql;
Select a.* ,b.region from one a
Left join
Two b
On a. year=b.year and
a.country =b. country
and a.state=b.state;
quit;
is there any way I can modify the above code so that for all the states except , CA and PA(states which are existing in the second table) the value of R2 gets assigned during the join..
Editing to add more details.
for a record in dataset one if the country is USA and year is 2017 and state is CA the region needs to be R1,if the country is USA and year is 2017 and state is PA the region needs to be R3 and for all the other states whose year is 2017 and country is USA the region needs to be r2
Thanks in advance,
regards,
Sheeba
... View more