How to replace text strings for TITLEs inside the macro

Cruise — Sun, 13 Jan 2019 16:46:12 GMT

Hi guys,

I'm trying to assign individual titles to multiple PROC MEANS outputs in the macro as shown below. Any idea how to achieve proc means output has proper TITLEs after the names of datasets? Right now, all proc mean outputs are produced to:

DATA FOR &NAME

%LET NAME=&TAB;
PROC MEANS DATA=&AGE_TAB MIN MAX MAXDEC=2 MEAN MEDIAN;
VAR N_BLOCK;
TITLE 'DATA FOR &NAME';
RUN;

%SYMDEL;
%MACRO MODELS(TAB,TAB1,BLOCK_TAB,AGE_TAB);
PROC SQL;
CREATE TABLE &TAB1 AS SELECT 
...
QUIT;

PROC SQL;
CREATE TABLE &BLOCK_TAB AS
SELECT FIPS, AGECAT,SUM(OUTCOME) AS N_BLOCK
FROM &TAB1
GROUP BY FIPS,AGECAT;
QUIT;

PROC SQL;
CREATE TABLE &AGE_TAB
...FROM &BLOCK_TAB
QUIT;

%LET NAME=&TAB;
PROC MEANS DATA=&AGE_TAB MIN;
VAR N_BLOCK;
TITLE 'DATA FOR &NAME';
RUN;

%MEND MODELS;
%MODELS(Oral_Pharynx  ,Oral_Pharynx_U  ,B_Oral_Pharynx  ,AGE_Oral_Pharynx  );

Re: How to replace text strings for TITLEs inside the macro

PaigeMiller — Sun, 13 Jan 2019 17:16:32 GMT

title "Data for &name";

Use double-quotes, not single quotes, when you are working with a macro variable.

Re: How to replace text strings for TITLEs inside the macro

Cruise — Sun, 13 Jan 2019 18:44:53 GMT

wow, now I KNOW! thank you.

topic Re: How to replace text strings for TITLEs inside the macro in SAS Programming

How to replace text strings for TITLEs inside the macro

Re: How to replace text strings for TITLEs inside the macro

Re: How to replace text strings for TITLEs inside the macro