Discover More Tips and Techniques on This Blog
How to convert a SAS date to a character variable
/***************************************************************************//*
Title: Convert a SAS date to a character variable *// *
*//* Goal: Use the PUT function to create a character variable from *//*
a SAS date. *//* *//***************************************************************************/
data one;
input sasdate :mmddyy6.;
datalines;
010199;
run;
data two;
set one;
chardate=put(sasdate,mmddyy6.);
run;
/* RESULTS */
Obs sasdate chardate
1 14245 010199
Source:
ftp://ftp.sas.com/techsup/download/sample/datastep/convertchar.html
Disclosure:
In the spirit of transparency and innovation, I want to share that some of the content on this blog is generated with the assistance of ChatGPT, an AI language model developed by OpenAI. While I use this tool to help brainstorm ideas and draft content, every post is carefully reviewed, edited, and personalized by me to ensure it aligns with my voice, values, and the needs of my readers.
My goal is to provide you with accurate, valuable, and engaging content, and I believe that using AI as a creative aid helps achieve that. If you have any questions or feedback about this approach, feel free to reach out. Your trust and satisfaction are my top priorities.
Fine, but what about a date like 01011999, which there doesn't appear to be a date format for?
ReplyDeleteyou use mmddyy8. format instead of mmddyy6.
ReplyDelete