Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete the duplicate columns permanently in SQL
- 2 Answers
- 6309 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
How do you specify the number of iterations and specific condition within a single do loop?
Explain proc univariate?
Explain proc sort?
What are the table names in oracle database...?
what is proc Index? and what is proc document?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What are the limitations for memory allocation for SAS variables
how sas deals with business intelligence? : Sas-bi
What are the different versions of sas that you have used until now? : sas-grid-administration
how would you create multiple observations from a single observation? : Sas programming
what is the use of proc sql? : Sas programming
which features do you use to check the data validations and errors? : Sas-administrator
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
What is the work of tranwrd function?
