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
how do you pull data from equifax?tell me the process?
How can sas program be validated?
Tell me more about the parameters in macro? : sas-macro
Differentiate input and infile.
For what purpose would you use the RETAIN statement?
what is enterprise guide? What is the use of it? : Sas programming
Differentiate between proc means and proc summary.
What are the difference between sas functions and procedures?
what are the scrubbing procedures in sas? : Sas programming
it will become easy if uuu provide website linkssss and list of consultanciessssss
what other sas products have you used and consider yourself proficient in using? : Sas programming
why is sas considered self-documenting? : Sas programming
What are the functions which are used for character handling functions?
What are the default statistics that proc means produce?
for report generation which one you used proc report or data_null_?