Which date functions advances a date time or date/time
value by agiven interval?
Answer Posted / sai krishna
Using INTNX as
c=intnx(interval,date,n);
data u;
c=intnx(month,'01jan08'd,1);
run;
the result for c would be 01feb08
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what is the purpose of _error_? : Sas programming
what is star schema? : Sas-di
Describe the function and utility of the most difficult SAS macro that you have written?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
why is sas considered self-documenting? : Sas programming
Explain proc sort?
What is program data vector (pdv) and what are its functions?
how will you locate the sas platform applications? : Sas-bi
What sas features do you use to check errors and data validation?
How do you specify the number of iterations and specific condition within a single do loop?
State the difference between INFORMAT and FORMAT ?
How would you include common or reuse to be processed along with your statements?
how does sas handle missing values in a merge? : Sas programming
In ARRAY processing, what does the DIM function do?
what is information maps?