coverting numeric to date value

rishabhmehra13 — Mon, 29 Aug 2016 11:02:40 GMT

i want ot display the coupon issuing date,assuing each coupon is valid for 3 months.coupon expiry is my column having all the dates.

i am getting the value for cissd as

for date 20feb14 cissd 19844 same is for 21feb14.

data cid;
set d.permanent;
cissd=intnx('month',couponexpiry,3);

run;
proc print data=cid;
run;

could you please help me with this

log

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 data cid;

57 set d.permanent;

58 cissd=intnx('month',couponexpiry,3);

59 c=format cissd date9.;

_____

388

ERROR 388-185: Expecting an arithmetic operator.

ERROR 76-322: Syntax error, statement will be ignored.

60 run;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.CID may be incomplete. When this step was stopped there were 0 observations and 18 variables.

WARNING: Data set WORK.CID was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.06 seconds

cpu time 0.07 seconds

61 proc print data=cid;

62 run;

NOTE: There were 1404 observations read from the data set WORK.CID.

NOTE: PROCEDURE PRINT used (Total process time):

real time 30.01 seconds

cpu time 29.74 seconds

64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: coverting numeric to date value

Kurt_Bremser — Mon, 29 Aug 2016 11:15:38 GMT

SAS already puts your nose straight to where you made a mistake:

56 data cid;
57 set d.permanent;
58 cissd=intnx('month',couponexpiry,3);
59 c=format cissd date9.;
_____
388
76
ERROR 388-185: Expecting an arithmetic operator.
 
ERROR 76-322: Syntax error, statement will be ignored.

c=format cissd date9.;

makes no sense.

You probably wanted

data cid;
set d.permanent;
cissd=intnx('month',couponexpiry,3);
format cissd date9.;
run;

Without the format you see the raw value of a SAS date, which is the number of days since 01jan1960.

topic Re: coverting numeric to date value in SAS Studio

coverting numeric to date value

Re: coverting numeric to date value