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
use sum function.
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
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.
you can add a 0 as one of the parameters in SUM to prevent returning a missing value -- SUM(0,cost,vat)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.