Which is Best Institute for learning SAS BASE & SAS BI in
Hyderabad? Can anyone suggest me ?
Answer Posted / venu
For more information about
SAS EBI (Enterprise Business Intelligence),
SAS EDI (Enterprise Date Integration),
SAS VA (Visual Analytics) &
SAS Platform Administration,
Please contact MuralaVenu@gmail.com or Skype ID: VenuMurala
Or Visit: SASTraining4U
Is This Answer Correct ? | 0 Yes | 0 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 proc in sas? : Sas-administrator
Differentiate input and infile.
Describe a time when you were really stuck on a problem and how you solved it?
In proc transpose and data step with arrays which one you pick?
Explain the purpose of retain statement.
Explain the main difference between the sas procedures and functions? : Sas-administrator
Explain the purpose of substr functions in sas programming.
What is the basic syntax of a sas program?
What is PROC in SAS?
How do you specify the number of iterations and specific condition within a single do loop?
what are _numeric_ and _character_ and what do they do? : Sas programming
Compare sas with other data analytics tools.
What are the default statistics for means procedure?
How will you generate test data with no input data?