Call nowFree Demo


Follow Us

For Special Diwali Offers Call Us @ +91-9999491958

Industrial Training

9999491895 | 9873140018

SAS Base & Advanced Training

  • Enhance editor window
  • Log window
  • Output window
  • Result window explorer window program editor window
  • Datasets
  • Data view
  • catalog
  • referencing files in SAS libraries
  • creating an SAS programs
  • components of SAS programs
  • characteristics of SAS programs
  • the layout of SAS programs
  • program data vector (PDV)
  • compilation phase
  • creating a file shortcut with the file shortcut
  • Assignment window
  • Making a file shortcut to a program
  • Deleting a file shortcut
  • Browsing and submitting a file shortcut for an SAS program
  • Viewing file shortcut properties
  • Global options
  • Local options
  • Global statements
  • Local statements
  • List input
  • Column input
  • Formatted input
  • Modified input
  • Named input
  • Column pointers
  • line pointers 1
  • Introduction to Informats
  • Introduction to formats
  • Difference Between Informats & Formats
  • character informats
  • numeric informats
  • date and time informats
  • character formats
  • numeric formats
  • date and time formats
  • arithmetic functions
  • string functions
  • date and time functions
  • concatenating
  • merging
  • one-to-one merging
  • one-to-many merging
  • many-to-one merging
  • many-to-many merging
  • matching merging
  • Interleaving
  • Updating
  • If statement and if else statement
  • If then statement
  • Where statement
  • Loops (do, dountil, dowhile)
  • Arrays statements
  • Infile statement
  • Filename statement
  • DDE triplet
  • Fundamentals of the ODS
  • ODS and the data step
  • Syntax for ODS enhanced features in a data step
  • Introduction to ODS language statements
  • Dictionary of ODS language statements
  • Writing SAS programs that work
  • Fixing programs that don't work
  • Searching for the missing semicolon
  • Input statements reached past the end of the line lost
  • Invalid data
  • Missing valves were generated
  • Numeric valves have been converted to character (or vice versa)
  • The data step debugger
  • Error : invalid option, Error : variable not
  • Error : statement is not valid
  • Note :variable is uninitialized or Error : variable not
  • SAS truncates a character variable
  • SAS stops in the middle of the job
  • Proc print proc transpose
  • Proc sort proc forms
  • Proc contents proc formats
  • Proc append proc tabulate
  • Proc import proc report Proc
  • export proc printto
  • Proc copy proc datasets
  • Proc access proc means
  • Proc freq proc rank
  • Proc calendar proc compare
  • Introduction to graphs
  • Types of charts
  • Chart
  • Plot
  • Illustration of axis options
  • Illustration of symbol options
  • Graph n go
  • Introduction to statistics
  • Producing descriptive statistics
  • Computing statistics for numeric variables
  • Proc correlation
  • Proc regression
  • Proc means
  • Proc summary
  • Proc univariate
  • Proc freq
  • Proc annova
  • Introduction to macro language elements
  • Introduction to macro variables
  • Automatic macro variables
  • User-defined macro variables
  • Introduction to proc SQL
  • Creating tables
  • Inserting data into tables
  • Alter the tables and etc……
  • Update
  • Modifying the tables
  • Integration of database
  • Connecting to a DBMS using the SQL procedure pass-
  • Connecting to a excel using the SQL procedure pass
  • Connecting to a access using the SQL procedure pass-
  • Connecting to a DBMS using the Libname statement
  • Natural join
  • Inner join
  • Outer join (right, left, full)
  • Define SAS/ACCESS software
  • The interface engine
  • The SQL procedure pass- through facility
  • The access procedure
  • Requirements to connect to a database
  • SAS/ACCESS Libname engines

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