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.

how to read the variables in sas? : Sas-administrator

0 Answers  

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 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  

---

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,

---

What is difference between sas rename and lable?

4 Answers  

---

Of all your work, where have you been the most successful?

0 Answers   Oracle, Six Sigma,

---

What is the purpose of _error_?

1 Answers   Quintiles,

---

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,

---

For what purposes have you used sas macros? : sas-macro

0 Answers  

---

Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara

55 Answers  

---

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,

---

Mention common programming errors committed in sas ?

0 Answers  

---