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
 

Resource Utilization

As a SAS Programmer we are utilizing following resources:

1> CPU TIME

2>NETWORK BANDWIDTH

3>VIRTUAL MEMORY

4>PROGRAMMERS TIME

5>I//O

6>DATA STORAGE SPACE


An efficient SAS programmer should always Benchmark the SAS programs and conserve the Resources.

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