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.

Describe what are the different levels of administrative users in sas? : sas-grid-administration

0 Answers  

---

What is the difference between %local and %global?

1 Answers  

---

Explain the use of proc print and proc contents?

0 Answers  

---

What report output formats can you generate using SAS?

3 Answers   Accenture,

---

What is the registered Key word is sas????

2 Answers   TCS,

---

i have a data set with 20 observations i want label from 8 to 15 observations ? how you create this one.

6 Answers   CTS,

---

Difference Between Scan and Substr

2 Answers  

---

Compare sas with other data analytics tools.

0 Answers  

---

what is in stream data in SAS?

1 Answers  

---

how many types of prompts are there? : Sas-bi

0 Answers  

---

how to generate the test data in sas without input data? : Sas-administrator

0 Answers  

---

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,

---