-importing a file to SAS from excel
-contains a date in format like 17mar2000:00:00:00 imported as character
-want it to be formatted like 200003
tried
newdate=datepart(date1);
put newdate=yymmn7.;
data have;
input dt $ 20.;
cards;
17mar2000:00:00:00
;
data want(drop=dt);
set have;
date=put(input(scan(dt,1,':'),date9.),yymmn7.);
proc print;run;
Sorry I should have been more specific. I have a column of dates in this format (different dates) and want to reformat the entire column to the new format.
Excel does not understand SAS's syntax of placing a colon between the date and the time.
But SAS does
data xx;
input date1 $20.;
new_date=datepart(input(date1,datetime.));
format new_date yymmn6.;
new_char=put(datepart(input(date1,datetime.)),yymmn6.);
put (date1 new_date new_char) (=);
cards;
17MAR2000:00:01:45
run;
date1=17MAR2000:00:01:45 new_date=200003 new_char=200003
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.