SAS INTERVIEWS CONCEPTUAL QUESTIONS XVIII

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

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