SAS Interview Questions & Answers

 

What is the use of PROC gplot?

PROC gplot has more options and can create more colorful and fancier graphics.

It performs simple and multiple regression, analysis of variance (ANOVAL), analysis of covariance, multivariate analysis of variance and repeated measure analysis of variance.

What is difference between CEIL and FLOOR functions?

The cell function returns the smallest integer greater than/equal to the argument whereas the floor returns the greatest integer less than/equal to the argument.

How debug SAS Macros?  

There are some system options that can be used to debug SAS Macros: MPRINT, MLOGIC, SYMBOLGEN

How to save log in an external file?

Use PROC PRINTTO

What is the basic syntax style in SAS?

The points important for running SAS program are :

  1. DATA statement, which names your data set.
  2. The names of the variables in your data set are described by INPUT statement.
  3. Statement should be ended through semi-colon(;).
  4. Space between word and statement should be there.

Interested in mastering SAS? Check out this blog post to learn more SAS Tutorials.

What is the difference between SAS PROCs and the SAS DATA STEP?

Procs are sub-routines with a specific purpose in mind and the data step is designed to read in and manipulate data.

Explain what is the basic structure of SAS programing?

SAS programs consists of :

  • DATA step, which recovers & manipulates data.
  • PROC step, which interpret the data.

How can you write a SAS data set to a comma delimited file?

PUT (formatted) statement in data step.

Explain SUBSTR function?

SUBSTR Function is used for extracting a string or replacing contents of character value.

What are the functions which are used for Character handling functions?

UPCASE and LOWCASE are the functions which are used for character handling functions.

Difference between Input and Put function?

Input function – Character to numeric conversion- Input (source, Informat) and put function – Numeric to character conversion- put (source, format)

BY processing requires that your data already be sorted or indexed in the order of the BY variables.

For indepth knowledge on SAS, click on below