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