Interested to Buy Any Domain ? << Click Here >> for more details...
tell me about intnx, intcx functions?
- 4 Answers
- 22916 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 |
Are you familiar with special input delimiters How are they used?
how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
what kind of variables are collected in AE dataset?
3 Answers Accenture, Quintiles, SAS,
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
What is a post baseline?
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
What is PROC in SAS?
What are the five ways to do a table lookup in sas? : sas-grid-administration
What makes sas stand out to be the best over other data analytics tools?
What is the difference between order and group variable in proc report?
How do you use the do loop if you don’t know how many times you should execute the do loop?
What do you code to create a macro? : sas-macro
Teradata 
