Hi All,
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
Many Thanks
hEllo,
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;
Here is my code to add the new column, not in the text file that was imported.
/* Add Field */
proc sql;
alter table work.Loan_Detail_&i.
add Data_Source CHAR(35);
run;
I found some code that works. Not sure how it works but it move my columns to the front.
/* Change Order of Fields*/
data work.ALL_MONTHS_LOAN_DETAIL;
retain Source_Date Data_Source;
set ALL_MONTHS_LOAN_DETAIL;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.