Interested to Buy Any Domain ? << Click Here >> for more details...
Approximately what date is represented by SAS date value of
730
- 9 Answers
- 21615 Views
- I also Faced
- E-Mail Answers
Answer Posted / sheetal
In SAS Dates stored in numeric format, it starts from 1st
Jan 1960, and 1st jan 1960 consider as day # 0. So even
though 1960 was a leap year #days are 365 for year 1961 and
365 for 1961. Which means 365+365=730 nothing but last day
of 1961 - 31st Dec 1961.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.
Explain the use of proc print and proc contents?
What are the features of SAS?
What is the use of divide function?
What are symget and symput? : sas-macro
What are the special input delimiters used in SAS?
What are the ways in which macro variables can be created in sas programming?
What is the basic syntax of a sas program?
What are the advantages of using sas?
Which statement does not perform automatic conversions in comparisons?
What do the put and input function do?
describe how to adjust the performance of data integrator? : Sas-di
what is treatment emergent events and treatment emregent adverse event
What is the difference between INPUT and INFILE ?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
