DATA Step, Macro, Functions and more

delimiter either one or the other

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

delimiter either one or the other

i sometime have a delimiter file come in as a comma delmiter one month and next month might come in as a bar (|) delimiter.  how can i code this so that i do not have ot change code every month?  I tried dlmstr=',|' on the bar(|) file and it did not work.  thank you


Accepted Solutions
Solution
‎06-29-2017 11:44 AM
Super User
Posts: 19,804

All Replies
Solution
‎06-29-2017 11:44 AM
Super User
Posts: 19,804

Re: delimiter either one or the other

Super User
Super User
Posts: 7,955

Re: delimiter either one or the other

Just to note, you may want to get this kind of thing fixed down in a data import agreement, signed off by both parties.  Otherwise next time it could be a semi-colon, or maybe next time just a picture file.  Data transfer is always down to the agreements.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 122 views
  • 2 likes
  • 3 in conversation