Interested to Buy Any Domain ? << Click Here >> for more details...
what are scrubing procedures in SAS?
- 1 Answers
- 6459 Views
- Oracle, I also Faced
- E-Mail Answers
Answer / suresh
proc sort with nodupkey option.
coz it will eliminate the duplicate values.
| Is This Answer Correct ? | 7 Yes | 0 No |
what is star schema? : Sas-di
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
If a variable contains letters or special characters, can it be numeric data type?
Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 Answers Verinon Technology Solutions,
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
What are the main differences between sas versions 8.2, 9.0, 9.1?
what is proc Index? and what is proc document?
what is the difference btw proc means and proc univariate?
Tell me more about the parameters in macro? : sas-macro
What is the order of evaluation of the comparison && logical && relational operators:?
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
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.
Teradata 
