Interested to Buy Any Domain ? << Click Here >> for more details...
tell me about intnx, intcx functions?
- 4 Answers
- 22654 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vimal
INTNX not only adds the dates.. it also subtracts..
count= intnx('month','1aug1998'd,-1);
it will subtract one month from 1aug1988 and gives us the output.
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / ramesh varma
intck is tells you between dates.
intnx is tells you adding dates
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / swati
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 ? | 4 Yes | 5 No |
You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
What is criteria for adverse events and treatment-emergent adverse events?
How would you include common or reuse code to be processed along with your statements?
How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Explain what Proc glm does?
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
Are you sensitive to code walk-throughs peer review or QC review?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
What is the difference between %local and %global? : sas-macro
Teradata 
