Categorizing SAS dataset with some missing observations and other errors.

[Rebecca7]

Good day All,

I am new on SAS  community, I am preparing for base certification exam and I came across this code that I am expected to fix and run. 

I used the example someone posted but each time i run my code it writes notes in the log but after sorting the data, I am not able to do a proc print, to enable me visualize the output so i can answer the questions that follow, rather when I run the code it loops forever and does not give me any result. This is the code:

 data work.lowchol work.highchol;

 set sashelp.heart;

     if cholesterol lt 200 output work.lowchol;

     if cholesterol ge 200 output work.highchol;

     if cholesterol is missing output work.misschol;

run;

Thank You.

[mkeintz]

Run the code you posted, and examine the sas log.  That should help you understand what is needed for a "fix".

Your approach of running a PROC SORT and PROC PRINT assumes that the preceding data step produced the data you wish to view.

[Reeza]

When you run the code posted you should get a bunch of errors. Here's the log I receive. 

You then need to fix the errors in the order they appear.

69          data work.lowchol work.highchol;
 70         
 71          set sashelp.heart;
 72         
 73              if cholesterol lt 200 output work.lowchol;
                                       ______
                                       79
 ERROR 79-322: Expecting a ;.
 
 74         
 75              if cholesterol ge 200 output work.highchol;
                                       ______
                                       79
 ERROR 79-322: Expecting a ;.
 
 76         
 77              if cholesterol is missing output work.misschol;
                                __
                                388
                                76
 ERROR 388-185: Expecting an arithmetic operator.
 
 ERROR 76-322: Syntax error, statement will be ignored.
 
 78         
 79         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 WARNING: The data set WORK.LOWCHOL may be incomplete.  When this step was stopped there were 0 observations and 17 variables.
 WARNING: The data set WORK.HIGHCHOL may be incomplete.  When this step was stopped there were 0 observations and 17 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       user cpu time       0.00 seconds
       system cpu time     0.01 seconds
       memory              1622.84k
       OS Memory           20652.00k
       Timestamp           06/06/2023 04:34:21 PM
       Step Count                        24  Switch Count  4
       Page Faults                       0
       Page Reclaims                     389
       Page Swaps                        0
       Voluntary Context Switches        18
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           528
       
 

There are at least 5 mistakes in the code above, three are the 'same'.