SAS Interview Qstns and Topics List:
READING RAW DATA:
- How many data types we have in SAS?
- What are the limitations for memory allocation for SAS variables
- What is max no rows and cols can be handled in SAS?
- What is storage capability of SAS?
- Why do we use Infile and Input Statements in SAS?
- What are the SAS naming rules?
- What is the difference between Rename and Label ?
- Single @ vs double @@
- Missover Vs truncover
- Dlm and dsd
- How to handle huge data
- Necessity of informats
- : and & modifiers.
- Purpose of infile and input statements
- Why do we Formats and Informats in SAS
FUNCTIONS:
- Give me some names of function you know (eg. Intck, intnx, weekday, substr, scan)
- Length Vs lengthc functions
- Cat vs catx functions
- Retain statement
- Do-Loop
- Arrays
- What is the output for the following code:
Data;
X=month(today());
Format x date9.;
Run;
8.
x= ‘abc’; x =
‘abcd’;
9.
y = 24; y =
2456;
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
PROCEDURES:
- Proc Sort – nodup/nodupkey/dupout/out=
- Proc Report – Define/Group/Order/Break/Rbreak/Compute
- Proc Tabulate (Page, Row, Col), how to add statistics to Tabulate Report
- Proc transpose – By / Var / ID statements
- Can u change values ‘F’ to ‘M’ and ‘M’ to ‘F’ in sashelp.class table?
- Proc Means – By / Class /Output Out= /
- How _type_ and _Freq_ are calculated?
- Proc Datasets
- Proc Compare
- Proc Format
- Proc Printto
ODS:
- ODS TRACE ON/OFF
- ODS SELECT / EXCLUDE
- How to create html/rtf/pdf outputs.
- How can you apply style attributes to different procs like PRINT, REPORT, Tabulate …
COMBINING DATASETS:
- Set ds1 dsn2; Vs Set dsn1; Set dsn2;
- Proc Append – Force option
- Append Vs Stacking
- How to update an existing dataset with another SAS dataset using DATA step?
- Interleaving Vs stacking
- Merge with BY Vs Merge without BY statements
- Merge with IN = option
- First.var and Last.var —– Purpose?
- Merge Vs Joins
SAS/SQL:
- Syntax for a) CREATE table b) INSERT c) INNER joins
- How to Sort datasets
- How to remove duplicates
- How to count no. of observations
- How to get employee details with highest salary
- How to get employee details with second highest salary
- What is union and union corr ?
- What is self join
- How to create a view
- Table Vs View
- What is Cartesian product?
- Group By / Order By / Having
- Tables VS Views
SAS/ACCESS:
- Libname
- SQL Passthrough
- DBload process
- Libname Vs SQL Pass through
- DBlaod Vs (Libname & SQL Passthrough)
- Syntax for libname
- Syntax for sql pass through
- Syntax for dbload.
MACROS:
- Ways to create macro variables
- Data variable vs macro variables
- Data types in macros.
- Length range for numeric, character, macro variable.
- Purpose of %eval and %syseval
- Local macro variable Vs Global macro variable.
- User macro var Vs System macro var.
- Creating variables using INTO class (by default global)
- %local and % global
- Indirect reference in macros
- Nested macros
- %sysfunc
- Quoting functions – %str, %nrstr
- Call symput (executed by sas processor)
- Symget Function
- How to debug the macros?
- Difference between MLOGIC and Symbolgen?
- What is Symbol table?
- How to create global macro variables inside a macro?
- How to create local macro variables using Call Symput?
