tell me about intnx, intcx functions?
Answers were Sorted based on User's Feedback
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 |
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 | 3 No |
Answer / ramesh varma
intck is tells you between dates.
intnx is tells you adding dates
| Is This Answer Correct ? | 4 Yes | 1 No |
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 |
Code a PROC MEANS that shows both summed and averaged output of the data.
who is the best SAS clinical Trainer in Hyderabad?
How would you determine the number of missing or nonmissing values in computations?
what are the benefits of data integration? : Sas-di
Give some examples where proc report’s defaults are same as proc print’s defaults?
what is intially documentation in sas?
How do you control the number of observations and/or variables read or written?
How would you remove a format that has been permanently associated with a variable? ________________
· What are some good SAS programming practices for processing very large data sets?
What is the role of sas grid administrator? : sas-grid-administration
How to create list output for cross-tabulations in proc freq?
what is the purpose of _error_? : Sas programming