Interested to Buy Any Domain ? << Click Here >> for more details...
How to select the observations randomly from a SAS dataset
- 7 Answers
- 27365 Views
- NTT Data, I also Faced
- E-Mail Answers
Answer Posted / neel
By using the point function
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
which features do you use to check the data validations and errors? : Sas-administrator
Explain proc univariate?
how does sas handle missing values in assignment statements? : Sas programming
how will you location sas platform applications available from web browser? : Sas-bi
Explain substr function?
Where do you use proc means over proc freq?
Explain the difference between nodup and nodupkey options?
what is factor analysis? : Sas-administrator
What is the maximum and minimum length of macro variable
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 the difference between SAS functions and procedures?
What are SAS/ACCESS and SAS/CONNECT?
Describe crosslist option in tables statement?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the features of base sas system?
