interview

    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


 
 
 

 

Comments

  1. Its help me to improve my knowledge and skills also.im really satisfied in this session.MSBI Training in Bangalore

    ReplyDelete

Post a Comment

Popular posts from this blog