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
What is SAS? What are the functions does it performs?
why is a stop statement needed for the point=option on a set statement? : Sas programming
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
AE datasets names? how many types?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
What are the table names in oracle database...?
What are the statements that are executed only?
What would you change about your job?
what is sas metadata repository? : Sas-bi
Differentiate input and infile.
what is the basic structure sas administrator? : Sas-administrator
What will calendar procedure do?
what is slowly changing dimension? : Sas-di
What is the difference between using drop = data set option in data statement and set statement?
how sas deals with business intelligence? : Sas-bi