topic SAS does not give results for overlapping range. in New SAS User

SAS does not give results for overlapping range.

Pratima67301 — Thu, 29 Aug 2024 16:22:24 GMT

data new dataset;
set Weight ;
else if Weight < 1500 then BirthWeight = "2.2 Very low <1500";
else if Weight < 2500 then BirthWeight = "2.1 Low birth <2500";
else if Weight >= 2500 and BWGT <= 4000 then BirthWeight = "2.3 2500-4000";

This is my code, but I have a small problem with the output.

I want to find values 2.2 <1,500 and 2.1 <2,500. However, it only provides outputs for values <1,500 and for values that are (<2,500 and >1,500). SAS does not give me results when the values overlap. Any help would be greatly appreciated.

Re: SAS does not give results for overlapping range.

Astounding — Thu, 29 Aug 2024 23:35:11 GMT

It's difficult to comment, when your program has no chance of doing anything at all. Here's a suggestion that may help. On each observation, there can be only one value for BirthWeight. So decide what you want the final data set to look like before you start programming.

Re: SAS does not give results for overlapping range.

mkeintz — Fri, 30 Aug 2024 00:20:37 GMT

Among other issues, since the code you show has an ELSE IF that is not preceded by an IF, it can not run.

In turn that mean the new dataset you intend to output will not be created, or will not be overwritten if it already exists. So if the output dataset already exists and already exhibited the problems you describe, they will still be there in that unmodified dataset.

Show us the log of code that actually outputs data, and then we can help diagnose the problem, if it persists.