I have imported a file from excel, it works. However I'm trying to modify it for analysis. This is the error I get and here is a copy of what I have coded. WHAT am I doing wrong???
data sasuser.pedifalls;
set sasuser.pedifalls;
if graf6='<=1' then graf6 ='0';
else if graf6='>=2' then graf6='1';
proc freq; table graf6;
run;
NOTE: Invalid numeric data, '<=1' , at line 12500 column 10.
NOTE: Invalid numeric data, '>=2' , at line 12501 column 15.
ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be printed
Also, if I change the 'set' or take away the quotes from the new values, it gives an error of missing infile statement and that no data file exists. I simply don't know how to use the if statement. I appreciate any help, thanks.
data sasuser.pedifalls;
set sasuser.pedifalls;
if graf6='<=1' then graf6 ='0';
else if graf6='>=2' then graf6='1';
proc freq; table graf6;
run;
NOTE: Invalid numeric data, '<=1' , at line 12500 column 10.
NOTE: Invalid numeric data, '>=2' , at line 12501 column 15.
ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be printed
Also, if I change the 'set' or take away the quotes from the new values, it gives an error of missing infile statement and that no data file exists. I simply don't know how to use the if statement. I appreciate any help, thanks.