https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470499#M120420 <P>Thank you.&nbsp; I realized the formatting was off in my original download.</P> Fri, 15 Jun 2018 01:37:38 GMT jillf78 2018-06-15T01:37:38Z https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470485#M120412 <P>I'm just learning SAS and was presented with a .txt data file that has tab and space delimiters for varying lengths of city names and months.&nbsp; Is there an easy way to code this is SAS to format all the same for variables and obs?&nbsp; The only thing I could think to do was manually tab out the whole doc to avoid figuring out how to do it in SAS but I feel like that probably isn't the right solution.&nbsp; Thanks!</P> Fri, 15 Jun 2018 00:34:36 GMT https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470485#M120412 jillf78 2018-06-15T00:34:36Z https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470489#M120414 <P>You can specify multiple delimiters, but are you sure a space is a delimiter?</P> <P><A href="https://communities.sas.com/t5/Base-SAS-Programming/Input-datalines-with-tab/m-p/445667/highlight/true#M111708" target="_blank">https://communities.sas.com/t5/Base-SAS-Programming/Input-datalines-with-tab/m-p/445667/highlight/true#M111708</A></P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/196600">@jillf78</a>&nbsp;wrote:<BR /> <P>I'm just learning SAS and was presented with a .txt data file that has tab and space delimiters for varying lengths of city names and months.&nbsp; Is there an easy way to code this is SAS to format all the same for variables and obs?&nbsp; The only thing I could think to do was manually tab out the whole doc to avoid figuring out how to do it in SAS but I feel like that probably isn't the right solution.&nbsp; Thanks!</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Fri, 15 Jun 2018 00:54:57 GMT https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470489#M120414 Reeza 2018-06-15T00:54:57Z https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470499#M120420 <P>Thank you.&nbsp; I realized the formatting was off in my original download.</P> Fri, 15 Jun 2018 01:37:38 GMT https://communities.sas.com/t5/SAS-Programming/creating-a-data-set-with-different-delimiters/m-p/470499#M120420 jillf78 2018-06-15T01:37:38Z