Question

Basic SAS coding

3. Use the SAS dataset insure to (a) create a new SAS dataset insure10 that i. reads in only Name, Company, PctInsured, and BalanceDue 11. outputs records where Petinsured < 100 ii. only retains the variables Name, Company, and BalanceDue (b) based on the results of the last part, create a listing report which i. is sorted by BalanceDue (largest first) ii. displays Name, Company, BalanceDue iii. uses a dollar format for BalanceDue

Answer 1

Only first one solved.
data insure;
set insure10(keep= Name Company PetInsured BalanceDue);
run;
DATA insure10;
PROC PRINT DATA = insure10;
WHERE PetInsured <100
var Name Company BalanceDue;
run;