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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.