topic Re: If/Then statement problems in SAS Procedures

If/Then statement problems

hudasaeb — Wed, 24 Jan 2018 16:03:20 GMT

Issue with If then subsetting statement with data with both numerical and character values. No error is showing but note is NOTE: Invalid numeric data, '30-35 months' , at line 75 column 13. The output table is showing no values at all.

data nis_age;
set nis_use;
if AGEGRP = "30-35 months" then output;
run;

Help please.

Re: If/Then statement problems

Astounding — Wed, 24 Jan 2018 16:05:42 GMT

When you examine the variable AGEGRP, you will find that it is a numeric variable. There is no way it could possibly hold the characters "30-35 months". You may need to fix the data first.

Re: If/Then statement problems

ballardw — Wed, 24 Jan 2018 16:12:15 GMT

@hudasaeb wrote:

Issue with If then subsetting statement with data with both numerical and character values. No error is showing but note is NOTE: Invalid numeric data, '30-35 months' , at line 75 column 13. The output table is showing no values at all.

data nis_age;
set nis_use;
if AGEGRP = "30-35 months" then output;
run;

Help please.

As @Astounding says, AGEGRP is numeric. If the values of Agegrp are integers you could use in with the range operator:

if AGEGRP in (30:35) then output;

or alternatively

if 30 le agegrp le 35 then output;

le is "less than or equal" to include the end values.

Re: If/Then statement problems

art297 — Wed, 24 Jan 2018 16:21:08 GMT

My guess is that your dataset has formatted values. If that is the case, then you could use the vvalue function. i.e.,

data nis_age;
  set nis_use;
  if vvalue(AGE_GROUP) eq '30-35 months';
run;

Art, CEO, AnalystFinder.com