cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Jsanders
‎12-29-2015
  • 3 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Help with crazy delimiters in TXT file

by Fluorite | Level 6 in SAS Programming
‎12-29-2015 08:52 AM
‎12-29-2015 08:52 AM
Yes! Thank you Patrick. I started working on this issue then had to pass it off to a colleague. I asked him to post to the SAS community since you all are so helpful. Best, Joanne ... View more

Re: Help with crazy delimiters in TXT file

by Fluorite | Level 6 in SAS Programming
‎12-28-2015 01:09 PM
‎12-28-2015 01:09 PM
I think that did the trick, thank you! ... View more

Help with crazy delimiters in TXT file

by Fluorite | Level 6 in SAS Programming
‎12-28-2015 12:43 PM
‎12-28-2015 12:43 PM
Hi there, I have the following text file I need to input using an infile statement.    !ProviderID!,!ProviderSpecialty!,!ProviderSpecialtyOther!,!ProviderType!,!ProviderTypeOther!,!PracticeType!,!PracticeTypeOther!,!ProviderYears!,!itemNumber!,!extractDate!,!providingSite!,!ddVersion! !4!,!28!,!-99999!,!6!,!-99999!,!5!,!-99999!,!19!,!1/1803!,!20140930!,!72!,!3.2! !5!,!28!,!-99999!,!6!,!-99999!,!6|7!,!-99999!,!18!,!2/1803!,!20140930!,!72!,!3.2!   The data I need is within the exclamation points and the delimiter is a comma. Is there a way to strip the exclamation points and have dlm=comma? I tried using the 'dlmstr' option and was not successful.   Best, Joanne ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-29-2015 09:23 AM
Likes given to
View All
Quick links