I am trying to read in the following example raw data (ALL PHI and PII Removed fictitious data only): |LastName|,|FirstName|,|Gender|,|PatientID|,|DateOfBirth|,|Ethnicity|,|HospitalRegion|,|HospitalFacility|,|HospitalFacilityTelephone|,|TypeOfTransportation|,|AdmissionDate|,|NumberOfHospitalDays|,|ReferringRegion|,|ReferringFacility|,|ReferringStaffMember|,|AdmissionType_Emergency|,|AdmissionType_Inpatient|,|PhysicianDirectedExamResult|,|RequiresFollowup|,|FollowupDate|,|DischargeDiagnosis|,|DischargedToRegion|,|DischargedToFacility|,|DischargeDate|,|ERClaim|,|HospClaim|,|AdmittingDiag|,|DRG|,|ProfClaim|,|AnesClaim|,|SurgClaim|,|AmbClaim|,|PaymentStatus|,|AuthorizationNumber|,|Comments|
|FakeLAstName|,|FakeFirstName|,|M|,|12345678|,|1900-01-01 00:00:00|,|Caucasian|,|Non Facilities|,|General Hospital|,||,|Ambulance|,|2000-01-01 08:30:00|,|0|,|Region|,|N - M|,|DRLastName, DrFirstName|,|Ye|,|No|,|Chest pain
|,|False|,||,|Chest Pain|,|Region|,|N - M|,|2010-01-01 00:00:00|,||,||,|Chest pain|,||,||,||,||,||,|Approved|,|OP0000000000|,||
|FakeLAstName2|,|FakeFirstName2|,|M|,|23456789|,|1900-01-11 00:00:00|,|Caucasian|,|Non Facilities|,|General Hospital|,|00000000|,|Bus|,|2010-01-01 00:00:00|,|00|,|Region|,|xxxx|,|., (Not Specified)|,|Ye|,|No|,|Hypertension due to septic shock
Abdominal pain due to GI Bleed - resolved
C diff colitis- resolved
Acute Kidney injury likely pre-renal- resolved
PUD w iron deficency anemia-improved|,|False|,||,||,|Non Facilities|,|Unknown|,|2000-01-01 00:00:00|,||,||,||,||,||,||,||,||,|Pending|,||,|| I believe the code I am using fails at "ReferringStaffMember" first because the value has an embedded comma. DSD only works with double quotes and not pipes, is there a workaround? I have tried to use the dlmstr option without success. Please note the "&" and "~" in the input statement. My code: data ERHosp;
infile "ERHospitalization.txt" DLM="," firstobs=2 ;
length LastName $40 FirstName $40 Gender $5 PatientID $8 DateOfBirth $200 Ethnicity $20
HospitalRegion $200 HospitalFacility $60 HospitalFacilityTelephone $20
TypeOfTransportation $20 AdmissionDate $20 NumberOfHospitalDays ReferringRegion $20
ReferringFacility $20 ReferringStaffMember $40 AdmissionType_Emergency $20
AdmissionType_Inpatient $20 PhysicianDirectedExamResult $1000 RequiresFollowup $20
FollowupDate $200 DischargeDiagnosis $200 DischargedToRegion $20 DischargedToFacility $20
DischargeDate $20 ERClaim $20 HospClaim $20 AdmittingDiag $200 DRG $20 ProfClaim $20 AnesClaim $20
SurgClaim $20 AmbClaim $20 PaymentStatus $20 AuthorizationNumber $20 Comments $500;
input LastName $ FirstName $ Gender $ PatientID $ DateOfBirth $ Ethnicity $
HospitalRegion $ HospitalFacility $ HospitalFacilityTelephone $
TypeOfTransportation $ AdmissionDate $ NumberOfHospitalDays ReferringRegion $
ReferringFacility $ ReferringStaffMember & $40. AdmissionType_Emergency $
AdmissionType_Inpatient $ PhysicianDirectedExamResult &~$1000. RequiresFollowup $
FollowupDate $ DischargeDiagnosis $ DischargedToRegion $ DischargedToFacility $
DischargeDate $ ERClaim $ HospClaim $ AdmittingDiag $ DRG $ ProfClaim $ AnesClaim $
SurgClaim $ AmbClaim $ PaymentStatus $ AuthorizationNumber $ Comments $;
run;
... View more