Answer / Chandra Bhan Singh

The limitations for memory allocation for SAS variables depend on various factors such as available system memory, data type of the variable, and the specific SAS platform being used. However, a general limitation is that the maximum size for a single SAS variable is approximately 32GB. Additionally, the total amount of usable memory in a SAS session is limited by the operating system and hardware configuration.

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1 Answers  

---

what is the need of INDEX in datasets?

6 Answers   CitiGroup,

---

What do you feel about hardcoding?

3 Answers   Pfizer,

---

What is highest missing value for numeric?

1 Answers  

---

What is LAG function?How is it used? can any one explain

3 Answers   TRE, Verinon Technology Solutions,

---

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 class statement and by statement in proc means?

1 Answers  

---

HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

3 Answers   Accenture, Novartis,

---

What is difference between N and n????

2 Answers   Sciformix,

---

How to test the debugging in sas?

1 Answers  

---

What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,

---

What is Linear Regression?

1 Answers  

---