topic Re: Macro issue with line/column error in SAS Programming

Macro issue with line/column error

Paul_NYS — Wed, 26 Dec 2012 14:30:13 GMT

I am not familiar with macros, but created one below and ran it a few times and keep getting an error for "214: LINE and COLUMN cannot be determined" and "ERROR 214-322: Variable name & is not valid." Line 214 in the below statement is the red, bolded run statement, so I am assuming SAS is barfing on the "drop _TYPE_ &c_Q3;" that precedes it. Is there any issue with using variables in macros to define column names?

Paul

%macro issueJoined (a,b,c,d);

proc sort data=&a out=&a;

by &b;

run;

proc means data=&a;

var &c;

by &b;

output out=issue1 n= nmiss= median= q3= /autoname;

run;

data issueMedian (rename=(_FREQ_=TotalChildren &c_N=NumberIssue

&c_NMiss=NumberMissingIssue &c_Median=MedianNumber

&c_Q3=ThirdQuartile));

set issue1;

if &c_N >= &c_NMiss;

drop _TYPE_ &c_Q3;

run;

data issueThirdQ (rename=(_FREQ_=TotalChildren &c_N=NumberIssue

&c_NMiss=NumberMissingIssue &c_Median=MedianNumber

&c_Q3=ThirdQuartile));

set issue1;

if &c_N >= (round(.75*_FREQ_));

drop _TYPE_ &c_Median _FREQ_ &c_N &c_NMiss;

run;

proc sort data=issueMedian;

by &b;

run;

proc sort data=issueThirdQ;

by &b;

run;

data &d;

merge issueMedian issueThirdQ;

by &b;

run;

%mend issueJoined;

%issueJoined (issuejoinedNNNA, cnty_name filingYear, dur_filing_issuejoin, issueCountiesFinal);

Re: Macro issue with line/column error

Linlin — Wed, 26 Dec 2012 14:40:53 GMT

try adding . after &c in &c_N and other places.

&c_n should be &c._n

Re: Macro issue with line/column error

Paul_NYS — Wed, 26 Dec 2012 14:56:06 GMT

Thanks Linlin, that was it. When I looked at Marco language, I didn't see the period that gets added to variables when they are part of strings.

Paul

Re: Macro issue with line/column error

kuridisanjeev — Wed, 26 Dec 2012 15:07:43 GMT

Hi paul..

Out= option not required in your first proc Sort code...

Thanks..

Sanjeev.K

Re: Macro issue with line/column error

Paul_NYS — Wed, 26 Dec 2012 16:06:39 GMT

Thanks Sanjeev. I left that in, you are right.

Paul