SAS Certified Professional Prep Guide

Scenario 1

Code Solution

Note: On the live exam, you will be evaluated both on the results of your code and the code itself. Your code should be similar to the following example code, but does not need to match exactly:

proc fcmp outlib=work.function.add;   /*1*/
   function adding(val);              /*2*/
      final=38+val;
      return(final);                  /*3*/
   endsub;                            /*4*/
run;

options cmplib=work.function;         /*5*/

data work.studentcost;                /*6*/
   set certadv.all;
   Final_Cost=adding(fee);            /*7*/
run;

proc print data=work.studentcost;     /*8*/
   var Student_Name Course_Code Fee Final_Cost;
run;

1	The FCMP procedure enables you to create custom functions using DATA step syntax. The OUTLIB= option specifies Work.Function as the table in which the Add package is stored. The Add package ...