SAS Interview Questions I

 SAS interview Questions

1)      Can merge statement give output without BY statement? Give at least one example on it.

2)      If I have following two data sets.

    New

a	b
1	2
3	4
5	6

Test

a	b
3	5
1	6
5	7

I am submitting following code.( Assume that NEW and TEST Data sets will be sorted by A and B variable.)

Data nete;

  Merge new test;

  By a b;

Run;

What will be my output?

3)      Difference with Data step Merge and SQL join with example.

4)      How to define Merging, concatenating and Appending.

5)      Assume that you have 50 observation in one data set and 3000 observation in another data set. If you use DATA step Merge to combine the data sets, how many observations are read from the larger data set (i.e. second data set)?

6)      Why we use Index? Is it necessary to make it?

7)      When you use SET statement with multiple data sets, suppose variable salary defined in one data set contain type character and salary defined in another data set contain type numeric. Did my SET statement work without error?

8)      What is interleaving?

9)      How do you insert comments in Macro?

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