topic avoiding missing values in SAS Programming

avoiding missing values

rawindar — Fri, 27 Apr 2012 04:56:32 GMT

Hi all

i have a one dataset with two variables cost,vat as follows

data x;

input cost vat;

datalines;

1000 100

5000 500

10000 .

. .

;

Now i want to add these two variables and addition of these two variables in new variable ADDITION and i dont want missing values in these variable.

Thanks &Regards

rawindarreddy

Re: avoiding missing values

manojinpec — Fri, 27 Apr 2012 05:00:50 GMT

use sum function.

Re: avoiding missing values

shivas — Fri, 27 Apr 2012 06:13:46 GMT

Hi,

Try this..Hope it helps

data x;

input cost vat;

x=sum(cost,vat);

if x ne .;

datalines;

1000 100

5000 500

10000 .

. .

;

run;

Thanks,

Shiva

Re: avoiding missing values

ballardw — Fri, 27 Apr 2012 16:37:08 GMT

If all arguments to SUM function are missing it will still return missing.

The only option as I can see it, depending on why the missing are objectionable in the data, are to remove the record from the output or assign a specific value such as 0 if both variables are missing.

Re: avoiding missing values

Jay_TxOAG — Fri, 27 Apr 2012 16:57:07 GMT

you can add a 0 as one of the parameters in SUM to prevent returning a missing value -- SUM(0,cost,vat)