tell me about intnx, intcx functions?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What commands are used in the case of including or excluding any specific variables in the data set?

709


What is the difference between the proc sql and data step?

751


what is the effect of the options statement errors=1? : Sas programming

687


How do you add a number to a macro variable? : sas-macro

637


Which command is used to perform sorting in sas program?

676






What is the basic structure of the SAS base program?

781


What is SAS? What are the functions does it performs?

829


Hi, If anyone has base SAS certification dumps, please share.

1487


What is the role of unrestrictive users? : sas-grid-administration

659


What are the scrubbing procedures in sas?

665


what is broad cast agent? : Sas-bi

707


What do you understand by the term Normal Distribution?

668


Can you execute a macro within a macro? Describe. : sas-macro

765


How can you limit the variables written to output dataset in data step?

871


What is the SAS data set?

771