SAS Programming Quiz | Latest SAS Quiz

What is the name of the input data set in the program below?
data work.us;
set orion.sales;
where Country=’US’;
run;

What is the name of the output data set in the program below?
data work.us;
set orion.sales;
where Country=’US’;
run;

In SAS, one can test single or joint hypothesis after successful completion of

The data set orion.sales contains nine variables. Given this DATA step, how many variables does the descriptor portion of work.comp contain?
data work.comp;
    set orion.sales;
    drop Gender Salary Birth_Date;
run;

The data set orion.sales contains nine variables. Given this DATA step, how many variables does the descriptor portion of work.comp contain?
data work.comp;
    set orion.sales;
    keep Employee_ID Gender Job_Title Salary;
run;

A KEEP statement in a DATA step omits all variables except Name, Color, and Price from the output data set. Are the omitted variables included in the PDV?

Which procedure can be used to view the permanent labels and formats stored in a data set?

Which of the following SAS functions returns a number from 1 to 12?

The data set orion.sales contains nine variables. Given this DATA step, how many variables does the descriptor portion of work.comp contain?
date work.comp;
    set orion.sales;
    drop Gender Salary Country;
    Compensation=sum(Salary,Bonus);
run;

Which DATA step ensures that all observations are assigned a non-missing value for Bonus?

Which of the following determines the length of a new variable at compile time?

We use a DO group in a DATA step when you want to execute multiple statements for a true IF-THEN expression

Which of the following statements is true about merging SAS data sets by using the DATA step?

Which of the following programs concatenates the data sets sales and products, in that order?

What is the syntax error in this DATA step?
data returns_qtr1;
    set returns_jan(rename=(ID=CustID) (Return=Item))
        returns_feb(rename=(Dt=Date))
    returns_mar;

If you run this DATA step, what observations does the dataset bonuses contain?
data bonuses;
        merge managers (in=M)
                   staff (in=S);
     by EmpID;
     if M=0 and S=1;
run;

Which of the following is a valid name for a character format?

Which of the following DATA steps correctly reads the permanent dataset salesinfo from the sporting library and creates a new data set named salesinfo2 in the same library?

What value will be assigned to Units?
data work.comp;
set work.sales;
Units=Total+Bonus/Quantity;
run;
PDV

In the program below, what is the value of benefit for the observation shown?
data work.total;
    set payroll.june;
    Benefit=sum(Ins,Health_Award);
run;