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)
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.