My SAS Tutorials

Friday 20 September 2013

NTT Data F-2-F Questions

Questions:

1>What is the difference between Call Symput and Call SymputX?
2> In how many ways you can create macro variables?
3> Explain the Compilation and Execution phase of Data Step when reading SAS data set and raw data set?
4> What is the difference between multiple Set statement and Single set statement in the data Step?
5> What is the difference between appending and concatenation?
6> What is the difference between Multiple set statement and merge statement in the Data Step?
7> What is the difference between INTCK and INTNX functions ?
8> What is the difference between SQL Passthrough query and libname statement?
9>What is the difference between %STR and %NRSTR in Macros?
10> Which all Macro options you have used?
11> Which all automatic Macro variables you have Used?
12> How to Save Macro permanently?
13> How to delete macro programs?
14>What is the difference between Global Symbol Table and Local Symbol Table?

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com



For training related info kindly mail us at info@sankhyana.com
Sankhyana Consultancy Services
www.sankhyana.com

Sunday 7 July 2013

Quintiles Interview Questions





                                       Questions asked By QUINTILES:
   1)      Tell me something about yourself or introduce yourself.  
   2)      What is Bio-informatics? (Detail questions on background of a student).
   3)      How SAS differ from other language like C++, JAVA, and HTML that you have learned?
   4)      How much you comfortable in SAS?
   5)      Why you select SAS as a Career?
   6)      How do you read and write raw data file?
   7)      Explain SCAN function, INDEX function in detail.
   8)      How can you calculate age?
   9)      What is informat and format? (in detail)
  10)  How many ways to create macro variable?
  11)  What is difference between %LET and %Global Statement?
  12)  How do you create multiple macro variables in Proc SQL?
  13)  What is Macro?
  14)  Can you write raw data file which is CSV file by using PUT statement?
  15)  Why we use DATA _NULL_?
  16)  Questions on multiple SET statements?
  17)  Which SAS version you have used?
  18)  Why have changed your domain to SAS?
  19)  Application of SAS.
  20)  What will you do if any new software will come after one year?
  21)  Which steps are used to make up SAS program?
  22)  What is the type of Macro variable?
  23)  How can we apply user defined format?
  24)  How SAS will store date?
  25)  Value of 01JAN1960.
  26)  Explain Proc Compare. Why it is used?
  27)  What is ODS? (Tell me about ODS).
  28)  Can we create a text file using ODS? How?
  29)  Explain Proc Import and Proc Export. (In detail)
  30)  Why we use quit statement in Proc SQL instead of run Statement.
  31)  What options we used in Proc Sort to store the duplicate observations.
  32)  Explain Proc Means.
  33)  Difference between Proc Means and Proc summary.
  34)  Explain Univariate procedure. What is by default output?
  35)  Plot option in univariate procedure.
  36)  Explain Call Symputx and Call symget.
  37)  How can we delete Macro variables.
  38)  ID statement in transpose procedure.
  39)  By and Class statements in Means Procedure.
  40)  From where you learn SAS.
  41)  What is Epoch Research Institute (in detail).
  42)  Why and how do you join this institute?
  43)  Tell me about your work experience.
  44)  Have you done any live and Demo Project.
  45)  Do you have any questions? Or do you have any query?


Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com


For training related info kindly mail us at info@sankhyana.com
Sankhyana Consultancy Services
www.sankhyana.com
     

Tuesday 28 May 2013

Advance SAS interview Questions

Frequently asked Advance SAS Interview Questions

1> What is the use of Macros in SAS?

2> What is Autocall Facility?

3> In How many ways we can create Macro variables in the Global Symbol Table?

4>In How many ways we can create Macro variables in the Local Symbol Table?

5> What  is the difference between Call Symputx and Call Symput?

6> What is the difference between Keyword parameters and Positional parameters?

7>What is the difference between %NRST and %STR Functions?

8>What is Symget?

9> How to resolve Multiple Ampersand Symbols?

10>Write a program to delete all the User Defined Macro variables form the Global Symbol Table?

11>Explain the Syntax of proc SQL?

12> What is the difference between Sub-queries and SQL Views?

13>What is the difference between Inner join and Outer joins? Explain with examples?

14>How to vertically combine SAS Date Set by using Proc SQL and how it is different from Data Step Concatenation?

15> In How many ways we can create SAS Data set by using proc SQL?

16> How to create Macro variables by Using Proc SQL?

17>How to save a program by using Data step?

18>What is the difference between Joins and Merging?

19> What is Benchmarking in SAS?

20>Explain Indexes? In How many ways we can create Indexes?

21> Explain SAS Views? In How many ways we can Create SAS views?

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com


For training related info kindly mail us at info@sankhyana.com
Sankhyana Consultancy Services
www.sankhyana.com

Base SAS Interview Questions

Frequently Asked Base SAS Interview Questions

1> In how many ways we can combine SAS data set by using Data step?

2> What is the difference between Interleaving and Concatenation?

3>What is the difference between Put Statement and Put Function?

4>What is the difference between Input Statement and Input Function?

5>What is the difference between Infile Statement and File Statement?

6> What is the use of _NULL_ in the Data Step?

7>What is the difference between Proc Means and Proc Summary?

8> How to delete SAS Data Set?

9>How to rename a SAS Data Set?

10>What is the difference between Left Substr and Right Substr Function?

11> What is the difference between Substr and tranward Function?

12> What is the Default output of proc Means?

13> What is a lookup table in SAS?

14>How to create Lookup table in SAS?

15>Name Some Array Functions?

16> What is the difference between Nodup and Nodupkey in Proc Sort?

17>What is the use of By and ID Statements in proc Print?

18> What is the syntaxt of Proc Transpose?

19>Explain Proc Datasets?

20>Explain Proc Copy and Proc Compare with examples?

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com



For training related info kindly mail us at info@sankhyana.com
Sankhyana Consultancy Services
www.sankhyana.com