SAS Certified Adv Programmer 130 Questions (33)
Which one of the following SAS SORT procedure options eliminates identical consecutive observations? A. NODUP B. UNIQUE C. DISTINCT D. NODUPKEY
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