topic Re: intnx in SAS Programming

intnx

mehak — Sat, 21 Oct 2017 18:55:47 GMT

Can any1 please help me . I have to calculate field of coupon issuance date .expiry date of coupon is 3 months . But in my data sets i am only having expiry date . Is this the correct way to solve such que

data _class_1;

coupon_issuance_date=intnx('02',20,-3,'b');

proc print data = _class_1 noobs;
run;

Re: intnx

Kurt_Bremser — Sat, 21 Oct 2017 19:15:30 GMT

Run your code and read the log.

Re: intnx

mehak — Sat, 21 Oct 2017 19:22:34 GMT

already done it sir .

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

62 data _class_1;

64 coupon_issuance_date=intnx('02',20,-3,'b');

NOTE: The data set WORK._CLASS_1 has 1 observations and 1 variables.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

66 proc print data = _class_1 noobs;

67 run;

NOTE: There were 1 observations read from the data set WORK._CLASS_1.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.03 seconds

cpu time 0.03 seconds

69 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: intnx

Kurt_Bremser — Sat, 21 Oct 2017 19:38:30 GMT

And did you get the result you expected?

Re: intnx

Reeza — Sat, 21 Oct 2017 20:45:17 GMT

@mehak wrote:

Can any1 please help me . I have to calculate field of coupon issuance date .expiry date of coupon is 3 months . But in my data sets i am only having expiry date . Is this the correct way to solve such que

data _class_1;

coupon_issuance_date=intnx('02',20,-3,'b');

proc print data = _class_1 noobs;
run;

No. Review how the INTNX() documentation, there are examples at the bottom of the page.

http://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p10v3sa3i4kfxfn1sovhi5xzxh8n.htm&docsetVersion=9.4&locale=en

Specifically:

INTNX(interval <multiple><.shift-index>,

start-from,

increment

<, 'alignment'>)

Compare the parameters above to yours.

The examples are towards the bottom of the page.