topic Re: SAS ERROR in New SAS User

SAS ERROR

Moses_Lutaaya — Sat, 07 Nov 2020 19:04:24 GMT

I am new to SAS and learning with videos.

I written this code but SAS returns a mistake. what is the problem here.

CODE

proc print data = sashelp.heart;
set sashelp.heart;
where chol Status = "High";
run;

Log message

ERROR: Syntax error while parsing WHERE clause.

ERROR 180-322: Statement is not valid or it is used out of proper order.

ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE,

LT, NE, OR, ^=, |, ||, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

76 run;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: SAS ERROR

Shmuel — Sat, 07 Nov 2020 19:40:40 GMT

You are mixing two tools:

1) Data Step:

data <output_dat_set>;
   set <input_data_set>;
         /* any more sas statements and functions */
run;

2) Executing a procedure like PROC PRINT:

proc print data=<input_data_set> <more options>;
   var <list order of variables to print >;
   /* more statement for proc print>;
run;

3) Look for sas documentation of each procedure or statement keyword or function.

Good Luck.

Re: SAS ERROR

Kurt_Bremser — Sat, 07 Nov 2020 19:56:52 GMT

Here's the most important link for your future SAS life:

SAS 9.4 Programming Documentation

There you can find (among a galaxy of other things) all procedures, and the statements that are valid in each.

Some DATA step statements (like WHERE) can also be used in PROC steps, but SET is not among them. SET is data step only. And not necessary here, as the input dataset for PROC PRINT is already defined by the DATA= option.

Re: SAS ERROR

Cynthia_sas — Sun, 08 Nov 2020 01:29:49 GMT

Hi:

In addition to the other excellent suggestions, my suggestion is that you run a PROC CONTENTS to make sure you are spelling the variable names correctly when you use them. For example:

Notice that variables like Weight_Status and Chol_Status have underscores in the variable name (not spaces).

Cynthia