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
Enlist the functions performed by sas.
how to generate the test data in sas without input data? : Sas-administrator
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Describe the ways in which you can create a macro variable?
What is run-group processing?
How do you control the number of observations and/or variables read or written?
Mention the validation tools used in SAS?
How sas treats the dsd delimiters?
What are the default statistics that proc means produce?
What is a pdv and what are its functions?
How many ways to overcome a missing values???
Difference between sum function and using “+” operator?
what is program data vector? : Sas-administrator
What are the features of base sas system?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?