Interested to Buy Any Domain ? << Click Here >> for more details...
Which is the best training institute for SAS in hyderabad.
- 112 Answers
- 227858 Views
- Stansys Software Solutions, I also Faced
- E-Mail Answers
Answer Posted / srinivas
can any one suggest some sas sites or materials
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Name validation tools used in SAS
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.
what are _numeric_ and _character_ and what do they do? : Sas programming
Give some examples where proc report’s defaults are same as proc print’s defaults?
What do the SAS log messages "numeric values have been converted to character" mean?
What is the role of administrative users? : sas-grid-administration
Tell me more about the parameters in macro? : sas-macro
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
explain what is data set in sas? : Sas-administrator
What is the basic syntax of a sas program?
Tell me about % include and % eval? : sas-macro
Give some ways by which you can define the variables to produce the summary report (using proc report)?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
How would you determine the number of missing or nonmissing values in computations?
How do you debug and test your SAS programs?
