## Convert date to first day of the month

Solved
Regular Contributor
Posts: 179

# Convert date to first day of the month

proc sql;

create table test as

select ln,workout_trial_dt, my_cd

from table

where my_cd='c2';quit;

sample output

ln                       workout_trial_dt               my_cd

111                     02JAN2015                       c2

I need the date to show as the first day of the month.  In this case 01JAN2015

Accepted Solutions
Solution
‎08-31-2017 09:28 AM
Posts: 3,852

## Re: Convert date to first day of the month

You might consider the correct date interval.

data _null_;
workout_trail_dt = today();
wrong = intnx(
'day',workout_trail_dt,0,"BEGINNING");
right = intnx(
'month',workout_trail_dt,0,"BEGINNING");
put (_all_)(/=);
format _all_ date9.;

run;

workout_trail_dt=
14MAY2015
wrong=
14MAY2015
right=
01MAY2015

All Replies
Super User
Posts: 9,599

## Re: Convert date to first day of the month

You can use the intnx function:

intnx('day',workout_trail_dt,0,"BEGINNING") as first_of_month.

Solution
‎08-31-2017 09:28 AM
Posts: 3,852

## Re: Convert date to first day of the month

You might consider the correct date interval.

data _null_;
workout_trail_dt = today();
wrong = intnx(
'day',workout_trail_dt,0,"BEGINNING");
right = intnx(
'month',workout_trail_dt,0,"BEGINNING");
put (_all_)(/=);
format _all_ date9.;

run;

workout_trail_dt=
14MAY2015
wrong=
14MAY2015
right=
01MAY2015
🔒 This topic is solved and locked.