SAS INTERVIEWS CONCEPTUAL QUESTIONS XXVI

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

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

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

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

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

SAS INTERVIEWS CONCEPTUAL QUESTIONS XXI

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

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

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