Answer / saurabh gupta

To add a number in macro use %EVAL macro

Example

%Let a= 2;
%Let b= 3;
%Let c= &a + &b ;
then it will give you value

c=2 + 3

but If you will use %eval it will give you sum

%Let c= %eval(&a + &b)
Now this will give you the correct answer

c=5

Answer / kavitha

USING %EVAL FUNCTION
%let i=%eval(&i+1);

Answer / nani

%macro add(a,b);
%if (%datatyp(&a)=NUMERIC and %datatyp(&b)=NUMERIC) %then %
do;
%put The result is %sysevalf(&a+&b).;
%end;
%else %do;
%put Error: Addition requires numbers.;
%end;
%mend add;

You can invoke the ADD macro as:

%add(5.1E2,225)

Explain bmdp procedure?

0 Answers  

---

how to generate means for every subject;

4 Answers   Mind Tree,

---

What versions of SAS have you used (on which platforms)?

0 Answers   Quintiles,

---

how do you test for missing values? : Sas programming

0 Answers  

---

· What are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,

---

what is SAS/Graph?

1 Answers   CitiGroup, NTPC,

---

What are the special input delimiters used in SAS?

0 Answers  

---

What is run-group processing?

0 Answers  

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers  

---

Which date function advances a date, time or datetime value by a given interval?

0 Answers  

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

---

What are the new features included in the new version of SAS Programming Language?

0 Answers  

---