Interested to Buy Any Domain ? << Click Here >> for more details...
How to write duplicate records into a separate dataset using
sort?
- 4 Answers
- 12880 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vimal
PROC SORT DATA=data_a DUPOUT=dup_data
NODUPKEY
OUT=nodup_data;
BY x;
RUN;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / yam
First sort the data set by the key variable and then
data dup;
set indata1;
if not(first.keyvar) then output dup;
run;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / charan araveti
if u dont want to use DUPOUT,hear is some code:
data dup(drpo temp_id);
set ds1;
retain temp_id;
if temp_id ne id then
output;
temp_id=id;
| Is This Answer Correct ? | 1 Yes | 3 No |
how can you create zero observation dataset? : Sas programming
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
I need level 2 to 5 sas using companies in india
Explain what is data step?
is data integration and etl programming is same? : Sas-di
What are the functions done while Compilation...?
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is Linear Regression?
Differentiate between ceil and floor functions.
How do you define proc in sas? : sas-grid-administration
What is Transaction...? And what are Comment, Roll back n Save point..?
Teradata 
