. Which date advances a date, time or date/time value by a
given interval?
Answers were Sorted based on User's Feedback
Answer / name is no need
I think for the above question intnx is the correct
answer,can any one comment on this?
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / rammohan
intnx is the correct answer for incrementing date values.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / pambrose
Here is the detailed usage of intnx function
date1=intnx('month','01jan95'd,5,'beginning');
put date1 / date1 date7.;
date2=intnx('month','01jan95'd,5,'middle');
put date2 / date2 date7.;
date3=intnx('month','01jan95'd,5,'end');
put date3 / date3 date7.;
date4=intnx('month','01jan95'd,5,'sameday');
put date4 / date4 date7.;
date5=intnx('month','15mar2000'd,5,'same');
put date5 / date5 date9.;
interval='month';
date='1sep2001'd;
align='m';
date4=intnx(interval,date,2,align)
;put date4 / date4 date7.;
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / madhupamuluri
Here asked interval so INTCK IS correct.By using this we have to caluculate difference betn two date values
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nina
Which FUNCTION advances a date, time or date /time value by
a given interval?
Intck
Is This Answer Correct ? | 2 Yes | 8 No |
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
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?
Difference between sum function and using “+” operator?
How do you test for missing values?
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;
Give e an example of..
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
what is the use of sas management console? : Sas-di
what are some differences between proc summary and proc means? : Sas programming
How to convert .xls file into CSV format?
What is data _null_?
What will calendar procedure do?