Base SAS and SAS Programmer Interview Questions and Tips-Top  SAS Interview Questions & Answers

1.Difference between do while and do until

2.Proc Report Vs Proc Print

3.Proc Append

4.SAS Formats Vs SAS Informats

5.Special input delimiters

6.Default statistics Displayed for Proc Means 

7.Proc Means Vs Proc Freq Vs Proc Univariate

8.Compress data set using system options or data set options (COMPRESS=yes or COMPRESS=binary)

9.How to Compress a Table in SAS?

10.CROSSLIST option in  TABLES statement?

11.How would you delete Observations(Duplicate observations)?

Proc sort……nodups;

proc sql..use distinct in Select

12.What is Tabulate.?Why we use it.? Which type of output we get from Tabulate.?

13.In which format Date get stored in sas..? What is the use of DATE in SAS.?

14.what is the difference between nodupkey and nodup options?

15.Please Mention the validation tools used in SAS?

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

16.What is _n_?

17. Name statements that are execution only.
INFILE, INPUT

18. WHAT IS THE SIGNIFICANCE OF JANUARY 1ST, 1960?

19. WHAT PURPOSES DO YOU USE DATA _NULL_?

20.What is Purpose of double trailing @@ in Input Statement ?

21.How to include or exclude specific variables in a data set?

22.What are the default statistics that PROC MEANS produce?

23.What is Program Data Vector (PDV)?

24.How to remove unique and duplicate values?

By using PROC SORT with NODUPKEY and NODUP Options.

25.Data Cleaning Character Functions

26.What happens when SAS encounters Data error?

27.How to view contents of a SAS library?

we can use the following general form of the procedure:

PROC CONTENTS data = libref._ALL_ NODS;
RUN;

where:

  • libref is the libref that you assigned to the library
  • the _ALL_ option requests a listing of all of the SAS files in the library
  • the NODS option (which stands for “no details”) suppresses the printing of detailed information about each file when you specify the _ALL_ option.

you can specify the NODS option only when you specify the _ALL_ option.

28.What is the use of  compbl function?

to convert blank in  to convert multiple blanks to a single blank in a Character String.