SAS Interview Questions and Topics List
EXTRACTION
READING RAW DATA:
- How many data types we have in SAS?
- What are the limitations for memory allocation for SAS variables
- What is maximum number of rows and cols can be handled in SAS?
- What is maximum 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 use FORMATS and INFORMATS in SAS?
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.
MANIPULATION
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 sample;
X=month(today());
Format x date.;
Run;
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:
- Set ds1 dsn2; Vs Set dsn1; Set dsn2;
- Proc Append – Force option
- Append Vs Stacking (concatenating)
- 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
ANALYSIS
PROCEDURES:
- Proc Sort – nodup/nodupkey/dupout/out=
- What are the ways to remove Duplicate data?
- 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 modify SEX variable values from ‘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
SAS/STAT (for Statistical Analysis)
- Proc Univariate
- Proc Means
- Proc Freq
- Proc Corr
- Proc Reg
- Proc Anova
- Proc GLM
- Proc Ttest
REPORTING
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
SAS/GRAPH
- Proc PLOT
- Proc CHART
- Proc GPLOT
- Proc GCHART
SQL
SAS/SQL:
- Syntax for a) CREATE table b) INSERT c) INNER joins
- How to Sort datasets?
- How to remove duplicates?
- Nodup Vs Distinct
- 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 ?
- Union Vs Union All
- What is self join?
- How to create a view?
- Table Vs View
- What is Cartesian product?
- Group By / Order By / Having
- Where Vs Having
- Delete Vs Drop
- Tables VS Views
AUTOMIZATION (MACRO)
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?
******************************************************************************************
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
Its help me to improve my knowledge and skills also.im really satisfied in this session.MSBI Training in Bangalore
ReplyDelete