Interested to Buy Any Domain ? << Click Here >> for more details...
tell me about intnx, intcx functions?
- 4 Answers
- 22739 Views
- CitiGroup, I also Faced
- E-Mail Answers
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 |
What sas features do you use to check errors and data validation?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
What is the difference between a PROC step and a DATA step?
what is sas application server? : Sas-di
For what purpose(s) would use the RETURN statement?
How do handle working under pressure?
Have you used macros? For what purpose you have used? : sas-macro
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
How we can create SAS USER DEFINED CODE?
Can you execute a macro within a macro? Describe. : sas-macro
What is the purpose of trailing @ and @@? How do you use them?
is there any differnce between proc means and proc summary?
Teradata 
