topic Re: macros in SAS Programming

macros

pawandh — Sat, 26 Dec 2015 05:07:32 GMT

have to dipslay the datasets starting with name P

proc sql;
select distinct memname into : ab separated by ',' from
dictionary.columns where libname='work' and upcase(memname) like"P%";
%let r=&sqlobs;
quit;

%put &ab &r;

(P1,PATIENT,PAWAN,PAWAN1,PP,PULMICORT_PA,PULMICORT_PH 7)

%macro b(libname);
%do i= 1 %to &r;

proc print data=&libname..%scan(&ab,&i);
run;
%end;
%mend;
%b(work);

getting error -

ERROR: Macro function %SCAN has too many arguments. The excess arguments will be ignored.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand
is required. The condition was: PATIENT
ERROR: Argument 2 to macro function %SCAN is not a number

Re: macros

Reeza — Sat, 26 Dec 2015 06:02:37 GMT

If a macro variable parameter has comma's how does SAS know which is part of the macro %scan, and which is part of the macro variable. Try using a different delimiter for your macro variable list.

Re: macros

Ksharp — Mon, 28 Dec 2015 01:36:28 GMT

It is a job interview question for some CRO corporation ?

%macro b(libname);
data _null_;
 set sashelp.vmember(where=(libname="%upcase(&libname)" and upcase(memname) like "P%"));
 call execute(cats('proc print data=',libname,'.',memname,';run;'));
run;
%mend;
%b(work)

Re: macros

pawandh — Mon, 28 Dec 2015 01:53:00 GMT

No it is not a job interview question.:)
here vmember is a data set name?

Re: macros

Ksharp — Mon, 28 Dec 2015 01:55:16 GMT

it could VIEW or CATALOG , any sas member. if you only want TABLE add another option datatype='data' . If your libname only contain TABLE, that is not a question.

Re: macros

Ksharp — Mon, 28 Dec 2015 02:00:07 GMT

%macro b(libname);
data _null_;
 set sashelp.vmember(where=(libname="%upcase(&libname)" and upcase(memname) like "P%" and memtype='DATA'));
 call execute(cats('proc print data=',libname,'.',memname,';run;'));
run;
%mend;
%b(work)

Updated

Re: macros

pawandh — Mon, 28 Dec 2015 02:23:13 GMT

sorry but not able to understand ...here v r copying the data from sashelp library(set sashelp) then how v can give this libname condition as already v have defined the library..Plz explain

Re: macros

Ksharp — Mon, 28 Dec 2015 02:24:54 GMT

Sorry. It is a VIEW . while dictionary.members is a TABLE .

Re: macros

Ksharp — Mon, 28 Dec 2015 02:27:31 GMT

You can use this view as a table (dictionary.members) at anywhere, most likely in data step . This view can use other data set option too like KEEP DROP .........