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

Explain the difference between nodup and nodupkey options?

697


what type of graphs we will create(for 2+years candidates)?

1995


What versions of SAS have you used (on which platforms)?

1128


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

617


What does PROC print, and PROC contents do?

846






what is business intelligence? : Sas-bi

678


If money were no object, what would you like to do?

2789


For what purposes have you used sas macros? : sas-macro

611


What would you change about your job?

2008


for whom is sas data integration studio designed? : Sas-di

638


: and & modifiers.

958


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2014


what techniques and/or procs do you use for tables? : Sas programming

666


What are the ways to do a “table lookup” in sas?

693


What are the features of base sas system?

695