topic Re: macro varibles in SAS Programming

macro varibles

JHE — Thu, 18 May 2017 20:16:08 GMT

%macro LOBNoCode(lobname1,lobname2);

PROC TRANSPOSE DATA=Paid_Claims_Final&lobname1 OUT=Paid_Claims_Final&lobname1TRANS (DROP=_NAME_);

ID MONTH;

BY LOB Category Code CODE_DESCRIPTION;

RUN;

%mend LOBNoCode;

%lobnocode(0100,'0100');

Got the error:

ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATA, DELIM, DELIMITER, INDB, LABEL, LET, NAME, OUT, PREFIX,

SUFFIX.

Do no tknow why

Re: macro varibles

JHE — Thu, 18 May 2017 20:18:48 GMT

table PAID_CLAIMS_FINAL0100 exisiting , no problem

Re: macro varibles

PaigeMiller — Thu, 18 May 2017 20:19:40 GMT

@JHE wrote:

%macro LOBNoCode(lobname1,lobname2);

PROC TRANSPOSE DATA=Paid_Claims_Final&lobname1 OUT=Paid_Claims_Final&lobname1TRANS (DROP=_NAME_);

ID MONTH;

BY LOB Category Code CODE_DESCRIPTION;

RUN;

%mend LOBNoCode;

%lobnocode(0100,'0100');

Got the error:

ERROR 22-322: Syntax error, expecting one of the following: ;, (, DATA, DELIM, DELIMITER, INDB, LABEL, LET, NAME, OUT, PREFIX,

SUFFIX.

Do no tknow why

It's always helpful to show us the entire SASLOG (or the relevant parts related to this PROC) and not just the ERROR message.

As a guess, what happens if you use this, where &lobname1 in the OUT= is followed by a period

PROC TRANSPOSE DATA=Paid_Claims_Final&lobname1 OUT=Paid_Claims_Final&lobname1.TRANS (DROP=_NAME_);

Re: macro varibles

JHE — Thu, 18 May 2017 20:26:25 GMT

attached

Re: macro varibles

Astounding — Thu, 18 May 2017 20:26:30 GMT

On your OUT= designation, SAS doesn't know what the name of the macro variable is. Using lower/upper case isn't enough:

OUT=Paid_Claims_Final&lobname1TRANS

Instead, you have to tell SAS specifically where the name of the macro variable ends by adding a dot:

OUT=Paid_Claims_Final&lobname1.TRANS

Re: macro varibles

ballardw — Thu, 18 May 2017 20:37:33 GMT

It is best to post code and log results into a code box using the forum {i} icon.

Many folks don't want to open Excel or Word documents because of security or corporate policy not allowing the download.

Re: macro varibles

JHE — Thu, 18 May 2017 20:37:44 GMT

This code works.

Thank you

%macro LOBNoCode(lobname1,lobname2);

PROC TRANSPOSE DATA=Paid_Claims_Final&lobname1 OUT=Paid_Claims_Final&lobname1.TRANS (DROP=_NAME_);

ID MONTH;

BY LOB Category Code CODE_DESCRIPTION;

RUN;

%mend LOBNoCode;

%lobnocode(0100,'0100');

Re: macro varibles

JHE — Thu, 18 May 2017 20:38:59 GMT

ok, will do . Thank you remind me.