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...

how can you sort the dataset having millions of OBS(instead
of sort procedure?

Answer Posted / chandrakanth

proc sql;
create table dataset-name as select * from source-dataset-name group by sorting-variable-name;
quit;

GROUP BY option is for sorting the data.

Please let me know if you have more questions

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2060


Did you used proc test? when?

1981


What is by-group processing?

945


what are informats in sas? : Sas-administrator

1015


Describe 5 ways to do a “table lookup” in SAS?

1087


What are the table names in oracle database...?

2688


In proc transpose and data step with arrays which one you pick?

3040


How do dates work in sas?

1072


What is PROC in SAS?

1000


What is the difference between order and group variable in proc report?

1365


What versions of SAS have you used (on which platforms)?

1456


what is sas olap server? : Sas-di

1192


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2284


What is the maximum and minimum length of macro variable

1166


What is the role of sas grid administrator? : sas-grid-administration

1233