SAS Interview Guidelines

Online Base SAS and Advance SAS Mock Exams

2015-09-24T08:22:00.003+05:30

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

For SAS Training, call us at: +91 8017768006, mil us: info@sankhyana.com

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXVII

2015-01-30T20:31:00.000+05:30

We have a SAS data set:

Product Order_Date
A 13jan2015
14jan2015
15jan2015
16jan2015
B 14jan2014
17jan2015
C 20jan2014
21jan2104
22jan2014

W need the output like:

Product Order_Date
A 13jan2015
A 14jan2015
A 15jan2015
A 16jan2015
B 14jan2014
B 17jan2015
C 20jan2014
C 21jan2104
C 22jan2014

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

www.sankhyana.com

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXVI

2014-10-01T15:33:00.000+05:30

We have a SAS data sets in that we have 100 variables.
We need to read only 50th and 8th variable to create another SAS Data sets.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXV

2014-07-14T21:45:00.000+05:30

We have two SAS data sets:

One

Name	Age	Salary
Ram	27	5000
Sita	28	6000
Radha	21	3000
Arjun	20	8000
Ram	27	5000
Radha	21	3000
Arjun	20	8000
Sita	28	6000
Bhim	19	7000

Two

Name	Age
Ram	27
Sita	28
Radha	21
Arjun	20
Bhim	19

We need to create a SAS data sets by merging SAS data sets one and two.

Three

Name	Age	Salary
Bhim	19	7000
Arjun	20	8000
Radha	21	3000
Ram	27	5000
Sita	28	6000

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXIV

2014-07-14T21:14:00.001+05:30

We have a SAS data Set:

One

Name	Age
Ram	27
Sita	28
Radha	21
Arjun	20
Ram	27
Radha	21
Arjun	20
Sita	28
Bhim	19

Required Output:(We need to remove the duplicates without changing the order of the observations)

Two

Name	Age
Ram	27
Sita	28
Radha	21
Arjun	20
Bhim	19

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXIII

2014-05-22T22:52:00.000+05:30

We have two SAS data set:

	One
Code	Name	Age
A00	Ram	21
A11	Sita	23
A22	Radha	24
A33	Arjun	23

	Two
Code	Name	Age
111	Laksman	20
222	Krishna	25
333	Bhim	26

We need the output like:

	Three
Code	Name	Age
A00	Ram	21
111	Laksman	20
A11	Sita	23
222	Krishna	25
A22	Radha	24
333	Bhim	26
A33	Arjun	23
		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 www.sankhyana.com

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXII

2014-03-21T23:12:00.000+05:30

We have a SAS Data Set "ONE".

Country Month Poulation
AU 1 500
AU 5 700
US 3 800
IND 6 1000
PAK 2 600
AU 7 500
US 6 700
IND 8 1200
. . .
. . .
. . .
. . .

Suppose we have 1,00,000 observations in the SAS Data Set "ONE". We don't know how many countries are there and how many times they are repeating.

We need to create separate SAS Data Set for each country.
Most efficient program will be appreciated.

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

2014-03-19T23:23:00.001+05:30

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXI

Libname test SPDE"C:\New Folder\SAS" TemP=Yes;

Option user=test;

data one;

set two(firstobs=51 obs=500000);

run;

Kindly go through the above SAS Program and write Proper explanation.

Write a program to change "WORKSPACE" for a SAS Session.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XX

2014-03-19T06:54:00.000+05:30

We have a comma delimited text file with 150 fields and 100000 records.
Write a SAS program with which we can read only 100th field and send this field into another text file.
Most efficient Program will be appreciated.

If you want to Learn Base SAS and Advance SAS please mail me at creativityofnature@gmail.com.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XIX

2014-03-14T21:26:00.000+05:30

We have a SAS Data Set "One" in that we have 100 variables starting from "XYZ_" like:

XYZ_VAR1
XYZ_VAR2
XYZ_VAR3
XYZ_VAR4
.
.
.
.
.
.
XYZ_VAR99
XYZ_VAR100

We need to recreate the SAS Data Set "One" with variables Names:

VAR1
VAR2
VAR3
VAR4
VAR5
VAR6
.
.
.
.
.
.
VAR99
VAR100

Most efficient program will be appreciated.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XVIII

2014-02-27T21:43:00.000+05:30

DATA Description

We have an Excel Sheet in that we have 1,000,000 Observations and 150 Variables.
Some of the Records(Entire Row) have Missing values.

TASK

Import the Excel Sheet into SAS Data Set with the best available technique . Remove all Missing Records in the SAS Data Set(If possible import only Non Missing Records).

Now we need to create Two SAS Date Sets "ONE" and "TWO".

Data Set "ONE" should have all the Character Variables with 25,000 Random Records.

Data Set "TWO" should have all the Numeric Variables with 50,000 Random Records.

Use best Possible Technique.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XVII

2014-02-27T21:06:00.000+05:30

DATA Description

We have 50 Numeric variables(Var1-Var50) and 40 Character Variables(Char1-Char40) in a SAS Data set. Out of 50 Numeric variables Var1-Var35 has missing numeric values(Period or Dot) and Char1-Char10 has missing Character values(Blank).

TASK

We have to replace All the Missing Numeric Values with 0(zero) but only in Var1-Var35 and All the Missing Character Values with "Missing" word. We should not effect the missing Values of Var36-Var50 and Char11-Char40.

Then we have to import the data in Excel.

I am expecting most efficient program as this task can be done in many ways.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XVI

2013-11-24T23:53:00.001+05:30

We have a SAS Data Set:

One
-----------------------------------------
Date_Info
-----------------------------------------
24Nov is Sunday
25Nov is Monday
26Nov is Tuesday
27Nov is Wednesday
28NOV IS THURSDAY
29nov is Friday
30NOV is SATURDAY

We need to create A SAS Data SET where only days should be in uppercase and rest should be in lowcase.

One
-------------------------------------------
Date_Info
-------------------------------------------
24nov is SUNDAY
25nov is MONDAY
26nov is TUESDAY
27nov is WEDNESDAY
28nov is THURSDAY
29nov is FRIDAY
30nov is SATURDAY

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XV

2013-10-02T19:31:00.000+05:30

SWAP THE VALUES OF VARIABLES A AND B:

WE HAVE SAS DATA SET ONE;

DATA ONE;
X=5;
Y=3;
RUN;

CREATE ANOTHER SAS DATA SET TWO BY READING SAS DATA SET ONE:

TWO
----------
X Y
3 5

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XIV

2013-09-26T23:00:00.000+05:30

WE HAVE TWO SAS DATA SETS:

Data one;
drop i j;
array a[60];
array b[60];
do j=1 to 1000;
do i=1 to 60;
a[i]=int(ranuni(i+j)*10);
b[i]=int(ranuni(j)*10);
end;
output;
end;
run;

Data two;
drop i j;
array a[60];
array b[60];
do j=1 to 1000;
do i=1 to 60;
a[i]=int(ranuni(i+j)*10);
b[i]=int(ranuni(j)*10);
end;
output;
end;
run;

WE HAVE TO CREATE A SAS DATA SET "THREE" THAT SHOULD HAVE DIFFERENCE OF THE COMMON VARIABLES OF DATA SETS "ONE" AND "TWO".

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XIII

2013-09-26T22:49:00.000+05:30

WE HAVE A SAS DATA SET:

ONE

EMP_ID NAME SALARY

-----------------------------------------------------

101 RAM 500

102 SITA 600

103 RADHA 700

104 RAVAN 800

105 ARJUN 900

106 BHIM 1000

WE NEED TO CREATE ANOTHER SAS DATA SET:

EMP_ID NAME SALARY SALARY/TOTAL
-----------------------------------------------------------------------------------------------
101 RAM 500 500/4700
102 SITA 600 600/4700
103 RADHA 700 700/4700
104 RAVAN 800 800/4700
105 ARJUN 900 900/4700
106 BHIM 1000 1000/4700

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XII

2013-07-02T20:49:00.001+05:30

We have a SAS data set TEST

data test;
input Cust_ID $ visit $ visdt date7.;
format visdt date7.;
cards;
001 uns 01jun13
001 visit1 02jun13
001 visit2 03jun13
001 uns 04jun13
001 uns 05jun13
001 visit3 06jun13
001 uns 07jun13
001 uns 08jun13
001 uns 01jun13
001 visit4 02jun13
001 visit5 03jun13
001 uns 04jun13
001 uns 05jun13
001 visit6 06jun13
001 uns 07jun13
001 uns 08jun13
;
run;

We want the output like:

Cust_ID Vist visdt Visitseq

001 uns 01JUN13 0.1
001 visit1 02JUN13 1.0
001 visit2 03JUN13 2.0
001 uns 04JUN13 2.1
001 uns 05JUN13 2.2
001 visit3 06JUN13 3.0
001 uns 07JUN13 3.1
001 uns 08JUN13 3.2
001 uns 01JUN13 3.3
001 visit4 02JUN13 4.0
001 visit5 03JUN13 5.0
001 uns 04JUN13 5.1
001 uns 05JUN13 5.2
001 visit6 06JUN13 6.0
001 uns 07JUN13 6.1
001 uns 08JUN13 6.2

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XI

2013-05-22T19:40:00.000+05:30

We have a SAS data set:

One
-----
X
5,6,1,10
2,3
4,7,8
9

We have to create SAS data set Two:

Two
-------

X a1 a2 a3 a4 a5 a6 a7 a8 a9 a10
------- ---------------------------------
5,6,1,10 1 0 0 0 5 6 0 0 0 10
2,3 0 2 3 0 0 0 0 0 0 0
4,7,8 0 0 0 4 0 0 7 8 0 0
9 0 0 0 0 0 0 0 0 9 0

Variables: X A1-A10

I will always appreciate most efficient SAS program which is taking the least resources.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS X

2013-04-28T21:37:00.003+05:30

We have a abc.doc file having values:

ram,21,500
sita,22,600
radha,23,700

How to read abc.doc file to make a SAS data set work.abc:

work.abc
---------------

Name Age Salary

Ram 21 500
Sita 22 600
Radha 23 700

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS IX

2013-04-18T21:14:00.001+05:30

We have a SAS data set one in which we have a variable Name:

ONE

Name

Ram Kumar m
Sita Singh
Radha Kumari Pathak
Arjun Rana

Write a SAS program to create another SAS data set TWO by reading SAS data set ONE:

TWO

Fname Mname Lname

Ram Kumar m
Sita Singh
Radha Kumari Pathak
Arjun Rana

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS VIII

2013-04-04T21:01:00.000+05:30

We are reading a raw file:

111 .
. .
. .
. .
. 222

We need to create a SAS dataset one like this:

ONE

Customer_Id Product_ID
111 222

Write most efficient program.(It should be in single datastep)

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS VII

2013-04-03T23:34:00.001+05:30

We have a SAS data set:

data one;
input visit $ pt;
datalines;
v1 101
v1 102
v2 101
v2 102
v3 103
v3 101
;
run;

Required Output:

Obs visit _101 _102 _103

1 v1 1 1 .
2 v2 1 1 .
3 v3 1 . 1

Program:

data two;
set one;
drop i;
array a[3] _101 _102 _103;
do i=1 to dim(a);
a[i]=1;
end;
run;
proc transpose data=two out=three (drop=_name_);
by visit;
id pt;
run;
data four;
set three;
by visit;
if first.visit;
run;
proc print;
run;

Can anyone help me in write more efficient program than this as we are solving it by using three different steps?

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS VI

2013-04-03T22:44:00.004+05:30

We are creating a user define format $country:

proc format;
value $country AU='australia'
US='United States'
Ind='India'
Sl='Sri lanka';
run;

A SAS Data set:

data one;
infile datalines;
input location $ population;
format location $country.;
datalines;
AU 1500
US 800
Ind 1000
pak 900
Sl 500
NP 300
;
run;
proc print;
run;

This is the output:

Obs location population

1 australia 1500
2 United States 800
3 India 1000
4 pak 900
5 Sri lanka 500
6 NP 300

In the above scenario we can see that for the observation pak and NP .$country format is not applicable.

Write a program to count the number of observations on which $country (user defined format) is not applied.

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS V

2013-03-12T20:39:00.001+05:30

We have a raw dataset:

Ball Price is : $700
Bat Price is: $800
Wicket Price is : $900

We have to make SAS data set as:

Product Cost
-------- --------
Bat 700
Ball 800
Wicket 900

Kindly write your answer in comment box:

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

If you want to Learn Base SAS and Advance SAS please mail me at creativityofnature@gmail.com.

SAS INTERVIEWS CONCEPTUAL QUESTIONS IV

2013-03-08T19:42:00.000+05:30

We have a SAS data Set One: Write a program to create SAS data set Two.

ONE TWO

Var1 Var2 Var1 Var2 Var3

a 3 a 3 0
b 5 b 5 0
c 10 g 6 0
d 10 e 7 1
e 7 f 7 1
f 7 h 9 0
g 6 c 10 1
h 9 d 10 1

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