how to assign a macro value to a variable?
Answer Posted / sr
to assign macro value means it already created then
variable=symget(macro var);
variable will get value of that macro variable
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is sas olap server? : Sas-di
what is the function of catx syntax? : Sas-administrator
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
explain about various caches available in data integrator? : Sas-di
Enlist the syntax rules followed in sas statements.
How necessary is it to be creative in your work?
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
How do you test for missing values?
is data integration and etl programming is same? : Sas-di
Why and when do you use proc sql?
How to create an external dataset with sas code?
What areas of SAS are you most interested in?
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 to limit decimal places for the variable using proc means?
What is the difference between reading data from an external file and reading data from an existing data set?