Answer Posted / ganesh
If it is an integer we can use %eval ..
If it has decimal values then %sysevalf..
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What are pdv and it functions?
Are you involved in writing the inferential analysis plan? Tables specfications?
Why double trailing @@ is used in input statement?
What can you learn from the SAS log when debugging?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Explain how you can debug and test your SAS program?
Differentiate between format and informat? : sas-grid-administration
Are you involved in writing the inferential analysis plan? Tables specifications?
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 are numeric and character missing values represented internally? : Sas programming
Do you need to rearrange the order of the data for the report?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
what is hash files in sas and why we are using this one in sas?
