Archive for December, 2009
SAS Certified Adv Programmer 130 Questions (32)
Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS M 28 200 . M 25 100 10 F 18 100 50 F 25 200 10 The following SAS program is submitted: proc sql; create table two as select category, salary + bonus as EARNINGS from one; quit; Which one of the following […]
SAS Certified Adv Programmer 130 Questions (31)
Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS System options writes that text to the log? A. MPRINT B. MLOGIC C. MSOURCE D. SOURCE2
SAS Certified Adv Programmer 130 Questions (30)
Given the following SAS data set SASUSER.HIGHWAY: SASUSER.HIGHWAY STEERING SEATBELT SPEED STATUS COUNT absent no 0-29 serious 31 absent no 0-29 not 1419 absent no 30-49 serious 191 absent no 30-49 not 2004 absent no 50+ serious 216 The following SAS program is submitted: %macro highway; proc sql noprint; select count(distinct status) into: numgrp from […]
SAS Certified Adv Programmer 130 Questions (29)
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set? A. MODIFY B. FORMAT C. CONTENTS D. DATASETS
SAS Certified Adv Programmer 130 Questions (28)
Given the following SAS data set ONE: ONE REP AREA COST SMITH NORTH 100 SMITH SOUTH 200 JONES EAST 100 SMITH NORTH 300 JONES WEST 100 JONES NORTH 200 JONES NORTH 400 SMITH NORTH 400 JONES WEST 100 JONES WEST 300 The following SAS program is submitted: proc sql; select rep, area, count(*) as TOTAL […]