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
Explain the difference between nodup and nodupkey options?
what type of graphs we will create(for 2+years candidates)?
What versions of SAS have you used (on which platforms)?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
What does PROC print, and PROC contents do?
what is business intelligence? : Sas-bi
If money were no object, what would you like to do?
For what purposes have you used sas macros? : sas-macro
What would you change about your job?
for whom is sas data integration studio designed? : Sas-di
: and & modifiers.
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
what techniques and/or procs do you use for tables? : Sas programming
What are the ways to do a “table lookup” in sas?
What are the features of base sas system?