Convert date to first day of the month

[Q1983]

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

[RW9]

You can use the intnx function:

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

[data_null__ · Accepted solution]

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