topic Re: Help Formatting Date and Keeping only recent entries in SAS Programming

Help Formatting Date and Keeping only recent entries

SAS_learneromg — Thu, 17 Feb 2022 21:38:40 GMT

I need help formatting a date as it's not something I have experience with. My variables startdate and enddate are coming in as 28Jan2000:00:00:00.000 is the data set I've been provided. How I go about making the dates just mmddyyyy and then keeping only those with a start date between 2006 and 2010?

Re: Help Formatting Date and Keeping only recent entries

Reeza — Thu, 17 Feb 2022 22:02:29 GMT

Assuming your variable is numeric with a datetime format then you can:

Use DATEPART() to extract the date portion only
Apply a format to have it displayed as a date
Use the YEAR() function in an IF statement to filter the dates

data want;
set have;

*extracts date portion;
date_value = datepart(dateTime);
*format, primarily for display purposes;
format date_value mmddyy10.;

*filters;
if year(date_value)  >= 2006 & year <=2010;

run;

@SAS_learneromg wrote:

I need help formatting a date as it's not something I have experience with. My variables startdate and enddate are coming in as 28Jan2000:00:00:00.000 is the data set I've been provided. How I go about making the dates just mmddyyyy and then keeping only those with a start date between 2006 and 2010?

If your datetime value is a character you will first need to convert it to a numeric datetime value:

dateTimeVar = input(charVariable, anydtdtm.);
format dateTimeVar datetime.;

Re: Help Formatting Date and Keeping only recent entries

SAS_learneromg — Thu, 17 Feb 2022 22:40:23 GMT

Thank for the explanation!