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 […]
SAS Certified Adv Programmer 130 Questions (27)
The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X. Which one of the following SAS programs uses the index to select observations from the data set ONE? A. data two; set three; set one key = X; run; […]
SAS Certified Adv Programmer 130 Questions (26)
Which one of the following automatic SAS macro variables contains the return code from a previously executed step? A. &RC B. &ERR C. &SYSRC D. &SYSERR
SAS Certified Adv Programmer 130 Questions (25)
Given the following SAS data sets ONE and TWO: ONE NUM CHAR1 1 A 2 B 4 D TWO NUM CHAR2 2 X 3 Y 5 V The following SAS program is submitted creating the output table THREE: data three; set one two; run; THREE NUM CHAR1 CHAR2 1 A 2 B 4 D 2 […]
SAS Certified Adv Programmer 130 Questions (24)
Given the following SAS data set ONE: ONE COUNTRY CITY VISIT USA BOSTON 10 UK LONDON 5 USA DALLAS 10 UK MARLOW 10 USA BOSTON 20 UK LONDON 15 USA DALLAS 10 The following SAS program is submitted: proc sql; select country, city, sum(visit) as TOTAL from one group by country, city order by country, […]