Answer / satheesh

you can use index statement,

proc sql;
create index indexname on Tablename(Variable or Columnname);
quit;

the above code is equivalent to sort.

Answer / rock

Before grouping the dataset first compress the dataset
using compress=yes option whicle creation of dataset like

data x(compress=yes reuse=yes);
set y;
run;
proc sql;
select --- do the grouping now

Sure that sorting will take less time. Try this once
Main trick here is we are compressing the unused space in
dataset so the size of the dataset will get reduce.

What is the pound sign used for the DATA _NULL_?

14 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  

---

How to write duplicate records into a separate dataset using sort?

4 Answers   HSBC,

---

Describe the ways in which you can create a macro variable?

0 Answers  

---

How to select the observations randomly from a SAS dataset

7 Answers   NTT Data,

---

What is the role of unrestrictive users? : sas-grid-administration

0 Answers  

---

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

0 Answers  

---

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables?

3 Answers  

---

explain the key concept of sas? : Sas-administrator

0 Answers  

---

what is business intelligence? : Sas-bi

0 Answers  

---

For what purpose would you use the RETAIN statement?

0 Answers   Quintiles,

---

how to intersect the tables by using PROC MIXED?

1 Answers   CitiGroup,

---