Answer / hny135

DATA JAGAN1.S1;
SET JAGAN1.S;
X=SCAN(BP,1,'/');
Y=SCAN(BP,2,'/');
A=INPUT(X,3.);
B=INPUT(Y,2.);
DROP BP X Y;
RUN;

Answer / aaaa

data jagan1.s;
infile cards dlm='/' dsd;
input b p;
cards;
100/90
120/89
112/87
run;

Answer / srinivasa rao

Using input function

data jaganl.1;
input bp$;
a=input(bp);
cards;
100/90
120/89
112/87
;
run;

how do you want missing values handled? : Sas programming

0 Answers  

---

Identify statements whose placement in the DATA step is critical?

11 Answers  

---

what are all the ways to define macro variable??

2 Answers   GSK GlaxoSmithKline,

---

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  

---

What areas of SAS are you most interested in?

0 Answers   Quintiles,

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

0 Answers  

---

What is a macro routine?

0 Answers  

---

What is by-group processing?

0 Answers  

---

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

0 Answers  

---

What is the order of evaluation of the comparison && logical && relational operators:?

2 Answers   CitiGroup,

---

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

0 Answers  

---

Explain the purpose of substr functions in sas programming.

0 Answers  

---