Interested to Buy Any Domain ? << Click Here >> for more details...
tell me about intnx, intcx functions?
- 4 Answers
- 23095 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 |
How to do user inputs and command line arguments in SAS? D&B
Explain how you can debug and test your SAS program?
Describe crosslist option in tables statement?
Which date functions advances a date time or date/time value by agiven interval?
how to perform paired t-test using Base/SAS & SAS/Stat?
How to merge the data using merge statement and proc format? Is the result is same ?
How to get part of string form the source string without using sub string function in SAS?
Mention how to limit decimal places for the variable using proc means?
What is the order of evaluation of the comparison operators: + - * /** ()?
what is hash files in sas and why we are using this one in sas?
What is the difference between INPUT and INFILE ?
what is hierarchy flattening? : Sas-di
Teradata 
