12-29-2015
Jsanders
Fluorite | Level 6
Member since
12-28-2015
- 3 Posts
- 3 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by Jsanders
Subject Views Posted 1634 12-29-2015 08:52 AM 1679 12-28-2015 01:09 PM 1695 12-28-2015 12:43 PM -
Activity Feed for Jsanders
- Posted Re: Help with crazy delimiters in TXT file on SAS Programming. 12-29-2015 08:52 AM
- Liked Re: Help with crazy delimiters in TXT file for Patrick. 12-29-2015 08:52 AM
- Liked Re: Help with crazy delimiters in TXT file for PGStats. 12-29-2015 08:51 AM
- Liked Re: Help with crazy delimiters in TXT file for Astounding. 12-29-2015 08:50 AM
- Posted Re: Help with crazy delimiters in TXT file on SAS Programming. 12-28-2015 01:09 PM
- Tagged Help with crazy delimiters in TXT file on SAS Programming. 12-28-2015 12:44 PM
- Tagged Help with crazy delimiters in TXT file on SAS Programming. 12-28-2015 12:44 PM
- Posted Help with crazy delimiters in TXT file on SAS Programming. 12-28-2015 12:43 PM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 2
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
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