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

What are the 3 components in sas programming?

1242


What is the purpose of _character_ and _numeric_?

1109


How would you define the end of a macro?

1151


what can you learn from the sas log when debugging? : Sas programming

1144


what are 5 ways to perform a table lookup in sas? : Sas-administrator

1297


In sas admin differentiate between roles and capabilities? : sas-grid-administration

1053


List out some key concept of SAS

1216


What are the differences between proc means and proc summary?

1198


how can you create zero observation dataset? : Sas programming

1203


Explain the special input delimiters used in sas programming.

1050


What do you know about sas data set?

1193


What is the differnce between SDTM 3.1.2 to 3.1.1 version

5118


What is slibref?

1334


Approximately what date is represented by the SAS date value of 730?

1273


how does sas handle missing values in a merge? : Sas programming

1103