https://communities.sas.com/t5/SAS-Programming/compress-space-while-import-excel-file/m-p/960137#M374515 <P>Afaik not possible. You need to post process the data. Something like:</P> <PRE><CODE class=" language-sas">data rajadhani; set rajadhani; tr_no=compress(tr_no); run;</CODE></PRE> <P><BR /><BR /></P> Tue, 25 Feb 2025 08:21:26 GMT Patrick 2025-02-25T08:21:26Z https://communities.sas.com/t5/SAS-Programming/compress-space-while-import-excel-file/m-p/960136#M374514 <PRE><CODE class=" language-sas">proc import datafile="C:\Users\xxxx\Desktop\Rajadhani_Trains.xlsx" out=rajadhani dbms=xlsx replace ; getnames=yes; quit;</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Screenshot 2025-02-25 132458.png" style="width: 795px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/104916i9C40140BD4556D0E/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2025-02-25 132458.png" alt="Screenshot 2025-02-25 132458.png" /></span></P> <P>&nbsp;</P> <P>Hi Guys,</P> <P>Here i have excel file in Tr_No variable observations have embeded spaces please see above marking so i want remove embaded space while import that file&nbsp;</P> Tue, 25 Feb 2025 07:58:40 GMT https://communities.sas.com/t5/SAS-Programming/compress-space-while-import-excel-file/m-p/960136#M374514 BrahmanandaRao 2025-02-25T07:58:40Z https://communities.sas.com/t5/SAS-Programming/compress-space-while-import-excel-file/m-p/960137#M374515 <P>Afaik not possible. You need to post process the data. Something like:</P> <PRE><CODE class=" language-sas">data rajadhani; set rajadhani; tr_no=compress(tr_no); run;</CODE></PRE> <P><BR /><BR /></P> Tue, 25 Feb 2025 08:21:26 GMT https://communities.sas.com/t5/SAS-Programming/compress-space-while-import-excel-file/m-p/960137#M374515 Patrick 2025-02-25T08:21:26Z