SAS Interview questions: April 2015

Thursday 23 April 2015

Hcl Interview Questions:

1.Define PDV and explain compilation and execution phase in Data step?

2.Explain with program, what are the uses of Data _NULL_?

3.Explain the difference between Missover ,Flowover and Truncover ?

4.Question asked about the scenario basis on truncover and Missover.

5. Explain the difference Nodup and Nodupkey and write syntax?

6.Write syntax and output variable for proc freq and proc means.

7.Whate are the difference between Proc Means and Proc Summary?

8.Explain different types of joins in SQL?

9.Explain the use of left join with scenario ?

10.What are the difference between formats and informats ?

11.Explain the syntax of Put function .

For training related queries kindly mail us at info@sankhyna.com

Symphony Teleca SAS Interview Questions

1.What is SAS library ?

2.What is temp library and why we call as temp library?

3.How the program flows?

4.What is difference between PROC and DATA Step?

5.What is PDV and explain its importance?

6.How PDV works in Proc and Data Steps?

7.What are the variable present at the PDV?

8.What is _n_ and _error_ defines?

9.What are the activities happens while reading data into PDV?

10.Show the PDV behavior when reading raw data file ?

11.What is the difference between DSD vs DLM=?

12.What is the difference between Proc Summary and Proc Means and Proc Univariate ?

13.What is Proc Rank and explain with examples?

14.Macro variables declaration type?

15.What are the difference between Call Symputx and % let statements?

16.In how many ways we can concatenate SAS data sets?

17.Explain the difference between Proc Append and Set Statement?

18.What are the difference between Merge and SQL Joins?

19.How to connect the database?

20.Write the syntax for left join,right join,full join, and inner join?

SAS Interview questions