what are the new features included in the new version of
SAS i.e., SAS9.1.3?
Answer Posted / sankar
some options are added.
they arr
DUPOUT option in proc sort statement
propcase function,compbl function are added.
above two functions one function is previous versions no
available.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the applications primarily used by business analyst? : Sas-bi
what is the basic structure sas administrator? : Sas-administrator
how do you pull data from equifax?tell me the process?
What are the difficulties u faced while doing vital signs table or dataset?
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 ...
What do you know about sas and what we do? : sas-grid-administration
What are common programming errors committed in sas
Differentiate between ceil and floor functions.
Can you execute a macro within a macro? Describe. : sas-macro
what are some differences between proc summary and proc means? : Sas programming
What is the difference between the proc sql and data step?
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.
What are types of transport files?
What areas of SAS are you most interested in?
Have you ever used the SAS Debugger?