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 |
How would you identify a macro variable?
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
how to perform paired t-test using Base/SAS & SAS/Stat?
What is the function of Stop statement in a SAS Program?
At compile time when a SAS data set is read, what items are created?
How do you read in the variables that you need?
What are pdv and it functions?
What are Dashboard reports?And significance of these in analysis?
What is the difference between using drop = data set option in data statement and set statement?
what is sas application server? : Sas-di