Hi,
I imported a data from excel file into SAS dataset, and I had month name (e.g. Jan, Feb) in one of the fields. When I imported it, the fields was imported as Character, but I'd like to change it to date (MONNAME3.) format. I tried it to change in "Property" tab, and under "General" -> "Group" to Date, but I saw only Character in Group. Can someone help me how I can change it?
Thanks.
You will have to be prepared to supply more information. SAS dates represent a particular day.
Given a three-letter month, you can always decide that the day should match the first day of the month. But you have to be prepared to supply a year as well.
Editor's note: added sample code to illustrate this solution.
data mon;
infile datalines;
length monname $ 3 month 8;
format month monname3.;
input monname;
/* building a proper date with DayMonthYear */
/* "Jan" becomes "01Jan0", which SAS can read as a date */
month = input( cat('01',monname,'0'), date9.);
datalines;
Jan
Feb
Mar
Apr
Jan
;
You will have to be prepared to supply more information. SAS dates represent a particular day.
Given a three-letter month, you can always decide that the day should match the first day of the month. But you have to be prepared to supply a year as well.
Editor's note: added sample code to illustrate this solution.
data mon;
infile datalines;
length monname $ 3 month 8;
format month monname3.;
input monname;
/* building a proper date with DayMonthYear */
/* "Jan" becomes "01Jan0", which SAS can read as a date */
month = input( cat('01',monname,'0'), date9.);
datalines;
Jan
Feb
Mar
Apr
Jan
;
Thank you for the reply.
I added date 1 and year 0, and it worked. I was able to change it to MONNAME3. format.
Thanks again.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.