https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-New-Column-Position/m-p/2178#M729 Occasionally I need to add a column to a dataset. The new column always becomes the first column. How can I control it so the column is added after the last column.<BR /> Ex:<BR /> data rfa;<BR /> format b_flag ;<BR /> label b_flag = 'Flag';<BR /> if (eFlag or cFlag) then b_flag = 1;<BR /> else b_flag=0;<BR /> run; Tue, 30 Jan 2007 17:08:04 GMT deleted_user 2007-01-30T17:08:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-New-Column-Position/m-p/2178#M729 Occasionally I need to add a column to a dataset. The new column always becomes the first column. How can I control it so the column is added after the last column.<BR /> Ex:<BR /> data rfa;<BR /> format b_flag ;<BR /> label b_flag = 'Flag';<BR /> if (eFlag or cFlag) then b_flag = 1;<BR /> else b_flag=0;<BR /> run; Tue, 30 Jan 2007 17:08:04 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-New-Column-Position/m-p/2178#M729 deleted_user 2007-01-30T17:08:04Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-New-Column-Position/m-p/2179#M730 The trick is to type your first statement about your new variable (either FORMAT, LABEL or the variable's formula) AFTER the reading (SET or MERGE) statement ; then your variable is added at the far right of the dataset.<BR /> If you type at least one of the statements mentionning the new variable before the reading statement, it will be created at the left of the dataset.<BR /> <BR /> Regards.<BR /> Olivier Thu, 01 Feb 2007 10:23:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Dataset-New-Column-Position/m-p/2179#M730 Olivier 2007-02-01T10:23:52Z