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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.