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
- 10277 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 |
how to rearrange the data as our wish by using dataset block?
What does PROC print, and PROC contents do?
Why do we use QUIT commmand for proc datasets and proc sql ???
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE
how can you import .csv file in to sas? : Sas programming
what is data integration? : Sas-di
How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?
Explain data_null_?
How do you add a number to a macro variable?
What is the difference between INPUT and INFILE ?
how does sas handle missing values in functions? : Sas programming
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
Teradata 
