Signetsoft (Corporate Training / Online Training / Classroom Training in Bangalore)

    SAS Interview Questions and Topics List

EXTRACTION

READING RAW DATA:

1. How many data types we have in SAS?
2. What are the limitations for memory allocation for SAS variables
3. What is maximum number of rows and cols can be handled in SAS?
4. What is maximum storage capability of SAS?
5. Why do we use INFILE and INPUT Statements in SAS?
6. What are the SAS naming rules?
7. What is the difference between Rename and Label?
8. Single @ vs double @@
9. Missover Vs Truncover
10. DLM and DSD
11. How to handle huge data
12. Necessity of INFORMATS
13. : and & modifiers.
14. Purpose of INFILE and INPUT statements
15. Why do we use FORMATS and INFORMATS in SAS?

SAS/ACCESS:

1. Libname
2. SQL Passthrough
3. DBload process
4. Libname Vs SQL Pass through
5. DBlaod Vs (Libname & SQL Passthrough)
6. Syntax for libname
7. Syntax for sql pass through
8. Syntax for dbload.

MANIPULATION

 FUNCTIONS:

1. Give me some names of function you know (eg. Intck, intnx, weekday, substr, scan)
2. Length Vs lengthc functions
3. Cat vs catx functions
4. Retain statement
5. Do-Loop
6. Arrays
7. What is the output for the following code:

      Data sample;

       X=month(today());

       Format x date.;

      Run;

8. x= ‘abc’; x = ‘abcd’;

9. y = 24; y = 245;

10. x = 123456789; y=substr(x,3,4);

11. Intck() Vs intnx()

12. Index() vs scan()

13. List of system options.

14. Significance of 1920 and significance of 1st jan 1960;

15. What is the diff b/w arithmetic summation and sum function?

16. Put() and input() functions

17. INFILE & INPUT statements Vs FILE & PUT statements

18. Mod(), round() and int()

19. Length(), lengthc(), substr(), scan(), index(), compress(), compbl().

20. Day(), month(), year(), MDY(), datejul(), intck() and intnx().

21. If-then-else.

22. Do-while Vs Do-until

23. Label statement.

24. IF vs WHERE statements

25. LENGTH statement

COMBINING DATASETS:

1. Set ds1 dsn2; Vs Set dsn1; Set dsn2;
2. Proc Append – Force option
3. Append Vs Stacking (concatenating)
4. How to update an existing dataset with another SAS dataset using DATA step?
5. Interleaving Vs stacking
6. Merge with BY Vs Merge without BY statements
7. Merge with IN = option
8. First.var and Last.var —– Purpose?
9. Merge Vs Joins

ANALYSIS

PROCEDURES:

1. Proc Sort – nodup/nodupkey/dupout/out=
2. What are the ways to remove Duplicate data?
3. Proc Report – Define/Group/Order/Break/Rbreak/Compute
4. Proc Tabulate (Page, Row, Col), how to add statistics to Tabulate Report
5. Proc transpose – By / Var / ID statements
6. Can u modify SEX variable values from ‘F’ to ‘M’ and ‘M’ to ‘F’ in sashelp.class table?
7. Proc Means – By / Class /Output Out= /
8. How _type_ and _Freq_ are calculated?
9. Proc Datasets
10. Proc Compare
11. Proc Format
12. Proc Printto

SAS/STAT  (for Statistical Analysis)

1. Proc Univariate
2. Proc Means
3. Proc Freq
4. Proc Corr
5. Proc Reg
6. Proc Anova
7. Proc GLM
8. Proc Ttest

REPORTING

ODS:

1. ODS TRACE ON/OFF
2. ODS SELECT / EXCLUDE
3. How to create html/rtf/pdf outputs.
4. How can you apply style attributes to different procs like PRINT, REPORT, Tabulate

SAS/GRAPH

1. Proc PLOT   
2. Proc CHART
3. Proc GPLOT
4. Proc GCHART

SQL  

SAS/SQL:

1. Syntax for a) CREATE table b) INSERT c) INNER joins
2. How to Sort datasets?
3. How to remove duplicates?
4. Nodup Vs Distinct
5. How to count no. of observations?
6. How to get employee details with highest salary?
7. How to get employee details with second highest salary?
8. What is union and union corr ?
9. Union Vs Union All
10. What is self join?
11. How to create a view?
12. Table Vs View
13. What is Cartesian product?
14. Group By / Order By / Having
15. Where Vs Having
16. Delete Vs Drop
17. Tables VS Views

AUTOMIZATION (MACRO)

MACROS:

1. Ways to create macro variables
2. Data variable Vs macro variables
3. Data types in macros.
4. Length range for numeric, character, macro variable.
5. Purpose of %eval and %syseval
6. Local macro variable Vs Global macro variable.
7. User macro var Vs System macro var.
8. Creating variables using INTO class (by default global)
9. %local and % global
10. Indirect reference in macros
11. Nested macros
12. %sysfunc
13. Quoting functions – %str, %nrstr
14. Call symput (executed by SAS processor)
15. Symget Function
16. How to debug the macros?
17. Difference between MLOGIC and Symbolgen?
18. What is Symbol table?
19. How to create global macro variables inside a macro?
20. How to create local macro variables using Call Symput?

******************************************************************************************

Signetsoft provides you the best Training in Bangalore for SAS, SAS clinical, SAS projects, SAS Certification, Advanced Excel, VBA, Java, Clinical Data Management…

A practical approach! and real time expert faculty, good in placement record.

contact us: info@signetsoft.com

mob: 98 4455 9330

http://www.signetsoft.com