Help using Base SAS procedures

Convert date to first day of the month

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 141
Accepted Solution

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
Respected Advisor
Posts: 3,799

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

View solution in original post


All Replies
Super User
Super User
Posts: 7,942

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
Respected Advisor
Posts: 3,799

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 10810 views
  • 2 likes
  • 3 in conversation