topic Invalid numeric data in SAS Procedures

Invalid numeric data

jovane0700 — Fri, 05 Oct 2018 03:04:23 GMT

Im trying to create a new data set from an old one only using specific variables.

data confsemi;
set nba1996_krcadin2_new;
if tmID NE 'SEA' or 'HOU' then delete;
run;

However when i get my results only SEA shows up. In the log it claims that 'HOU' is a numeric value and therefore ignores it. Any suggestions??

Re: Invalid numeric data

Reeza — Fri, 05 Oct 2018 03:10:11 GMT

This is not correct syntax:

 if tmID NE 'SEA' or 'HOU' then delete;

SAS see's the following instead:

 if (tmID NE 'SEA') or 'HOU' then delete;

Use IN

 if tmID not in ('SEA', 'HOU') then delete;

@jovane0700 wrote:

Im trying to create a new data set from an old one only using specific variables.

data confsemi;
set nba1996_krcadin2_new;
if tmID NE 'SEA' or 'HOU' then delete;
run;

However when i get my results only SEA shows up. In the log it claims that 'HOU' is a numeric value and therefore ignores it. Any suggestions??

Re: Invalid numeric data

jovane0700 — Fri, 05 Oct 2018 03:13:25 GMT

Thank you, I'm very new to this :)) !!!!