Tag: databases

Questions Related to databases

What does the OUT= represents in PROC SORT ?
technology databases

  1. Output dataset

  2. Inputdataset

  3. Both

  4. Output window

Show answer
Correct Option: A

BY statement specifies one or more variables whose values are used to order the data in PROC SORT?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following is the syntax for sorting the dataset in descending order
technology databases

  1. proc sort data = Wegiht_Activa; by descending weight; run;

  2. proc sort data = Wegiht_Activa;descending by weight; run;

  3. proc sort data=Weight_Activa;weight by descending ;run

  4. B&C

Show answer
Correct Option: A

By default following points for report generated by the PRINT procedure:

technology databases

  1. True

  2. False

Show answer
Correct Option: A

What is the statement that will be used to select required columns in the PROC PRINT?
technology databases

  1. Statement VAR

  2. Statement By

  3. option OBS

  4. none if the above

Show answer
Correct Option: A

SUM statement usage in PROC PRINT step is Generating column totals for numeric variables to be summed ?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the follwing option will be used to split the long names for the columns in proc print ?
technology databases

  1. label

  2. Split

  3. break

  4. unstring

Show answer
Correct Option: B

Which of the follwing variables will be produced by PROC MEANS procedure?
technology databases

  1. n-count,mean,standerd deviation,Min and MAX values

  2. n-count,frequency,mean,standerd deviation,Min and MAX values

  3. frequency,cumulative frequency ,mean,standerd deviation,Min and MAX values

  4. both b&c

Show answer
Correct Option: A

Which of the following oprions will be used to limit the decimal places in proc Means ?

technology databases

  1. MAXDEC

  2. DEC

  3. MINDEC

  4. LIMITDEC

Show answer
Correct Option: A

Which one of the follwoing statment will be used to specify the variables that PROC MEANS analyzes?
technology databases

  1. VAR

  2. BY

  3. COL

  4. None of the above

Show answer
Correct Option: A