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

What are the data types in sas?

1062


What is the difference between one to one merge and match merge? Give an example.

1067


For clinical entire study how many tables will create approx?

1970


Why and when do you use proc sql?

1247


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1151


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3588


What are the parameters of scan function?

1175


what is sas business intelligence? : Sas-bi

1180


Which function is used to count the number of intervals between two sas dates?

1129


What are the prime responsibilities of data integration administrator? : Sas-di

1069


What is the difference between using drop = data set option in data statement and set statement?

1163


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1064


Describe the function and untility of the most difficult SAS macro that you have written.

2216


how does sas handle missing values in functions? : Sas programming

1213


what are informats in sas? : Sas-administrator

1093