One way of creating a new variable in Macros is by %
Let....What is the other way..?
- 5 Answers
- 9306 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / prem krishnan
1) %macro <macroname> ( );
%mend (<macroname>;
a DATA step that contains a SYMPUT routine within a macro
definition
a DATA step that contains a SYMPUTX routine within a macro
definition
a SELECT statement that contains an INTO clause in PROC SQL
within a macro
definition
a %LOCAL statement.
%global statement
| Is This Answer Correct ? | 8 Yes | 0 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.
How will you generate test data with no input data?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what type of graphs we will create(for 2+years candidates)?
What do the mod and int function do? : Sas programming
Mention the difference between ceil and floor functions in sas?
How we can call macros with in data step? : sas-macro
What are the different operating system platforms in which we can use sas? : sas-grid-administration
what has been your most common programming mistake? : Sas programming
What do the PUT and INPUT functions do?
How to limit decimal places for variable using proc means?
What do the SAS log messages "numeric values have been converted to character" mean?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
what is broad cast agent? : Sas-bi
Hi, If anyone has base SAS certification dumps, please share.
