what are _numeric_ and _character_ and what do they do? : Sas programming

0 Answers  

---

Are you familiar with special input delimiters? How are they used?

4 Answers   Accenture,

---

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  

---

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers  

---

What is difference between (a-z) and (a--z)

8 Answers   Accenture,

---

What is the difference between where and if statement?

0 Answers  

---

how many display types available in sas bi dashboard? : Sas-bi

0 Answers  

---

What is the difference between class statement and by statement in proc means?

0 Answers  

---

Describe 5 ways to do a “table lookup” in SAS?

0 Answers  

---

What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

2 Answers   ABC, ASD Lab, CitiGroup,

---

What sas features do you use to check errors and data validation?

0 Answers  

---

List out some key concept of SAS

0 Answers  

---