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);
run;
proc print;run;
the result would be 5 (it represents the no of weeks)

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

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  






Categories