Hello all,
i am going to read a file name thats like B11_20110926_DeliverStatus.csv
i am able to collect the date by substring the file using the following code:
%substr(B11_20110926_DeliverStatus.csv,4,8);
but i am unable to get the MONTH of the substring's file.
is that possible to convert the 20110926 to a sas datetime format?
i try to get the date by using following code.
is that still anyway to do so?
Regards:
Liangck
Isn't %substr(B11_20110926_DeliverStatus.csv,9,2); working for you?
You can use the macro function %sysfunc, whic let's you use (almost) any SAS function within a macro context:
%let sasdate = %sysfunc(inputn(%substr(B11_20110926_DeliverStatus.csv,5,8),yymmdd8.));
/Linus
Isn't %substr(B11_20110926_DeliverStatus.csv,9,2); working for you?
You can use the macro function %sysfunc, whic let's you use (almost) any SAS function within a macro context:
%let sasdate = %sysfunc(inputn(%substr(B11_20110926_DeliverStatus.csv,5,8),yymmdd8.));
/Linus
%let sdate=20061212;
%let ndate=%sysfunc(inputn(&sdate,yymmdd10.));
%let nmonth=%sysfunc(month(&ndate));
%put _user_;
Linus Randy Dai:
Thank you both, i tried both answer and i got got the result perfectly.
thanks, apperciate alot.
Regards
Liangck
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.