creating a data set with different delimiters

[jillf78]

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.  Is there an easy way to code this is SAS to format all the same for variables and obs?  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.  Thanks!

[Reeza · Accepted solution]

You can specify multiple delimiters, but are you sure a space is a delimiter?

https://communities.sas.com/t5/Base-SAS-Programming/Input-datalines-with-tab/m-p/445667/highlight/tr...

---

@jillf78 wrote:

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.  Is there an easy way to code this is SAS to format all the same for variables and obs?  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.  Thanks!

---

[jillf78]

Thank you.  I realized the formatting was off in my original download.