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
How do you use the do loop if you don’t know how many times you should execute the do loop?
Are you involved in writing the inferential analysis plan? Tables specfications?
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What was the last computer book you purchased? Why?
What does proc print, and proc contents are used for?
Which command is used to save logs in the external file?
Explain the main difference between the sas procedures and functions? : Sas-administrator
What is factor analysis?
To what type of programms have you used scratch macros?
What are the features of SAS?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
what is hash files in sas and why we are using this one in sas?
which features do you use to check the data validations and errors? : Sas-administrator
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
what are the categories that sas informats are used to the place the data? : Sas-administrator