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)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.