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?

Answers were Sorted based on User's Feedback



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

Answer / ram

using there TAG SORT. it is more efficient than Sort procedure.

Is This Answer Correct ?    4 Yes 4 No

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

Answer / venkatesh

by using proc format u can do sort in eficient wway

but u need to use cntlin for dataset

Is This Answer Correct ?    2 Yes 2 No

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

Answer / solasa

Using INDEX option save the cpu time and helps in fast
processing

Is This Answer Correct ?    1 Yes 2 No

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

Answer / 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

More SAS Interview Questions

What is a pdv and what are its functions?

0 Answers  


What do you feel about hardcoding?

1 Answers  


if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

4 Answers   HSBC,


What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

2 Answers   Accenture,


is QUALCOMM using SAS ?

1 Answers  


What are the joins,types of joins and thier functions?

7 Answers   SAS,


What are common programming errors committed in sas

0 Answers  


I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.

4 Answers  


what is the purpose of _error_? : Sas programming

0 Answers  


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT

0 Answers  


Describe how you would pass data to macro.

3 Answers  


when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 Answers  


Categories