SASInstitute SAS Base Programming for SAS 9 (A00-211日本語版) - A00-211日本語 Exam Practice Test

proc means data = sasuser.houses std mean max;
var sqfeet;
run;

data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;

data allobs;
set sasdata.origin (firstobs = 75 obs = 499);
run;

PRICES prodid price K12S5.10producttype NETWORKsales 15returns
B132S 2.34HARDWARE30010 R18KY21.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455 DGTY23 4.55HARDWARE672

data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;

proc sort data = work.test out = work.testsorted;
by name;
run;

data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department;
run;

----I---- 10---I----20---I----30
$1,234

data test;
infile 'amount';
input@1 salary 6.;
if_error_then description = 'Problems';
else description = 'No Problems';
run;