How to create a new dataset only duplicate observations in
proc sort procedure?
- 1 Answers
- 2117 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / Rahul Kumar Mishra
To create a new dataset with duplicate observations using the `PROC SORT` procedure in SAS, you can use the `OBS=COUNT(*)` option in the PROC SORT step. Here's an example:nn```sqlnDATA new_dataset; nSET old_dataset; nBY variable1 variable2...; nRUN; nPROC SORT DATA = new_dataset OUT = duplicates; nBY variable1 variable2...; nOBS = COUNT(*); nRUN; nDATA final_dataset; nMERGE new_dataset (RENAME=(variable1=new_var1 new_variable2=new_var2 ...)) n duplicates (RENAME=(variable1=old_var1 old_variable2=old_var2 ...)); nBY variable1 variable2...; nRUN; n```nThis code creates a new dataset named `new_dataset` with duplicate observations and then merges it with the original dataset containing unique observations to produce the final dataset.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mainly Related to Oracle, DBMS , Oracle Stored Procedures, Functions, Oracle 9i Architecture, Redo logs..., Views,
Explain the types of operations? Draw the figure for shift and rotate operations?
Please forward important interview and basic questions in VB6 on my email id: usneha_16@yahoo.co.in
I want sample papers for NIC Examination. Plz send them to my mail Id das.neelam@gmail.com . Plz send it today, tomorrow i've the exam.
If u need any fake experience certificate in software side, contact me at: vikramyadhav@gmail.com
Give examples of macro quoting function?
what is class module in vb6? what it's use? with example..
Bonjour, svp je veut voir comment envoyer un mail en java et comment changer le droit d'accé d'un fichier en java: de lecture en lecture/écriture et merci d'avance ;)
what is the diff bw sql direct and jdbc update can't we do select and updating operation in sql direct
I am taking the bmc control m/enterprise manager 7.0 scheduling test and just wanted to see what kind of questions they would ask or if anyone has taken the test and how long it is for how many questions?
can we extend a class having only one parameterised constructor.Suggest the process to do it.
How to get the index of the clicked field in reports in ABAP?
Compare any 4 software development life cycle paradigms with each other. Indicate at least one application for each of the paradigms that are suitable to developed using that paradigm.
hi, all this is shoba m.c.a . i have learned abap but no oppurtunities right now as fresher , right now i want to learn any course on demand any one pls suggest me good course and institute in hyderabad
Hi Guys, This is Rama, right now I am working as a Software Test Engineer in Gurgoan and I have over all 3 years of testing expoeriance. Right now I am looking for a change. Can any body help me out to find a job in south india. Thanks in Advance
