BASE SAS Interview Questions ?

1) Explain what is SAS? What are the functions does it performs?

Answer : 1) SAS means Statistical Analysis System, which is an integrated set of software products.

• Information retrieval and data management

• Writing reports and graphics

• Statistical analysis, econometric and data mining

• Business planning, forecasting and decision support

• Operation research and Project management

• Quality Improvement

• Data Warehousing

• Application Development and much more.

2)what is the basic structure of SAS programing?

Answer :

3) What is the basic syntax style in SAS?

Answer)

4) Difference between Data Step and Proc Step?

5) what is PDV ( Program Data Vector) ?

6) Difference Between PROC PRINT and PROC CONTENTS ?

Answer : PROC PRINT gives Data Portion as output whereas PROC PRINT gives Descriptive Portion of SAS Data set.

7) Difference between SAS Informats and Formats ? And how one can make them Permanent in nature?

8) Difference between Missover and Truncover ?

9) Difference between INPUT and INFILE ?

10) How to include or exclude specific variables in a data set? or Difference Between DROP and KEEP statement ?

11) How to print observations 5 through 10 from a given data set? ( tip Firstobs = obs =)

12) What are the default statistics that PROC MEANS produce?

13) Difference between MEAN FUNCTION and PROC MEANS ? ( tip : Mean() is a function, Proc Print is a procedure for output)

14) Differences between WHERE and IF statement?

15) What is DATA _NULL_?

Answer : The DATA _NULL_ is mainly used to create macro variables. It can also be used to write output without creating a dataset. The idea of "null" here is that we have a data step that actually doesn't create a data set.

16) What is the difference between '+' operator and SUM function? ( tip : Take case of missing values)

17) How to sort in descending order?

18) How to convert a numeric variable to a character variable?

19) How to convert a Character variable to a Numeric variable?

20) What's the difference between VAR A1 - A3 and VAR A1 -- A3?

Answer: