how to delete the duplicate columns permanently in SQL
- 2 Answers
- 5630 Views
- Satyam, I also Faced
- E-Mail Answers
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
what is the basic structure sas administrator? : Sas-administrator
what is sas olap server? : Sas-di
how to debug and test the sas program? : Sas-administrator
explain about various caches available in data integrator? : Sas-di
Explain substr function?
What is the function of output statement in a SAS Program?
what is intially documentation in sas?
How does the internal authentication work in sas? : sas-grid-administration
what are the types of interactive display types? : Sas-bi
What is the SAS data set?
what is the primary data source for the wrs? : Sas-bi
What would you change about your job?
What are the data types does SAS contain?
Can you execute macro within another macro? : sas-macro
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
