how to remove the duplicates by proc sql?
- 2 Answers
- 8612 Views
- Genpact, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / xxx
proc sql;
select id where id(select id from tablename)group by id
having id>1;
quit;
| Is This Answer Correct ? | 1 Yes | 10 No |
Mention some common errors that are usually committed in sas programming.
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
How we can create SAS USER DEFINED CODE?
what type of graphs we will create(for 2+years candidates)?
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
which stats created by proc means that are not created by proc summary or vice versa?
i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
what is operational data and operational system? : Sas-di
how to assign a macro value to a variable?
What are pdv and it functions?
Explain the special input delimiters used in sas programming.
Teradata 
