07-07-2016 08:52 AM
I have an imported dataset (from a text file) and added only one column to the table / dataset called "Data_Source". The position of the added column is Last. How can I move it to First?
Columns Order IS:
A B C D Data_Source
Column Order Desired:
Data_Source A B C D
07-07-2016 08:57 AM
how have you added the column ? If you have used a data step than you can put it in the first position by simply naming it before the set statement. For example:
data want; length a $ 15; set sashelp.class; a='z'||name; run;
07-07-2016 10:06 AM
Here is my code to add the new column, not in the text file that was imported.
/* Add Field */
alter table work.Loan_Detail_&i.
add Data_Source CHAR(35);
07-07-2016 10:37 AM
07-13-2016 08:19 AM
I found some code that works. Not sure how it works but it move my columns to the front.
/* Change Order of Fields*/
retain Source_Date Data_Source;
07-13-2016 01:56 PM