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 |
At compile time when a SAS data set is read, what items are created?
what type of reports you are generating in your company...???
2 Answers GSK GlaxoSmithKline,
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is highest missing value for numeric?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
What is the purpose of trailing @ and @@? How do you use them?
What are the automatic variables for macro? : sas-macro
What is the function of Stop statement in a SAS Program?
how to read character value without using substr function in sas ?
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?
How to do user inputs and command line arguments in SAS? D&B