Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

You need to perform an analysis on a massive dataset by
groups, but are unable to sort the data due to memory
constraint. How would you accomplish the task?

Answer Posted / satheesh

you can use index statement,

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

the above code is equivalent to sort.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the ways in which macro variables can be created in sas programming?

1096


Explain append procedure?

1075


How do you specify the number of iterations and specific condition within a single do loop?

1096


what is null hypothesis? why do you consider that?

2890


What is SAS?

1047


What are the differences between sum function and using “+” operator?

1099


How to specify variables to be processed by the freq procedure?

1067


What are the 3 components in sas programming?

1190


Give some examples where proc report’s defaults are same as proc print’s defaults?

1102


List out some key concept of SAS

1116


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4507


How do dates work in sas?

1128


What is data _null_?

1133


Why and when do you use proc sql?

1239


what are the benefits of data integration? : Sas-di

1097