Interested to Buy Any Domain ? << Click Here >> for more details...
How would you remove a format that has been permanently
associated with a variables?
- 3 Answers
- 10326 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunymuny
proc datasets;
Modify Employee;/*Dataset name*/
Format lname ;/* Name of variable you want to remove format
from*/
run;
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sandeep
proc datasets;
modify <dataset name>;
format <variable name>;
quit;
| Is This Answer Correct ? | 1 Yes | 0 No |
What is by-group processing?
Name statements that are execution only.
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 do dates work in SAS data?
how do you want missing values handled? : Sas programming
Name statements that are execution only?
Mention sas system options to debug sas macros.
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
what is broad cast agent? : Sas-bi
what is information maps?
State the difference between INFORMAT and FORMAT ?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
Teradata 
