10-11-2017 01:19 AM
Hi SAS users,
I needed some help in creating the below table.Currently it is generating 0 records. It is not able to filter the job in the SQL statement in rule_name variable & branch variable in platform.
%let job = abc;
libname test oracle user="XXX" password= "XXX" path='XXX' schema=test;
proc sql ;
create table &job as
select * from test.test_table
where RULE_NAME = '&job'
and Platform= substr('&branch',1,4)
10-11-2017 01:39 AM
Use double quotes when you want your macro variables to resolve in string literals. Macro triggers are not recognized when enclosed in single quotes.
10-11-2017 05:46 AM
10-11-2017 05:55 AM
Inspect your data. It may be necessary to use normalizing functions like upcase() or trim(), left(), strip().