Hello I want to merge the two tables below
A00 falls in the range A00-A09 therefore I need to add the range A00-A09 and the description column to the table 1 with 3500 rows
How would I do that
Table 1 (3,500 rows)
A00 Desc column
A01 Desc
A02 Desc
Table 2 (293 rows)
A00-A09 Shortname
Does the data have one or two variables here? Please be more specific about what your data looks like
Thankyou for your response I resolved the same
Post test data in the form of a datastep please. As such this is just a guess:
proc sql; create table want as select a.*, b.shortname from table1 a left join table2 b on char(a.code,1)=char(b.code,1) an input(substr(scan(b.code,1,"-"),2),best.)<=input(substr(a.code,2),best.)<=input(substr(scan(b.code,2,"-"),2),best.); quit;
So effectively I am saying where the first character of code match and the numeric parts code is between the numeric part of left hand table2 code and right part of table 2 code.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.