what is sas? is a package or tool? give me introduction
about sas?
Answer Posted / pradeep
SAS is a Tool which is a combination of 3 basic Features.
1..It is a Reporting Tool
2..It is an ETL Tool
3..It is also a Forecasting Tool.
Where as the Tools other than SAS
Consists of first feature eg-Cognos,BO
OR Consists of second feature eg-Informatica,Data Stage.
No other tool has the Power of Forecasting Feature.
| Is This Answer Correct ? | 1 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.
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What does proc print, and proc contents are used for?
What is SAS? What are the functions does it performs?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
Which date function advances a date, time or datetime value by a given interval?
What is the function of output statement in a SAS Program?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
Given an unsorted data set, how to read the last observation to a new data set?
How we can call macros with in data step? : sas-macro
why a stop statement is needed for the point= option on a set statement?
what is slowly changing dimension? : Sas-di
what is the difference between nodup and nodupkey options? : Sas programming
Explain data_null_?
What is the basic structure of a sas program?