Where do the database management systems store data and how do u import them.

2 Answers   L&T,

---

tell me about use of arrays in sas

1 Answers   CoreEL,

---

explain the main difference between the nodup and nodupkey options? : Sas-administrator

0 Answers  

---

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

0 Answers  

---

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

0 Answers  

---

Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  

---

what is operational data and operational system? : Sas-di

0 Answers  

---

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  

---

What is PDV?

0 Answers  

---

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

0 Answers  

---

for whom is sas data integration studio designed? : Sas-di

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  

---