how to write code for left outer join in SAs using datastep?
- 8 Answers
- 19147 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / jbhjhj
dnt use set it wnt work.
use merge with in statements as above.
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
How necessary is it to be creative in your work?
Describe the ways in which you can create a macro variable?
What are the ways in which macro variables can be created in sas programming?
Explain append procedure?
how many types prompting framework can be broken down to? : Sas-bi
what is study design in while working with SAS? what are screening variables in SAS?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What is data _null_?
: and & modifiers.
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 nodup and nodupkey options? : Sas programming
What is the difference between SAS functions and procedures?
Do you need to know if there are any missing values?
Do you know the features of sas?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
