Tag: programming languages

Quizzes (351) Questions (7021)

Questions Related to programming languages

Multiple choice technology programming languages

While using CLASS and BY Statements in PROC MEANS one should keep in mind :

  1. Use the CLASS Statement when number of observation >10000

  2. Use the By Statement when number of observation <1000

  3. Using the BY Statement requires that the input data set be sorted by the values of the classification variables

  4. Using the CLASS Statement requires that the input data set be sorted by the values of the classification variables
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology programming languages

There are 45 records having the variable REGION value as missing.How to display the SUM and MEAN of TOTREV for these records?

  1. PROC MEANS DATA= ORGANIZATION SUM MEAN ; CLASS REGION; VAR TOTREV / MISSING; run;

  2. PROC MEANS DATA= ORGANIZATION SUM MEAN MAXDEC=0 NMISS; CLASS REGION; VAR TOTREV; run;

  3. PROC MEANS DATA= ORGANIZATION SUM MEAN MAXDEC=0 if not MISSING; CLASS REGION; VAR TOTREV; run;

  4. PROC MEANS DATA= ORGANIZATION SUM MEAN MAXDEC=0 MISSING; CLASS REGION; VAR TOTREV; run;
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation
Multiple choice technology programming languages

How to obtain only the MEAN and SUM of TOTREV classified by REGION in the ORGANIZATION data set.

  1. PROC MEANS DATA= ORGANIZATION ; CLASS REGION; VAR TOTREV ; run;

  2. PROC MEANS DATA= ORGANIZATION SUM MEAN MAXDEC=0 ; CLASS REGION; VAR TOTREV ; run;

  3. PROC MEANS DATA= ORGANIZATION SUM MEAN MAXDEC=0 ; BY REGION; CLASS TOTREV ; run;

  4. PROC MEANS DATA= ORGANIZATION SUM MEAN MAXDEC=0 ; CLASS North_Region; VAR TOTREV ; run;
Reveal answer Fill a bubble to check yourself
B Correct answer
Full explanation
Multiple choice technology programming languages

What does the following code do? PROC MEANS DATA= ORGANIZATION(WHERE=(REGION IN('WESTERN','SOUTHERN') and SUBSTR(RATE_SCHEDULE,1,2) = 'E1')) MAXDEC = 0 MEAN SUM NONOBS; VAR TOTREV; CLASS REGION RATE_SCHEDULE; run;

  1. Calculate the mean total revenue classified by REGION and RATE_SCHEDULE, but only for the WESTERN and SOUTHERN REGIONS, and only for those two regions whose values of RATE_SCHEDULE start with the string “E1.”

  2. Displays the number of observations(records), mean and total revenue classified by REGION and RATE_SCHEDULE, for the WESTERN and SOUTHERN REGIONS, and only for those two regions whose values of RATE_SCHEDULE start with the string “E1.”

  3. Calculate the mean total revenue classified by REGION and RATE_SCHEDULE, for all the regions except the WESTERN and SOUTHERN REGIONS, and only for those two regions whose values of RATE_SCHEDULE start with the string “E1.”

  4. Displays the Rate Schedule of the WESTERN and SOUTHERN REGIONS where variable TOTREV is an integer.
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology programming languages

data test; input region $ totrev tothrs totkwh; datalines; north 3 45 55 north 345 64 64 south 235 34 345 east 23 346 576 south 23 5 4 ; run; PROC MEANS DATA=TEST1 NOPRINT; VAR TOTREV TOTKWH TOTHRS; OUTPUT OUT=TEST2 sum(TOTREV TOTKWH) = mean(TOTREV) = median(TOTHRS) = / AUTONAME; run; What are the column names of the dataset TEST2?

  1. TYPE , FREQ , totrev_Sum , totkwh_Sum , totrev_Mean , tothrs_Median

  2. TYPE , FREQ , total revenue sum , total kwh Sum , total revenue Mean , total hrs Median

  3. TYPE , FREQ , totrev , totkwh , tothrs

  4. totrev_Sum , totkwh_Sum , totrev_Mean , tothrs_Median
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology programming languages

Which of the following code can obtain a 95 percent confidence interval around the mean total KwH consumption and around the mean billed revenue, along with the mean and median from the dataset ORGANIZATION.

  1. PROC MEANS DATA= ORGANIZATION MEDIAN MEAN CLM MAXDEC=0; Label TOTREV = 'Total Billed Revenue' TOTKWH = 'Total KwH Consumption'; VAR TOTREV TOTKWH; run;

  2. PROC MEANS DATA= ORGANIZATION MEDIAN MEAN UCLM ; Label TOTREV = 'Total Billed Revenue' TOTKWH = 'Total KwH Consumption'; VAR TOTREV TOTKWH; run;

  3. PROC MEANS DATA= ORGANIZATION MEDIAN MEAN LCLM Label TOTREV = 'Total Billed Revenue' TOTKWH = 'Total KwH Consumption'; VAR TOTREV TOTKWH; run;

  4. PROC MEANS DATA= ORGANIZATION MEDIAN SUM CLM MAXDEC=0; Label TOTREV = 'Total Billed Revenue' TOTKWH = 'Total KwH Consumption'; VAR TOTREV TOTKWH; run;
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation