sas is a package or colletion of products or tolls with
domain based functional software.
It is not a database.
sas is a statistical software
sas is a datawarehousing software
sas is a analysis and reporting software.
sas is programming language which is used for data
retrive,manage,analyse and to genrate the reports.
sas provides wide range of solutins to the business
world.
SAS is a statistical analytical software. mainly used by
statistitians for analysis.
it is a good data repository (datya warehouse)
it is also used for data manipulation and reporting purpose
by sas programmers.
sas is statistical analysis system which is integrated
package can be use which way you want
sas is for data base
sas is for data retrive and access
sas is for data management
sas is for data warehouse
sas is for data mining
sas is for data entry
sas is for data analysis by statistics knowledge
sas is for data reporting
sas is for web devolapment
sas is for graphics
sas is for easy programming language
sas is for dicision making
sas is for forcasting
sas is for unlimited storege data base
sas is for graphs
SAS (pronounced "sass", originally Statistical Analysis
System) is an integrated system of software products
provided by SAS Institute that enables the programmer to
perform:
data entry, retrieval, management, and mining
report writing and graphics
statistical analysis
business planning, forecasting, and decision support
operations research and project management
quality improvement
applications development
Data warehousing (extract, transform, load)
platform independent and remote computing
In addition, SAS has many business solutions that enable
large scale software solutions for areas such as IT
management, human resource management, financial
management, business intelligence, customer relationship
management and more.
SAS: Statistical Analysis Software, Statistical Analysis
System. It is basically 80% GUI 20% Non-GUI, means only 20%
program is required to do the tasks. Tasks like statistical
analysis used in various areas like mainly Clinical
studies,pharma, banking, finance etc.
1.How to draw pivot tables in Excel by using SAS and in
which version we can use VB script for to draw pivot
tables in Excel? Answer with example data.
2.What are the advantages of _NULL_ in Data steps? Can we
use _NULL_ in Proc steps also?
3. How to call the macro variable into Data Steps?
4. Can we draw pivot tables in Excel using Proc SQL?
Please post answers for the above questions with suitable
examples, and how to use VB script for Excel using SAS.
How would you code a merge that will write the matches of
both to one data set, the non-matches from the left-most
data set to a second data set, and the non-matches of the
right-most data set to a third data set?
How do you debug and test your SAS programs?
What can you learn from the SAS log when debugging?
How do you test for missing values?
How would you create multiple observations from a single
observation?
What are some good SAS programming practices for processing
very large data sets?
Briefly describe 5 ways to do a "table lookup" in SAS.
Why is SAS considered self-documenting?
Are you sensitive to code walk-throughs, peer review, or QC
review?
What other SAS features do you use for error trapping and
data validation?
How does SAS handle missing values in: assignment
statements, functions, a merge, an update, sort order,
formats, PROCs?
How will you assign all the variables of an dataset into a
macro variable separated by a space? For example if a
dataset has variables A,B,C. Assign them to a macro variable
X as
X=A B C