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 are the 3 components in sas programming?
What is the purpose of _character_ and _numeric_?
How would you define the end of a macro?
what can you learn from the sas log when debugging? : Sas programming
what are 5 ways to perform a table lookup in sas? : Sas-administrator
In sas admin differentiate between roles and capabilities? : sas-grid-administration
List out some key concept of SAS
What are the differences between proc means and proc summary?
how can you create zero observation dataset? : Sas programming
Explain the special input delimiters used in sas programming.
What do you know about sas data set?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What is slibref?
Approximately what date is represented by the SAS date value of 730?
how does sas handle missing values in a merge? : Sas programming