How to get the repeated values by using sql in sas ?
Answers were Sorted based on User's Feedback
Answer / rg
proc sql;
select name, count(*)
from data
group by name
having count(*) > 1;
quit;
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between proc means and proc summary?
why a stop statement is needed for the point= option on a set statement?
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
Describe a time when you were really stuck on a problem and how you solved it?
Explain how merging helps to combine data sets.
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
What versions of SAS have you used (on which platforms)?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
how do you validate sas program?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
explain what is factor analysis? : Sas-administrator