Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Differentiate between ceil and floor functions.

1162


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1199


How to convert a numeric variable to a character variable?

1209


Which function is used to count the number of intervals between two sas dates?

1132


For what purposes have you used sas macros? : sas-macro

1001


what is treatment emergent events and treatment emregent adverse event

2407


This entry was posted in General. Bookmark the permalink. Post a comment or leave

4576


explain about data integrator metadata reports? : Sas-di

1110


What is the basic structure of a sas program?

1122


what other sas products have you used and consider yourself proficient in using? : Sas programming

1115


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

1060


Explain what is data step?

1205


What are the data types that sas contain?

1186


What function CATX syntax does?

1223


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1016