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

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers  


Can we create datasets by proc step ? (Proc contents, Means)?

2 Answers  


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

0 Answers  


what is the purpose of _error_? : Sas programming

0 Answers  


Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

0 Answers   Axis Bank,


Intern stastical programmer written test

0 Answers  


How do you convert basic cube to transaction cube and transaction cube to basic cube?

0 Answers  


how can you code the confidence intervals?

6 Answers   Cytel, IIT, Ranbaxy,


What does the RUN statement do?

0 Answers   Quintiles,


In which format does Date stores in sas..? What is the use of DATE in SAS.?

3 Answers   TCS,


how can get the first and last observations in a dataset using Proc SQl?

4 Answers   Satyam,


Categories