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
- 10334 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 |
Name the option to produce a frequency line items rather that a table.
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.
how do we get duplicate observations in a separate dataset?
What are the difficulties u faced while doing vital signs table or dataset?
how to handle in stream data containing semicolon in it?
my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?
what is TAB delimiter? explain about it? what will you do to get TAB delimiter?
what are the component of range? : Sas-bi
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
Teradata 
