Briefly describe 5 ways to do a "table lookup" in sas.
Answer Posted / lakshmi
update
modify
fact to dimension
sql joins
merge statement
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know the features of sas?
what is the effect of the options statement errors=1? : Sas programming
explain the main difference between the nodup and nodupkey options? : Sas-administrator
describe about physical data integration? : Sas-di
Explain data_null_?
What is the difference between class statement and by statement in proc means?
What are the special input delimiters used in SAS?
Are you involved in writing the inferential analysis plan? Tables specifications?
Explain the difference between nodup and nodupkey options?
Where do you use proc means over proc freq?
Mention the category in which sas informats are placed?
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.
For what purpose would you use the RETAIN statement?
What are the applications primarily used by business analyst? : Sas-bi
Differences between where and if statement?