Dear all, Here is my scenario, I need to change the table name used in PROC SQL dynamically(Highlighted in code) and use the same code for different names of table from database. I know for sure there are ways to do this (May be looping array) but instead of referring SAS documentation , I need any one of your help to provide me an glimpse of an idea about how can achieve this. in below sample, I want to change the dataset name BKD1 and table name bkd(FROM statement) dynamically Below code.. proc sql;
create table dummy.BKD1 as select
count(case when CD= 'N' then 1 end) as Count_NewRecord,
count(case when CD= 'C' then 1 end) as COUNT_Changed,
count(case when CD= 'D' then 1 end) as Count_Duplicate
from layer.bkd ;
quit;
... View more
