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 delete the duplicate columns permanently in SQL

Answer Posted / naveen

data aaa;
input P_Id LastName $ FirstName $ City $;
cards;
1 Hansen Ola Sandnes
2 Svendson Tove Sandnes
3 Pettersen Kari Stavanger
;
run;
proc sql;
select distnict(city)
from aaa;
quit;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are you involved in writing the inferential analysis plan? Tables specifications?

3926


What is the difference between input and infile statement?

1135


what are the categories that sas informats are used to the place the data? : Sas-administrator

1014


Explain the main difference between the sas procedures and functions? : Sas-administrator

1037


which date functions advances a date time or date/time value by a given interval? : Sas programming

924


What are SAS/ACCESS and SAS/CONNECT?

1109


What are the limitations for memory allocation for SAS variables

1444


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1504


How many data types are there in SAS?

1042


how many types prompting framework can be broken down to? : Sas-bi

1053


What is the maximum and minimum length of macro variable

1196


describe how to adjust the performance of data integrator? : Sas-di

968


how the sas basic syntax style described? : Sas-administrator

992


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2313


how to change the execute of macro

2263