ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
tell me about intnx, intcx functions?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: tell me about intnx, intcx functions?
Answer
# 1
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 ?    2 Yes 0 No
Swati
 
  Re: tell me about intnx, intcx functions?
Answer
# 2
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 ?    0 Yes 0 No
Natrajboga
[-------------------------]
 
 
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
how to display duplicated observations in a data using base sas. HCL5
In the flow of DATA step processing, what is the first action in a typical DATA Step?  7
What is the pound sign used for the DATA _NULL_?  8
At compile time when a SAS data set is read, what items are created? Accenture8
What is the one statement to set the criteria of data that can be coded in any step?  2
How do you read in the variables that you need? Accenture5
Do you prefer Proc Report or Proc Tabulate? Why? Oracle6
what are the validation tools in sas?  1
What is the purpose of the trailing and How would you use them?  7
WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION? Zensar2
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter? Accenture2
code the tables statement for a single level frequency?  1
How to read multiple excel sheets from a single excel file at once???? Verinon-Technology-Solutions3
What statement do you code to write the record to the file?  2
How would you combine 3 or more tables with different structures?  1
How would you delete observations with duplicate keys?  5
Name statements that function at both compile and execution time. Accenture3
is there any differnce between proc means and proc summary?  2
Do you think professionally? Oracle1
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself. Accenture1
 
For more SAS Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com