how to delete the duplicate columns permanently in SQL
- 2 Answers
- 5198 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
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How would you identify a macro variable? : sas-macro
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What system options would you use to help debug a macro? : sas-macro
Did you used proc test? when?
What is the difference between input and infile statement?
How do dates work in SAS data?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
In sas, what are the areas that you are most interested in? : sas-grid-administration
Hi, If anyone has base SAS certification dumps, please share.
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
What is the function of Stop statement in a SAS Program?
