Call nowFree Demo


Follow Us

For Training in Gurgaon Branch Call @ +91-9999340200

Industrial Training

9999491895 | 9873140018

SAS Base & Advanced Training

  • Overview Of SAS
  • Analytical World
  • Library Structure And Definition
  • Installation And Configuration
  • Sas Graphic User Interface
  • Sas Programming Windows
  • Sas Library
  • Variable Attributes
  • Importing And Exporting Data
  • Understating Datasets
  • Understanding Data Step Processing
  • Compilation And Execution Phase
  • Buffer Pdv Concept
  • Importing Raw Data Files
  • Reading One To Many And Many To One Records
  • Import Wizard
  • Datalines And Cards
  • Mixed Record Types
  • Hierarchical Files
  • Proc Content and Proc Print
  • Creating New Column in SAS
  • Conditional Logic
  • Formatting Values
  • Using Filter in SAS Table and Data Task
  • Merging SAS Tables in Data Step
  • Combining Data Sets
  • Arithmetic Functions
  • Date and Time Functions
  • Nested Functions
  • Text Manipulation Function
  • Proc Fre
  • Proc Format
  • Proc Summary
  • Proc Tabulate
  • Proc Report
  • Output Delivery System
  • Ods Statement
  • Sql Language
  • Creating Tables and Inserting Values
  • Storing and Retrieving Data
  • Sorting, Filtering and Grouping
  • Reporting and Summary Analysis
  • Creating Indexes and Using Joins
  • Defining Macros
  • Macro Parameters and Variables
  • Macros Options
  • Using Call Symput and Symget
  • Debugging SAS
  • Effective SAS Programming
  • Memory Saving Tips
  • Disk Management and Saving I/O Processing Time
  • Introduction to Ms Access and SQL
  • Creating Tables
  • Using Queries
  • Form and Report Designing
  • Data Manipulation
  • Rdbms Concept
  • Data Aggregation and Summarization

Inquiry for SAS Base & Advanced Training

Please find the SAS Training Course Duration.
Course Module Course Duration
SAS Base & Advanced 60 – 70 Hours




Which one of the following statement can’t be part of “PROC FREQ”?
  1. A) OUTPUT
  2. B) WEIGHT
  3. C) SET
  4. D) Tables
  5. E) None of the above

Solution: (C)

Look at the syntax of PROC FREQ, there is not SET statement required.

PROC FREQ <options> ;

BY variables ;

EXACT statistic-options </ computation-options> ;

OUTPUT <OUT=SAS-data-set> options ;

TABLES requests </ options> ;

TEST options ;

WEIGHT variable </ option> ;



PROC UNIVARIATE is used for elementary numeric analysis and will examine how data is distributed. The PROC UNIVARIATE statement is required to invoke the UNIVARIATE procedure. You can use the PROC UNIVARIATE statement by itself to request a variety of statistics for summarizing the data distribution of each analysis variable, which are sample moments, Basic measures of location and variability, confidence intervals for the mean, standard deviation, and variance, tests for location, tests for normality, trimmed and Winsorized means, robust estimates of scale, quantiles and related confidence intervals, extreme observations and extreme values, frequency counts for observations and missing values.

You can use options in the PROC UNIVARIATE statement to do the following:

  • specify the input data set to be analyzed
  • specify a graphics catalog for saving traditional graphics output
  • specify rounding units for variable values
  • specify the definition used to calculate percentiles
  • specify the divisor used to calculate variances and standard deviations
Define RUN-Group processing?

If you can take advantage of RUN-group processing, you can avoid unnecessary procedure invocation. For best programming practices, you need to understand how RUN-group processing affects the execution of SAS statements. The procedures that support RUN-group processing include

  • GLM
  • REG

To illustrate how RUN-group processing works, this discussion focuses on the DATASETS procedure. The comparative example, that follows includes programs that use PROC DATASETS to modify the descriptor portion of data sets. Before you examine the code to consider efficient programming techniques, review how the principles associated with RUN-group processing apply to PROC DATASETS.

Explain SUBSTR function?

The SUBSTR function is an important function in SAS that starts from a specific position. It can vary in calculating the length of the substring to return. SUBSTR helps in calculating the length using characters as defined by the input character set, using bytes, using Unicode complete characters, using ucs2 code points and ucs 4 code Points. SUBSTR return the value in the same data type as string. Below is given an example of SUBSTR

SHOW SUBSTR('abcdefg',3,4)


SHOW SUBSTR('abcdefg',-5,4)


Explain BMDP procedure?

BMDP refers to the library of statistical analysis program development and by BMDP statistical software Inc. The BMDP procedure is used in SAS programs for calling a BMDP program to analyze the data in a SAS data set and to convert an SAS data set to BMDP save file. It is available for HP-UX, AIX and Solaris operating environment only. You can also analyze SAS data sets with BMDP programs through this procedure and use it for many numbers of time to invoke BMDP. However, before using the procedure you need to have access to the programs from your host and ask the system administrator for location of the BMDP program.

Explain BOR function?

In SAS, BOR Function is used as a bitwise logical operator to return the bitwise logical OR between two different statements.

Latest Blogs