how do we get duplicate observations in a separate dataset?
- 6 Answers
- 13442 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / rajaanku11
proc sql;
create table dup_obs as (
select * from <lib>.<dsn>
group by <dup var>,<list of other vars>
having count(*)>1 )
quit;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What commands are used in the case of including or excluding any specific variables in the data set?
What are common programming errors committed in sas
What is the maximum and minimum length of macro variable
explain what is factor analysis? : Sas-administrator
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
Can you suggest us materials for sdtm mapping?
What is run-group processing?
What are the advantages of using sas?
what is the use of sas management console? : Sas-di
What is by-group processing?
Describe 5 ways to do a “table lookup” in SAS?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Why and when do you use proc sql?
