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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.