Help using Base SAS procedures

Convert date to first day of the month

Reply
Frequent Contributor
Posts: 131

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

Super User
Super User
Posts: 7,392

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.

Respected Advisor
Posts: 3,777

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
Ask a Question
Discussion stats
  • 2 replies
  • 8541 views
  • 2 likes
  • 3 in conversation