tell me about intnx, intcx functions?

Answers were Sorted based on User's Feedback

tell me about intnx, intcx functions?..

Answer / natrajboga

the INTCK function counts the number of intervals between
the two dates

where as INTCX function advances the date or time values
by a given interval and returns a date or time values

for example:

data xxx;
count= intck('week','1aug1998'd,'31aug1998'd);
proc print;run;
the result would be 5 (it represents the no of weeks)

data yyy;
count= intnx('month','1aug1998'd,1);

proc print;run;
the result would be the 1sep1998. becaz it corresponds to
the beginning of the next interval.

Is This Answer Correct ?    15 Yes 1 No

tell me about intnx, intcx functions?..

Answer / vimal

INTNX not only adds the dates.. it also subtracts..

count= intnx('month','1aug1998'd,-1);

it will subtract one month from 1aug1988 and gives us the output.

Is This Answer Correct ?    8 Yes 2 No

tell me about intnx, intcx functions?..

Answer / ramesh varma

intck is tells you between dates.
intnx is tells you adding dates

Is This Answer Correct ?    4 Yes 1 No

tell me about intnx, intcx functions?..

Answer / swati

INTCK( interval, date1, date2 )
Gives the difference of dates between date1 and date2

INTNX( interval, date, n <, 'alignment' > )

It increments the date by the n value

I am beginer,I have answered this at my knowledge.

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More SAS Interview Questions

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

1 Answers  

How many versions came upto now in SAS?

3 Answers   TCS, CTS,

what is ae onset date n what is RDS

0 Answers   Accenture,

What are the functions used for character handling?

0 Answers  

Describe the ways in which you can create macro variables?

0 Answers  

data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks

3 Answers  

How to do user inputs and command line arguments in SAS? D&B

2 Answers   BoA, Quintiles,

Can you excute a macro within a macro? Describe.

3 Answers  

What statement do you code to write the record to the file?

5 Answers  

how to read raw data in sas. Do it manually and throw the programming.

1 Answers   WNS,

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  

where are dashboard components are created and maintained? : Sas-bi

0 Answers