how do we get duplicate observations in a separate dataset?
- 6 Answers
- 12948 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
How do you add a number to a macro variable? : sas-macro
What is the difference between reading data from an external file and reading data from an existing data set?
which date function advances a date, time or datetime value by a given interval? : Sas programming
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
explain what is factor analysis? : Sas-administrator
How to convert a numeric variable to a character variable?
In sas, what are the areas that you are most interested in? : sas-grid-administration
How would you invoke a macro? : sas-macro
What do the mod and int function do? : Sas programming
Describe crosslist option in tables statement?
What is factor analysis?
What is the difference between class statement and by statement in proc means?
what is the difference between floor and ceil functions in sas? : Sas-administrator
Name and describe few sas character functions that are used for data cleaning in brief.
What is the use of PROC gplot?
