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
Answer is D
ReplyDeleteD. missing values are considered as lowest values (ascending order; they will be top of the data set)
ReplyDeleteD
ReplyDeletewhat if we had both a zero and missing value present, what would be lowest then?
ReplyDeletemissing first then 0
DeleteD
ReplyDeletemissing value always smaller than 0, the answer is D.
ReplyDelete