Interested to Buy Any Domain ? << Click Here >> for more details...
how can you sort the dataset having millions of OBS(instead
of sort procedure?
- 4 Answers
- 10523 Views
- EXL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram
using there TAG SORT. it is more efficient than Sort procedure.
| Is This Answer Correct ? | 4 Yes | 4 No |
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 |
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 |
What are the parameters of scan function?
Mention some common errors that are usually committed in sas programming.
what is sas olap server? : Sas-di
What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.
2 Answers ABC, ASD Lab, CitiGroup,
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
name some data transformation used in sas di? : Sas-di
how do you validate sas program?
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
What is the maximum and minimum length of macro variable
data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.
What is the use of function Proc summary?
Teradata 
