Answer Posted / hari

This is mainly useful for the fast retrival of data (For ex
we have 559 in 1 lac obs then by index we can get the data
with out reading all the observations

Index are 2 type:

1.simple
2.Composite


ex-for simple


proc datasets lib=college;
modify time;
index create class;
run;


ex-for composite:


proc datasets library=college;
modify time;
index create names(=(name school);
run;

what is data integration? : Sas-di

1127

---

Explain the use of proc gplot? : sas-grid-administration

998

---

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2031

---

is data integration and etl programming is same? : Sas-di

1088

---

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.

2207

---

what is factor analysis? : Sas-administrator

1109

---

What are types of transport files?

8010

---

What is SAS?

1062

---

Are you sensitive to code walk-throughs peer review or QC review?

3148

---

Name some categories in sas 9? : sas-grid-administration

981

---

explain the use of % includes a statement in sas? : Sas-administrator

1009

---

What are the limitations for memory allocation for SAS variables

1502

---

what is study design in while working with SAS? what are screening variables in SAS?

2247

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1081

---

what is the effect of the options statement errors=1? : Sas programming

1070

---