Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicate columns permanently in SQL
- 2 Answers
- 6198 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 are _numeric_ and _character_ and what do they do? : Sas programming
What is program data vector (pdv)?
Tell me more about the parameters in macro? : sas-macro
Name few SAS functions?
How to create list output for cross-tabulations in proc freq?
What are the prime responsibilities of data integration administrator? : Sas-di
how are numeric and character missing values represented internally? : Sas programming
What are the uses of sas?
How would you identify a macro variable?
what is enterprise guide? What is the use of it? : Sas programming
Describe crosslist option in tables statement?
What is a macro routine?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
How do you debug and test your SAS programs?
What is the function of Stop statement in a SAS Program?
