My SAS Tutorials

Showing posts with label SAS interview Conceptual Questions SAS Questions. Show all posts
Showing posts with label SAS interview Conceptual Questions SAS Questions. Show all posts

Wednesday, 23 September 2015

Symphony Teleca SAS Interviews Questions


1.      What if you write _NULL_ in DATA Step as DATA  _NULL_  ?
2.      What is the difference between FORMAT and INFORMAT ?
3.      Difference between NODUPKEY and DUPOUT and there uses ?
4.      What is the use of PROC FREQ ?
5.      What is the difference  between PROC MEANS and PROC SUMMARY ?
6.      What is PROC TRANSPOSE ?
7.      What is the difference between IF and WHERE ?
8.      Dataset one having one variable X and we need the output as variable Y (Accumulating Total)
X                            Y
1                            1
2                            3
3                            6
4                            10
5                            15
6                            21
7                            28


                             
9.      Different type of ODS ?
10.   Difference between PROC REPORT and PROC TABULATE ?
11.   MERGE dataset  Left join Right and MERGE Statement.
12.   Explain SQL LEFT and RIGHT JOIN.
13.   Difference between Positional and Keyword parameter.
14.   In how many ways we can create MACRO Variable.
15.   Difference between INPUT and PUT Function ?
16.   Difference between INPUT and PUT statement ?
17.   Explain Functions : SUBSTR() , SCAN() INTCK() and INTNK().
18.   Explain Numeric functions : INT(), CEIL() and FLOOR().

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com

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





               

Thursday, 23 April 2015

HCL Interview Questions


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 .

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com


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

Symphony Teleca Interview Questions on SAS

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?

Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com