is there any differnce between proc means and proc summary?
Answer Posted / sai ram
THE PROC SUMMARY: IN THIS CASE THE PROC SUMMARY OMIT THE VAR AND OUT WINDOW,
IN THIS CASE WE CAN GET THE ONLY 'N' OBS.
THE PROC MEANS: WE CAN GET THE OUTPUT RESULT IN OUT WINDOW
AND IF WE WANT TO STATISTICAL INFORMATION AS PER YOUR WISE
N,MEAN,MAX,MIN,STD LIKE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How would you invoke a macro? : sas-macro
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 is slibref?
How are numeric and character missing values represented internally?
is data integration and etl programming is same? : Sas-di
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
: and & modifiers.
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What are the five ways to do a table lookup in sas? : sas-grid-administration
Which command is used to save logs in the external file?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
Can you execute macro within another macro? : sas-macro
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What are the table names in oracle database...?
Explain what is the use of proc gplot?