topic Re: Macro Variable within an Infile Statement in SAS Programming

Macro Variable within an Infile Statement

agbpilot — Sun, 10 Mar 2019 22:37:41 GMT

Hi, I'm trying to create a date macro variable and then insert it into an infile statement where I'm reading in a text file. However, I'm getting the following error. I've read through some of the posts and see similar posts but can't find one that specifically addresses my example here. Could you please help?

Andy

DATA _NULL_ ;
FORMAT CURR_YR LST_YR YEAR4.;

CURR_YR = INTNX('YEAR',TODAY(),0);
LST_YR = INTNX('YEAR',TODAY(),-1);

CALL SYMPUT('CURR_YR','"'||PUT(CURR_YR,YEAR4.)||'"');
CALL SYMPUT('LST_YR','"'||PUT(LST_YR,YEAR4.)||'"');
RUN;

%PUT
CURRENT YEAR: &CURR_YR
LAST YEAR: &LST_YR
;

INFILE '/folders/myfolders/tarrant/input_data/prior_yr/PropertyData_R_'&LST_YR'.txt' delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2;

LOG:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

73 DATA USER.LST_YR_VALUES (DROP=RP APPRAISAL_YEAR RECORD_TYPE SEQUENCE_NO PIDN TAD_MAP MAPSCO STATE_USE_CODE

73 ! NUM_SPECIAL_DIST DEED_BOOK DEED_PAGE

74 ARB_INDICATOR CENTRAL_HEAT_IND CENTRAL_AIR_IND STRUCTURE_COUNT FROM_ACCTS GIS_LINK INSTRUMENT_NO OVERLAP_FLAG

75 GARAGE_CAPACITY OWNER_ZIP4);

76 INFILE '/folders/myfolders/tarrant/input_data/prior_yr/PropertyData_R_'&LST_YR'.txt' delimiter = '|' MISSOVER DSD

76 ! lrecl=32767 firstobs=2;

NOTE: Line generated by the macro variable "LST_YR".

76 '/folders/myfolders/tarrant/input_data/prior_yr/PropertyData_R_'"2018"

______

ERROR 23-2: Invalid option name "2018".

Re: Macro Variable within an Infile Statement

VDD — Sun, 10 Mar 2019 22:56:42 GMT

try this

INFILE '/folders/myfolders/tarrant/input_data/prior_yr/PropertyData_R_'&LST_YR'.txt' delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2;INFILE '/folders/myfolders/tarrant/input_data/prior_yr/PropertyData_R_"&LST_YR.".txt' delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2;

Re: Macro Variable within an Infile Statement

Astounding — Sun, 10 Mar 2019 23:28:24 GMT

Here's how to include a macro variable within a text string. Notice the extra dot, as well as double quotes instead of single quotes:

INFILE "/folders/myfolders/tarrant/input_data/prior_yr/PropertyData_R_&LST_YR..txt" delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2;

Re: Macro Variable within an Infile Statement

agbpilot — Thu, 14 Mar 2019 00:39:48 GMT

Thank you, this works!