Your post looks garbled. Please post same data using the Insert Code icon on the toolbar in the editor. This will pop-up a new window where you can past the data and/or code and it will preserve the spacing and line breaks.   If your data is in lines then something as simple as this will combine the first word with all of the following words on the line.  data want ; length empid $10 department $20 ; infile datalines truncover ; input empid department @ ; do until (missing(department )); output; input department @; end; datalines; P9988 HR Finance Analytics S3498 HR IT Finance R4634 Finance Analytics Sale ; Is the there are multiple EMPID on the same line then you need some logic to tell an EMPID from a DEPARTMENT name. In you example if looks like they are a letter followed by 4 digits. So something like this should work. data want ; length empid $10 department $20 ; infile datalines flowover ; retain empid ; input department @@ ; if prxmatch('/^[a-z][0-9]{4}$/i',trim(department)) then empid=department; else output; datalines; P9988 HR Finance Analytics S3498 HR IT Finance R4634 Finance Analytics Sale ; ... View more