topic Re: Convert qtr to start date in SAS Programming

Convert qtr to start date

Babloo — Sat, 25 Mar 2023 19:09:24 GMT

1) I'm getting the invalid argument warning when I executed the following code and I see the value of sales_date as missing instead of '01DEC2022'd.

data test;
mon_intrvl='2022-12';
sales_date = input(mon_intrvl, date9.);
run;

2) How to convert any given date value to th start date of the month? For example if input date value is '22DEC2022' then I need the result as '01DEC2022'd. I tried the intnx function as below but it's not working.

data test;
start_date_edh = intnx("month",today(),"b");
run;

Warning which I got is,

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      82:40   
NOTE: Invalid numeric data, 'b' , at line 82 column 40.
start_date_edh=. _ERROR_=1 _N_=1

Any help to resolve this?

Re: Convert qtr to start date

PaigeMiller — Sat, 25 Mar 2023 20:28:36 GMT

If you are getting errors, show us the log.

Re: Convert qtr to start date

Kurt_Bremser — Sat, 25 Mar 2023 20:49:36 GMT

Maxim 1. Read the Documentation.

Study DATEw. Informat and you'll see your mistake.

Re: Convert qtr to start date

Tom — Sat, 25 Mar 2023 21:12:14 GMT

The DATE informat needs strings in the style ddMONyyyy. So strings like 01DEC1990 or 01-dec-1990 etc.

To read a string in the style of yyyy-mm you would need a different informat. I think you might have to append a day of the month to get it to work.

data test;
  mon_intrvl='2022-12';
  sales_date = input(cats(mon_intrvl,'-01'), yymmdd10.);
  put sales_date=date9.;
run;

Your second mistake is you did not include the OFFSET for the INTNX() function call. So it is trying to convert the letter B into a number. To get the beginning of the current month use an offset of 0 months.

data test;
  start_date_edh = intnx("month",today(),0,"b");
  format start_date_edh date9.;
run;

Re: Convert qtr to start date

Kurt_Bremser — Sat, 25 Mar 2023 21:26:49 GMT

Once you get rid of the hyphen (use COMPRESS()), you can use the YYMMN6. informat.