Increment dates in sas

Anuashla — Fri, 11 Dec 2015 17:33:13 GMT

Hello,

Referrring to the code below, I have to create a column 'calendar_date' which is the date in the column 'Start_date' incremented by the months in corresponding 'exposure' column. The program gives me an error which is mentioned below:

CODE:

PROC SQL;
CREATE TABLE CONTRACTS_VIN AS
SELECT * FROM EXPOSURE_CONTRACTS_GRID, intnx('month', start_date, exposure) as calendar_month
WHERE EXPOSURE <= (TERM+6);
QUIT;

Error:

178 EXPOSURE_CONTRACTS_GRID as select * from data2 cross join exposure_grid order by contract_vin, exposure; quit; PROC SQL
178 ! ; CREATE TABLE CONTRACTS_VIN AS SELECT * FROM EXPOSURE_CONTRACTS_GRID, intnx('month', start_date, exposure) as
_
79
178 ! calendar_month WHERE
ERROR 79-322: Expecting a ).

NOTE: Line generated by the invoked macro "DATA".
178 EXPOSURE_CONTRACTS_GRID as select * from data2 cross join exposure_grid order by contract_vin, exposure; quit; PROC SQL
178 ! ; CREATE TABLE CONTRACTS_VIN AS SELECT * FROM EXPOSURE_CONTRACTS_GRID, intnx('month', start_date, exposure) as
_
79
178 ! calendar_month WHERE
ERROR 79-322: Expecting a (.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: Increment dates in sas

FreelanceReinh — Fri, 11 Dec 2015 17:55:40 GMT

As a first step I would correct the select statement:

SELECT *, intnx('month', start_date, exposure) as calendar_month FROM EXPOSURE_CONTRACTS_GRID

Re: Increment dates in sas

PGStats — Sat, 12 Dec 2015 02:03:13 GMT

Also, if you want the new date to represent the same day of the month as start_date, and not the first day, as you would get by default, you should use option SAME:

intnx('month', start_date, exposure, "SAME") as calendar_month

topic Increment dates in sas in SAS Procedures

Increment dates in sas

Re: Increment dates in sas

Re: Increment dates in sas