topic delimiter either one or the other in SAS Programming

delimiter either one or the other

myboys2 — Thu, 29 Jun 2017 15:17:03 GMT

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

Re: delimiter either one or the other

Reeza — Thu, 29 Jun 2017 15:27:42 GMT

DELIMITER=",|"

http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n1rill4udj0tfun1fvce3j401plo.htm

Re: delimiter either one or the other

RW9 — Thu, 29 Jun 2017 15:38:35 GMT

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.