Monday, March 25, 2013

Base SAS Example Question 4.1

Leave your answer in the comments below...good luck!

-SAS Cert

_________________________

Assume the variable 'Unit_Cost_Price' (numeric) contains both missing and non missing values. What would the below output contain?

proc sort data=ecsql1.price_list;
 by Unit_Cost_Price;
run;

a) A new dataset work.price_list is created with Unit_Cost_Price sorted in ascending order with missing values at the bottom of the dataset
b) The dataset ecsql1.price_list is sorted with Unit_Cost_Price sorted in descending order with missing values at the bottom of the dataset
c) A new dataset work.price_list is created with Unit_Cost_Price sorted in descending order with missing values at the top of the dataset
d) The dataset ecsql1.price_list is sorted with Unit_Cost_Price sorted in ascending order with missing values at the top of the dataset

7 comments:

  1. D. missing values are considered as lowest values (ascending order; they will be top of the data set)

    ReplyDelete
  2. what if we had both a zero and missing value present, what would be lowest then?

    ReplyDelete
  3. missing value always smaller than 0, the answer is D.

    ReplyDelete