Interview Question

1. What is the use of Varnum option in Proc Contents ?

2. Missover & Truncover can only be used in infile statement. ?

  1. True
  2. False

3. Difference between DO While & DO Until ?

4. Difference between NoDup Key & NoDup out in SAS ?

5. Does Scan function works on word only ?

  1. True
  2. False

6. Give the syntax for to clear the Log window?

7. Difference SAS DATA Step & SAS Proc step.

8. What is the difference Put as function & Put as a statement?

9. By Class statement in in Put means what we tells the SAS.?

10. How does the SAS Processor works ?

  1. It compile
  2. Interpret

11. Difference between nodupkey & nodup in SAS ?

12. What is difference between Single Dash (A1-A4) & Double Dash (A1– A4) in SAS?

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

  1. True
  2. False

 

  1. 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.

 

  1. 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

 

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

 

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

 

  1. 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;

  1. 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

 

  1. 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
  2. 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
  3. Is it needed to use the By statement in 1 to 1 merge. ?
    1. Yes
    2. No

 

  1. What is the purpose of Retain Statement ?

 

  1. What is the name Default Library in SAS ?
  2. What is the Syntax for Proc Transpose ?
  3. 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
  4. Freq, Percent, means,N
  5. Difference between Proc Means & Proc Summary .
  6. Give example of Global Functions in SAS?
  7. When PDV Executed in compilation phase then what does the crawler first check ?
  8. Syntax
  9. Format
  10. 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.