Hello,   What is the purpose of naming macro variable same as the  parameter name?   %macro test (param1 = , param2 = ,) %local param1 param2; %let param1 = &param1; %let param2 = &param2; ..... ..... %mend test; %test   ... View more

Hello,   I am trying to get specified variables from all data sets in a library. The code shown is just for one data set. I wonder if this can be automated using CALL EXECUTE or by other means for all data sets.   proc sql noprint; select name into: list_var separated by ', ' from dictionary.columns where upcase(libname) = 'X' and upcase(memname) = 'Y' and (strip(upcase(name)) like '%DAY' or strip(upcase(name)) like '%MON' or strip(upcase(name)) like '%YR'); quit; %put &list_var; proc sql noprint; create table t1 as select &list_var from X.Y ; quit; ... View more

Hello,   Is it legal to use same parameter in both outer and inner macro here?     %macro inner (ds = ); proc print data = &ds.; run; %mend; %macro outer (ds =); %inner(ds = &ds.); %mend outer; %outer (ds = sashelp.class)         ... View more

Hello,   Why the ampersand (&) is not required  for macro variable filrf in this example ?   %let filrf=myfile; %let rc=%sysfunc(filename(filrf, physical-filename)); %if &rc ne 0 %then %put %sysfunc(sysmsg()); %let rc=%sysfunc(filename(filrf)); ... View more

Hello:   I am trying to get only character variables using the following program.   %macro m; %let dsid = %sysfunc(open(sashelp.class)); proc sql noprint; create table t1 as select %do i = 1 %to 5; %if %sysfunc(vartype(&dsid, &i)) = 'C' %then %sysfunc(varname(&dsid, &i)),; %end; from sashelp.class; quit; %mend m; %m ... View more