Name and describe three SAS functions that you have used, if
any?
Answer Posted / lavanya rapole
the three sas fuctions that i have used are
character function
numeric function and
date function
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how does sas handle missing values in sort order? : Sas programming
What is the maximum length of the macro variable? : sas-macro
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Mention the validation tools used in SAS?
Why and when do you use proc sql?
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 include or exclude specific variables in a data set?
What is the difference between reading data from an external file and reading data from an existing data set?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
Of all your work, where have you been the most successful?
: and & modifiers.
how to debug and test the sas program? : Sas-administrator
explain the key concept of sas? : Sas-administrator
Give e an example of..
Describe crosslist option in tables statement?