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 03APR2512Where the results Im expecting is 01JUL16 and 01JUL17.
Could someone provide assistance as to what Im doing wrong?
Thanks.
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&docsetTarge...
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&docsetTarge...
Please note that 25DEC2511 is the date9 formatted value for 210607 as a simple integer.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.