Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between nodup and nodupkey options?
- 20 Answers
- 79976 Views
- iFlex, Makro, Talwar, I also Faced
- E-Mail Answers
Answer Posted / surendar
NODUP:- It eliminates or removes if the same information available multiple times in all variables
(It works on all variables).
NODUPKEY:-It eliminates or removes if the same information available multiple times with in the variable.
(It Works on only one key variable)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between one to one merge and match merge? Give an example.
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.
How many data types are there in SAS?
What are the new features included in the new version of SAS Programming Language?
What are common programming errors committed in sas
What is the function of Stop statement in a SAS Program?
How to limit decimal places for variable using proc means?
List out some key concept of SAS
Mention the category in which sas informats are placed?
What are the differences between proc means and proc summary?
what versions of sas have you used (on which platforms)? : Sas programming
explain the function of substr in sas? : Sas-administrator
What is the role of unrestrictive users? : sas-grid-administration
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is sas application server? : Sas-di
