topic Re: Correct Usage of inputn in SAS Programming

Correct Usage of inputn

ChaNAB — Tue, 12 Mar 2019 05:32:43 GMT

Hello,

I am struggling to use inputn functions of a macro where I cannot get the right date to be called.

This is the code Ive got so far:

%macro dsname;
%local  s e ;
%let s=%sysfunc(inputn(201607,yyyymmn6.),date9.);
%let e=%sysfunc(inputn(201707,yyyymmn6.),date9.);
%put &s.;
%put &e.;
%mend;

The result I get is:

27         GOPTIONS ACCESSIBLE;
28         %macro dsname;
29         
30         %local  s e ;
31         
32         %let s=%sysfunc(inputn(201607,yyyymmn6.),date9.);
33         
34         %let e=%sysfunc(inputn(201707,yyyymmn6.),date9.);
35         
36         %put &s.;
37         %put &e.;
38         
39         %mend;
40         
41         %dsname;
25DEC2511
03APR2512

Where the results Im expecting is 01JUL16 and 01JUL17.

Could someone provide assistance as to what Im doing wrong?

Thanks.

Re: Correct Usage of inputn

Kurt_Bremser — Tue, 12 Mar 2019 05:40:00 GMT

The informat YYYYMMN does not exist, YYMMN does.

Maxim 1: Read the Documentation: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=leforinforref&docsetTarget=p13mkc7m059u4kn1knl9nzpliaat.htm&locale=en

Re: Correct Usage of inputn

ballardw — Tue, 12 Mar 2019 15:30:21 GMT

Please note that 25DEC2511 is the date9 formatted value for 210607 as a simple integer.