Blog

Base SAS Interview Questions

  • (4.0)

If you're looking for Base SAS Interview Questions for Experienced or Freshers, you are at right place. There are lot of opportunities from many reputed companies in the world. According to research Base SAS has a market share of about 17.8%. So, You still have opportunity to move ahead in your career in Base SAS Programming. Mindmajix offers Advanced Base SAS Interview Questions 2018 that helps you in cracking your interview & acquire dream career as Base SAS Programmer.

Q. What is SAS?

SAS means Statistical Analysis System, which is an integrated set of software products. It is a software suite for advanced analytics, multivariate analyses, business intelligence, data management and predictive analytics.

Q. What is Base SAS?

Base SAS is a text-based, basic IDE with an older interface. Enterprise Guide (EG) is a more GUI-like IDE with wizards to assist with writing code for various processes. 

Q. Explain the use of SUBSTR function?

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

Enhance your IT skills and proficiency by taking up the SAS Training.

Q. What is the function of Stop statement in a SAS Program?

Stop statement causes SAS to stop processing the current data step immediately and resume processing statement after the end of current data step.

Q. Explain what is Data Step?

The Data step creates an SAS dataset which carries the data along with a “data dictionary.” The data dictionary holds the information about the variables and their properties.

Q. How many data types are there in SAS? 

There are two data types in SAS. Character and Numeric. Apart from this, dates are also considered as characters although there are implicit functions to work upon dates.

Q. Briefly explain Input and Put function?

Input function – Character to numeric conversion- Input(source,informat)

put function –  Numeric to character conversion- put(source,format)

Q. Define RUN-Group processing?

RUN-Group processing is used to submit a PROC step using RUN statement without ending the procedure.

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

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

Q. What is the length assigned to the target variable by the scan function?

200

Q. How do you specify the number of iterations and specific condition within a single do loop?

data work;
do i=1 to 20 until(Sum>=20000);
Year+1;
Sum+2000;
Sum+Sum*.10;
end;
run;

This iterative DO statement enables you to execute the DO loop until Sum is greater than or equal to 20000 or until the DO loop executes 10 times, whichever occurs first.

Q. How can you limit the variables written to output dataset in DATA STEP?

Both DROP and KEEP can be used to  limit the variables in the dataset.

  • The DROP= option tells SAS which variables you want to drop. If you place the DROP= option on the SET statement, SAS drops the specified variables when it reads the input data set and if you place the DROP= option on the DATA statement, SAS drops the specified variables when it writes to the output data set.
  • The KEEP= option tells SAS which variables you want to keep. If you place the KEEP= option on the SET statement, SAS keeps the listed variables when it reads the input data set. On the other hand, if you place the KEEP= option on the DATA statement, SAS keeps the specified variables when it writes to the output data set.

Q. Explain BOR function?

It is a bitwise logical operation and is used to return bitwise logical OR between two statements.

Q. Mention the validation tools used in SAS?

For DataSet : Data set name/ debug Data set: Name/stmtchk
For Macros: Options: mprint mlogic symbolgen

Q. What is the difference between do while and do until?

DO WHILE expression is evaluated at the top of the DO loop. If the expression is false the first time it is evaluated, then the DO loop never executes. Whereas DO UNTIL  executes at least once.

Q. How to convert a numeric variable to a character variable?

You must create a differently-named variable using the PUT function.

The example below shows the use of the PUT function.

charvar=put(numvar, 7.) ; 

Q. Mention what is PROC in Base SAS?

In Base SAS, PROC steps analyze and process data in the form of an SAS data set. It controls a library of routines that perform tasks on SAS data set such as sorting, summarizing and listing.

Q. Mention the difference between SAS functions and procedures?

The difference between SAS functions and procedures is that

  • Procedures expect one variable value per observation
  • Functions expect values to be supplied across an observation

Q. Explain COMPRESS data set option?

It is used for compressing the data into new output.

Q. What are the features of Base SAS system?

It provides Ipv6 support, new true type fonts, extended time notations, restart mode, universal printing, checkpoint mode and ISO 8601 support.

Q. How can SAS program be validated?

By writing OPTIONS OBS=0 at the starting of the code and if execution of code is On PC SAS than log will be detected itself by highlighted colors. These are the two ways for validating an SAS program.

Explore SAS Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

 


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules