Showing posts with label Proc Sort. Show all posts
Showing posts with label Proc Sort. Show all posts

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