Online Base SAS and Advance SAS Mock Exams

 Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests.

We have great news for you. We are here to help you attain your goal by using our online certification practice exam podium. This helps each individual to improve your skills and expertise by going through the process of preparing for SAS exam. Our online practice exam gives you the advantage of screening your knowledge and makes yourself familiarize with Certification Exam question pattern, interface concepts.

Benefits of taking SAS exam at Sankhyana Consultancy Services:

• Our online practice exam is perfect match of actual Base SAS & Advance SAS Certification exam which allows you in clearing the SAS global certification exam

• We offer unlimited attempt to practice our online exam. Each exam paper contains 70 questions prepared by our experts

• Each module accommodate more than 10 distinctive test papers

• You can view your result of each exam and performance history of your past attempts

• You can also join groups and compare your score with your group members

• You can choose your subject and write the exam

• You can write exam at any time 24 X 7

• You will get complete analysis report about your exam at the end

 Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests.

http://exam.sankhyana.com

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

www.sankhyana.com    

               

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

www.sankhyana.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

Ernst And Young Interview Questions

1.Explain PDV concept?
2.Diffrenece between If and where statement ?
3.Difference between formats and informats?
4.Length statement?
5.how sas reads date?
6.Scan and substr function?
7.compress function?
8.compbl function
9.explain concatenation and interleaving?
10.logical variables?
11.first.variable and last.variable?
12.nodupkey and nodup difference in proc sort?
13.diff between class statement and var statement in proc freq?
14.default output in proc means?
15.proc freq default o/p?
16.Infile option(Like missover,truncover,DLM,DSD).

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

www.sankhyana.com

WNS Interview Questions

1.       What is PDV?

2.       Diff between where & if statement in respect to PDV?

3.       Different ways of creating macro variables.

4.       Diff between call symputx & %let.

5.       What are intck & intnx functions & what is the diff between them.

6.       What is vlookup in Excel?

7.       What are the diff types of joins?

8.       What are macros % what are the debugging techniques in macro.

9.       What is symbolgen?

10.   %let i= 1+2

%put &i.

What is the value of i.

11.   What  is the function used in macros to do arithmetic calculations?

12.   What  is the function used in macros to use SAS functions?

13.   What is data _null_ ?

14.   %let i=1

Data _null_;

Set one;

Call symputx (‘x’, 2);

Run;

%put &i

What is the value of i?

15.   %let i=1

Data _null_;

Set one;

Call symputx (‘x’, 2);

%put &i

Run;

What is the value of i?

16.    what are the key factors that should  be considered while converting .CSV, .txt & .xls to SAS data set.

17.   What is the statement used to reference .csv file in data step?

18.   Data set one has 5 observations & two has 10 observations. What will be the no. of observations in the output datasets in the below programs.

Data three;                 Data four;

Set one two;               set one;

Run;                              set two;

                                      Run;

19.   What is the name of the following methods referenced in data step processing.

Data three;                 Data four;

Set one two;               set one;

Run;                              set two;

                                      Run;

20.   Write the syntax for inner join in proc SQL & data step processing.

21 We have a SAS Data Set One:

	One
Name	Subject	Marks
Ram	Maths	30
Ram	Maths	20
Ram	Sceince	30
Ram	Sceince	50
Ram	Sceince	60
Ram	History	30
Ram	History	50

                          We need the output Like:

                                    Two

Name	Subject	Marks	Total
Ram	Maths	30	30
Ram	Maths	20	50
Ram	Sceince	30	30
Ram	Sceince	50	80
Ram	Sceince	60	140
Ram	History	30	30
Ram	History	50	80

                                     And

                                     Three

Name	Subject	Marks
Ram	Maths	20
Ram	Sceince	60
Ram	History	50

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

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

Genpact Interview Questions

1.       Different ways of deleting duplicates from a sas data set.

2.                                                          Proc sort data=one nodupekey;

                                     By variable;

                                 Run;

Equivalent code in SQL.?

3.       Var1 var2 var3

 Create  New Variables which should contain a Difference of present observation to the previous  observation for all the three Variables.

4.       Difference b/w Proc Tabulate and Proc Report?

5.       Different ways of creating Macro Variables?

6.       How to calculate the difference in months of two Date Variables?

7.       Data set has n no of variable. Create variables like Newavr1 to n with average of 1-4 Variables for first Variable and average of 2-5 for second and so on…

Existing Variables         

Var1 Var2 Var3…… Varn       

                                                

New Variables

     Newvar1                      Newvar2                             Newvar3…….      

Avg of Var1-Var4       Avg of Var2-Var5               Avg of var3-var6.......

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

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

Nettpositive Interview Questions

NetPositive Interview Questions       

Written test had four questions.

1.       Base:

Four  variables  names with type and length were provided along with a page of conditions and specifications for each variable. A program had to be written for creating variables, also, array had to be used to perform a temporary look up and sub setting if statement was to be used in the program.

2.       Macro:

Dataset1:

Seq1  var1 var2

100  10    1

200  20    2

300  30    3

Dataset2:

Seq2 var3 var4

400  100    1

200  200    2

200  300    3

Dataset3:

Seq3 var5 var6

400  100    1

200  200    2

200  300    3

Data dataset4 ;

Set dataset1;

If _n_=1 then do ;

Temp1=var1+va2;

Temp2=var1/var2;

End;

Run;

Data dataset5;

Set dataset2;

If _n_=1 then do ;

Temp3=var3+va4;

Temp4=var3/var4;

End;

Run;

Data dataset6;

Set dataset3;

If _n_=1 then do ;

Temp5=var5+va6;

Temp6=var5/var6;

End;

Run;

Write a single macro program for the above three different programs.

3.       Merging:

Dataset1:

Seq  var1 var2

1     10    1

2    20    2

3    30    3

Dataset2:

Seq  var2 var3

1   100    1

3   200    2

3   .         4

4   300    3

Write the output for the following programs.

Data  _1;

Merge dataset 2 dataset1;

By seq;

Run;

Data _2;

Merge dataset1 dataset2;

By seq;

If first.seq and last.seq;

Run;

Data _3;

Merge dataset2(in=one)  dataset1(in=two);

By seq;

If  one and not  two;

Run;

4.       Efficiency:

If the dataset has one million of observations, which one of the following program is more efficient in terms of reducing the cpu time.

Partial dataset:

Dataset:

Var3 Seq1  var1 var2

US    100  10    1

EU    200  20    2

IND  300  30    3

Program No.1

Data US IND EU;

Set dataset;

If var3=‘US’ then output US;

If var3=’EU’ then output EU;

If var3=’IND’ then output IND;

Run;

Program no. 2

%macro report(country);

Data &country;

Set dataset;

If var3= ‘’&country ‘’ then output &country;

Run;

%mend report;

%report(US)

%report(EU)

%report(IND)

Face to face technical round:

1.       Tell me about your experience in SAS.

2.       How good are you in Macro?

3.       How do you define a variable( a macro variable)?

4.       You have a workbook test.xls. How do you access that into SAS?

5.       What are the uses of SAS ACCESS software?

6.       Have you come across DMS, any experience on that?

7.       There are two employees, x and y. Suppose the sum of their age and difference of their age is 80 and  20, respectively. What are the ages of employees? No pen and paper- one min to answer.

8.       There is a list of employee ID and every month a new employee is added. Write a Macro program to cross check the uniqueness of the employee ID. 

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

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