topic Convert date to first day of the month in SAS Procedures

Convert date to first day of the month

Q1983 — Thu, 14 May 2015 14:07:26 GMT

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

Re: Convert date to first day of the month

RW9 — Thu, 14 May 2015 14:13:35 GMT

You can use the intnx function:

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

Re: Convert date to first day of the month

data_null__ — Thu, 14 May 2015 14:58:24 GMT

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