How to get the repeated values by using sql in sas ?
Answer Posted / rg
proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If money were no object, what would you like to do?
What is the difference between one to one merge and match merge? Give an example.
what is broad cast agent? : Sas-bi
how would you create multiple observations from a single observation? : Sas programming
how many types of prompts are there? : Sas-bi
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
What are the advantages of using sas?
what are the considerations when picking a SAS/STAT procedure?
What is the maximum length of the macro variable? : sas-macro
Give e an example of..
describe about physical data integration? : Sas-di
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
is data integration and etl programming is same? : Sas-di
what is sas business intelligence? : Sas-bi
How necessary is it to be creative in your work?