what is the main difference between rename and label? (don't
say that they both perform the same function).
Answer Posted / ganesh
Rename takes only 64characters length it can be used either
datastep or proc step and this rename is remains only for
the particular session once u terminate the session rename
options vanishes.
Label takes 256 characters length and its is a global
statment we can specify a brief name and this will remain
for long time untill & unless user delete or cancell the
variable.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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.
explain the use of % includes a statement in sas? : Sas-administrator
what is operational data and operational system? : Sas-di
What is SAS? What are the functions does it performs?
What does PROC print, and PROC contents do?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What does P-value signify about the statistical data?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
Differentiate between proc means and proc summary.
How can sas program be validated?
What is a macro routine?
How would you invoke a macro? : sas-macro
How many data types are there in SAS?
describe how to adjust the performance of data integrator? : Sas-di