I'm trying to inport some data of the following structure: !434!,!23!,!-99999!,!6!,!-99999!,!6|7!,!-99999!,!10!,!311/1803!,!20140930!,!72!,!3.2! !438!,!97!,!DENTISTRY, GENERAL!,!97!,!TSBDE PROVIDER!,!6|7!,!-99999!,!-99999!,!312/1803!,!20140930!,!72!,!3.2! However the comma in the string is being read as a delemiter. Here is my code so far: data test; infile "P:\crv_1208_prov_20151228.txt" dlm=",!" truncover; input ProviderID :4.0 ProviderSpecialty :2.0 ProviderSpecialtyOther :$200. ProviderType :2.0 ProviderTypeOther :$200. PracticeType :$5. PracticeTypeOther :$200. ProviderYears itemNumber :$9. extractDate :yymmdd8. providingSite ddVersion ;
... View more