How would you identify a macro variable? : sas-macro

0 Answers  

---

: and & modifiers.

0 Answers   Oracle,

---

what are input dataset and output dataset options?

6 Answers   HCL,

---

What is a put statement?

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  

---

What is the difference between an informat and a format. Name three informats or formats.

6 Answers  

---

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers  

---

What are common programming errors committed in sas

0 Answers  

---

In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  

---

How sas treats the dsd delimiters?

0 Answers  

---

How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO

2 Answers   TCS,

---

How can sas program be validated?

0 Answers  

---