1. Can we have the data from the table into the Input Buffer. By using the set statement.

1. True
2. False

2. Tell various ways to limit the observation the from the Table and also write the syntax fot that assuming the 8 observation to processed out of 16 observation.

3. What will be the output of this :-

            data formatchek ;

format sal dollar. ;

input sal id;

cards ;

10.000 2

12,000 3

;

Run;

1. Missing Value
2. $10
3. No output showing error
4. Proper values with only $ in sal column

4. Which one is fast ?
   1. keep, drop as a option
   2. keep, drop as a statement

5. Which one is slow ?
   1. Keep/Drop use in Set Statement.
   2. Keep/Drop use in Data Statement.
6. Syntax of which date format is wrong, if wrong then write the correct syntax ?
   1. 19/10/1989 – ddmmyy10.
   2. 01Mar2014 – ddmmyy9.
7. What are Blue words in SAS ?
   1. LAG Function in SAS Store the value in ?
   2. Give example of Summary Function ?

10. In which substr can’t work ?
    1. ASDIRF
    2. 11245
    3. AOIT.D
    4. It work in all of the options.

11-13.

      data studentDetails;

      Infile datalines DLM =’,’;

      input Studentid Name $ SubjectId;

     datalines;

      100, Vijay ,1001

      104, Amaresh,1003

      105, Abhishek,1005

      103, Rohit,1004

      102, Sandeep,1005

      ;

       run;

       data SubjectDetails;

       Infile datalines DLM =’,’;

       input SubjectId subject $ Maxmarks;

      datalines;

      1001, Maths ,144 

      1003, Hindi, 107

      1004, sans, 15

      1002, eng, 76

      1007, eng, 82

      ;

      data abc;

      merge Studentid(in=V) SubjectDetails(in=U) ;

      by SubjectId ;

      run;

11. If we want the Student id which is not common in table abc . What is the correct syntax for                       t     that
    1. . V=1
    2. . V=1 & U=0
    3. . V=1 & U=1
    4. .V=0 & U=1

12. If we want the common records of Studentid & Subject Details . Then what is the syntax  for   that?
    1. a.V=0 and U=0
    2. b.V ne 1 or U ne 1
    3. c.V =0 or U =0
    4. d.V=1 and U=1
13. If we want the non common records of Studentid & Subject Details . Then what is the syntax   for   t     that?
    1.  V=0 and U=0
    2.  V ne 1 or U ne 1
    3.  V =0 or U =0
    4.  V=1 or U=1
14. Is it needed to use the By statement in 1 to 1 merge. ?
    1. Yes
    2. No

15. What is the purpose of Retain Statement ?

16. What is the name Default Library in SAS ?
17. What is the Syntax for Proc Transpose ?
18. The default statistics that Proc Freq for one variable produce ?
    1. Freq, Percent, Cummulative Freq, Means
    2. Freq, N, Cummulative Freq, Means
    3. Freq, Percent, Cummulative Freq, Cummulative Percent
19. Freq, Percent, means,N
20. Difference between Proc Means & Proc Summary .
21. Give example of Global Functions in SAS?
22. When PDV Executed in compilation phase then what does the crawler first check ?
23. Syntax
24. Format
25. Give example of Execution types of Error.?

I am text block. Click edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.