Category Example Task

Data Access View Sales data set and Sales Representative Excel file.
Data Management Query and display sales for the past month.
Data Analysis Summarize total sales by product.
Data Presentation Create a pie chart of percent sales in PDF.

SAS/GRAPH maps and SAS/MDDB Server

Statistical Programmer which requires him to program using the SAS language to analyze clinical data
and produce reports for the FDA

He was familiar with the Food and Drug Administration but learned that they set many of the regulations
that affect his job. During his search, he also saw other job titles including: Bioanalyst, Clinical Data
Analyst, Statistical Programmer Analyst and SAS Programmer. It turns out that different companies have
different names for the same job.

Barbara delivered a big binder which contained a Protocol for his first clinical study. It was a monster
document that must have been at least a hundred pages. The protocol outlined all the procedures and
contained detailed plans of the study. It had the study design, statistical methodology, and acted as a
road map for those involved in conducting the study. .
Use of sas ods

Your database is on the mainframe. Your client is on the PC. You have the batch report developed, but
the client wants a spreadsheet. To top it off, the client wants the spreadsheet emailed to multiple people.
To be sure there are a number of ways to accomplish these requirements, but you want something clean
and efficient—preferably one step. This paper shows how to create a report using ODS on the
mainframe, write it to an HTML data set, and send it as a Excel attachment to an email in one step with
SAS® software.
The result proved extremely popular and is created monthly using a scheduled job.

The first thing is to create the report . In this case, the information is in a DB2 database used by an Electronic Data
Interchange (EDI) translator.

Stop on errors=1 (if you set this option to 1 the session will be stopped after occurance of 1 error...

1. What’s the difference between VAR A1 - A4 and VAR A1 — A4?

Ans : Suppose our variables are in a sequence with suffix A1, A2, A3, A4 We
can use

VAR A1-A4;

Eg:
data test;
input A1 A2 A3 A4;
cards;
1 2 3 4
5 6 7 8
;
run;
proc print data=test;
var A1-A4;
run;

If it is not a particular sequence we need to use A1--A4 (A1 and A4 are

inclusive)
Eg:
data test;
input A1 A A6 A4;
cards;
1 2 3 4
5 6 7 8
;
run;
proc print data=test;
var A1--A4;
run;

The SAS Enterprise Intelligence Platform extends the value of your existing systems while setting the stage for new levels of
enterprise intelligence not previously possible. It includes components such as:

• SAS® Data Integration provides prebuilt, high-performance capabilities for data connectivity, data quality, ETL (extract,
transform and load), data migration, data synchronization and data federation.

• SAS® Analytics provide an integrated environment for predictive and descriptive modeling, forecasting, optimization,
simulation, experimental design and more. SAS Analytics leverage existing data and infrastructures to support effective
decision making and integration into business intelligence environments.

• SAS® Business Intelligence delivers a set of business intelligence capabilities that enable different types of users to surface
meaningful intelligence from consistent, companywide data.

Using SAS SQL Retrieving Data from a Single Table

Retrieving Data from Multiple Tables
Creating and Updating Tables and Views
Programming with the SQL Procedure

The different elements of the macro language are: Macro variables, macro program statements,
macro functions.

Define a Macro Variable

Invoke a Macro Variable
It is convenient to test if the macro variables have been correctly defined. Use the %put
statement that writes text to the SAS log.
Define a Macro Program
Invoke a Macro Program
Macro with Parameters

Macro Functions
Macro functions can be divided into three categories: character functions, evaluation functions
and quoting functions.
Macro Character Functions
Macro Evaluation Function
Macro Quoting Functions
The Use of Lists in a Macro Program
The SAS® data step can create, resolve and execute macros using 2 functions: SYMGET and RESOLVE and 2
routines: CALL SYMPUT and CALL EXECUTE.
This paper aims to demonstrate the usefulness and relative ease these functions and routines:
The CALL SYMPUT routine allows the creation of SAS macro variables from within a SAS data step
The CALL EXECUTE routine allows the execution of a SAS macro from within a SAS data step
The SYMGET function creates data step variables from input SAS macro variables
The RESOLVE function is similar to the SYMGET function but accepts a wider variety of arguments than SYMGET

Worked on
How do I move SAS files from Unix to Windows? And reading the files with different
delimiters into SAS 8 environment

Expertise in using SAS SAS system options

1. SAS system options

2. Log, output and procedure options

3. SAS data set control options

4. Error handling options

5. Reading and writing data options

65) What is Enterprise Guide? What is the use of it?

It is an approach to import text files with SAS (It comes free with Base SAS version 9.0)

Pharmaceutical Industry

51) Describe the types of SAS programming tasks that you performed: Tables? Listings?
Graphics? Ad hoc reports? Other?

Prepared programs required for the ISS and ISE analysis reports. Developed and validated
programs for preparing ad-hoc statistical reports for the preparation of clinical study report.
Wrote analysis programs in line with the specifications defined by the study statistician. Base
SAS (MEANS, FREQ, SUMMARY, TABULATE, REPORT etc) and SAS/STAT procedures
(REG, GLM, ANOVA, and UNIVARIATE etc.) were used for summarization, Cross-
Tabulations and statistical analysis purposes. Created Statistical reports using Proc Report, Data
_null_ and SAS Macro. Created, derived and merged and pooled datasets,listings and summary
tables for Phase-I and Phase-II of clinical trials.

15) Name several ways to achieve efficiency in your program. Explain trade-offs.

Efficiency and performance strategies can be classified into 5 different areas.

· CPU time
· Data Storage
· Elapsed time
· Input/Output
· Memory

CPU Time and Elapsed Time- Base line measurements

Few Examples for efficiency violations:

Retaining unwanted datasets
Not sub setting early to eliminate unwanted records.

Efficiency improving techniques:

Using KEEP and DROP statements to retain necessary variables.
Use macros for reducing the code.
Using IF-THEN/ELSE statements to process data programming.
Use SQL procedure to reduce number of programming steps.
Using of length statements to reduce the variable size for reducing the Data
storage.

Use of Dat a _NULL_ steps for processing null data sets for
Data storage.

11) WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9

OF SAS.
A) The SAS 9 architecture is fundamentally different from any prior version of
SAS. In the SAS 9 architecture, SAS relies on a new component, the Metadata
Server, to provide an information layer between the programs and the data they
access. Metadata, such as security permissions for SAS libraries and where the
various SAS servers are running, are maintained in a common repository.

Data integration
Data integration deals with incorporating all types of organizational data into a unified whole.

SAS/AF

Worked on SAS/AF in developing Interactive applications.

Worked on Procedures like :

1) Base SAS procedures

2) Report writing procedures

3) Statistical procedures

4) Utility procedures

This manual explains how to use SAS ETL Studio to do the following tasks:
􀀀 specify metadata for data sources, such as tables in an operational system
􀀀 specify metadata for data targets, such as tables in a data warehouse
􀀀 create jobs that specify how data is extracted, transformed, and loaded from sources to targets.

CLIST can be used to :

1) Execute a series of TSO commands and subcommands to save time and effort.
2) Create procedures using symbolic variables.
3) Invoke one CLIST which in turn invoke another CLIST: CLISTs can be nested to the desired level
4) Display panels which in turn can execute other CLIST based on the selections made on the panels
5) CLIST can invoke the programs either in the frontground or the background.
6) Executes the programs written in other languages.

The Analyst Application is a data analysis tool that provides easy access
to basic statistical analyses.

SAS/SPECTRAVIEW S/w is an interactive visualization product for viewing , exploring,

analyzing data as graph images