Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1417


Explain the use of proc print and proc contents?

908


Can you suggest us materials for sdtm mapping?

4388


Describe the function and untility of the most difficult SAS macro that you have written.

2056


How do you delete duplicate observations in sas?

1011


what is the use of proc contents and proc print in sas? : Sas-administrator

1001


How to create a permanent sas data set?

1140


explain what is data set in sas? : Sas-administrator

915


What is the difference between match merge and one to one merge?

1156


What are common programming errors committed in sas

1100


What is SAS?

987


describe the interaction table in sas di? : Sas-di

968


What is by-group processing?

947


Can you execute macro within another macro? : sas-macro

938


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1176