Hello all, Please have a look on this- I have written one sql code and applied macros on it- The Macro looks like- %Macro Result (Cod, Report); proc sql; connect to oracle (user=xxxx password=xxxx path='xxx'); create table One as select * from connection to oracle ( select p1, p2, p3, Code from Two where code= &Cod; disconnect from oracle; quit; data &report; set one; . . . . run; %Mend; % Result (Code = , Report = Rpt1_overall); % Result (Code = 23 , Report = Rpt2); % Result (Code = 43, Report = Rpt3); % Result (Code = 32, Report = Rpt4); Here, I don't have problem with last three macros but for the fist macro I don't want to define any code (value). in the proc sql step, I just want to select code, no 'where' condition. So how can I do so? Hope you understand this query. Regards Dipu
... View more