topic Re: macro error using inputn in SAS Programming

macro error using inputn

sasboy007 — Wed, 11 Mar 2015 13:03:44 GMT

Hi all,

I have the below:

%let date1='08/01/2013'

%LET xDate = inputn(%sysfunc(compress(&date1,"")),"yyyymm.");

However, xDate never gets the changed date format (yyyymm) based on the above.

Re: macro error using inputn

Kurt_Bremser — Wed, 11 Mar 2015 13:16:07 GMT

First of all, your code has a syntax error (missing the semicolon after the %let)

Second, inputn is a data step function that will not work on its own in a macro statement.

Third, yyyymm is not a valid SAS format, but yymm is.

to make it simple, use a data step:

%let date1=08/01/2013;

data _null_;

datenew = put(input("&date1",mmddyy8.),yymm.);

call symput("xdate",datenew);

run;

%put "&xdate";

Re: macro error using inputn

RW9 — Wed, 11 Mar 2015 13:54:25 GMT

Just to add to that, why not keep the date in a parameter dataset and use it from there, e.g. joining it on. It avoids that whole nasty macro variable processing of converting string to date and back again.

Re: macro error using inputn

ballardw — Wed, 11 Mar 2015 15:01:28 GMT

Or use a proper date literal such as '01AUG3013'd

Re: macro error using inputn

Tom — Wed, 11 Mar 2015 15:20:03 GMT

I think that your real error is not specifying a length on your INFORMAT. You also have messed up values because of extra quotes. Macro variables are always text strings, so unless you want to include the quotes in the value do not use quotes. This also applies to character arguments for function calls.

Note that you can also add a format to the %SYSFUNC() call to specify how you want SAS to convert the answer of the INPUTN() function call, which will be a number, to the string that you are assigning to your macro variable.

Here is an example with a few different output formats.

XDATE1 or XDATE4 could be used in SAS code to reference the date.

XDATE2 or XDATE3 could be used as strings to use in TITLE or other place.

%let date1=8/1/2013;

%LET xDate1 = %sysfunc(inputn(&date1,mmddyy10));

%let xDate2 = %sysfunc(inputn(&date1,mmddyy10),mmddyy10);

%LET xDate3 = %sysfunc(inputn(&date1,mmddyy10),date9);

%LET xDate4 = "%sysfunc(inputn(&date1,mmddyy10),date9)"d;

%put &=date1 &=xDate1 &=xDate2 &=xDate3 ;

DATE1=8/1/2013 XDATE1=19571 XDATE2=08/01/2013 XDATE3=01AUG2013 XDATE3="01AUG2013"d