topic Re: Categorizing SAS dataset with some missing observations and other errors. in SAS Programming

Categorizing SAS dataset with some missing observations and other errors.

Rebecca7 — Tue, 06 Jun 2023 14:35:35 GMT

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.

Re: Categorizing SAS dataset with some missing observations and other errors.

mkeintz — Tue, 06 Jun 2023 14:40:18 GMT

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.

Re: Categorizing SAS dataset with some missing observations and other errors.

Reeza — Tue, 06 Jun 2023 16:36:52 GMT

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'.