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 / chandrakanth

proc sql;
create table dataset-name as select distinct(variable-name),list-all-the-variables-you-want from dataset-name;
quit;

please let me know if you have any questions

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Enlist the functions performed by sas.

1104


how to generate the test data in sas without input data? : Sas-administrator

1107


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

1055


Describe the ways in which you can create a macro variable?

1067


What is run-group processing?

1143


How do you control the number of observations and/or variables read or written?

1235


Mention the validation tools used in SAS?

1148


How sas treats the dsd delimiters?

1196


What are the default statistics that proc means produce?

1020


What is a pdv and what are its functions?

1120


How many ways to overcome a missing values???

2796


Difference between sum function and using “+” operator?

1136


what is program data vector? : Sas-administrator

1057


What are the features of base sas system?

1051


hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2096