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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.