Date:         Mon, 25 Jul 2005 13:11:10 -0700
Reply-To:     Nancy Li <nancy_li66@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nancy Li <nancy_li66@YAHOO.COM>
Subject:      Help needed to convert text file to SAS file
Content-Type: text/plain; charset=iso-8859-1

Dear all,



I need help to convert the following text file to SAS file. There are two parts for each line which is divided by ‘:’, the part before ‘:’ will be the variable name and the part after ‘:’ will be the value for the corresponding variable in the final SAS file. (Actually, there is only one line for HealthCoachNotes and Notes respectively in the text file). I want to ignore the second to fourth line, convert the first line, skip over the second to fourth line, and continue to convert the fifth till the end.  Does anybody have any idea how to do it? Any input would highly appreciate.



Thanks in advance!



Sent:            Tuesday, June 28, 2005 3:51 PM

To:            referral@health.com

Subject:            Referral Form



Affordability:            -1

calldate:            6/28/05

CaseMgtReferral:         0

contact dat:            7/20/05

Contacted:            -1

Date of Birth2:            1/19/1960

DateOfCall:            None

DefMemberName:       Smith Barry

DFDOB:            None

Duable Medical Equipment:            0

End of Life:            0

Facility5:            0

Food Stamps:            0

HC Name:            Cindy x 0068

HealthCoachNotes:            Member states she has difficulty affording medications.  She also states that she has a torn rotator cuff and could not get surgery - she is not sure if she needs surgery, but she stated she did not think she could get it if needed.  Mbr is currently finishing up a course of rehab for shoulder & back; multiple mental health issues -sees counselor every other week.  Thank You.  If any questions, please feel free to call me.

Home Health Care (>6 weeks)1:            0

Housing:            0

Insurance/Benefit:         -1

Legal Issues:            0

Medical Equipment:            0

Member3:            0

Mental Health1:            -1

Not Contacted:            0

Nutrition:            0

other resource:            0

Other5: 0

Other7: -1

Notes:  Spoke with member- she is aware she can switch to a different clinic and receive her medications there under the Free Care program- she has seen this PCP for many years and does not want to change doctors.  I sent info to member re:Patient Assistance Program through Abbott for synthroid.  Also sent her an application for Medline- they have access to many more programs that may assist member with costs of meds.

thx

Patient ID:            1000012345

pcp id2:            10006789

Permission9:            0

Phone Day:            (902) 123-4567

Physician name:            Dr xxx xx

Physician3:            0

Plan Name3:            Free Care

Rehab Needs2:            0

Substance Abuse:  0

SW Referral:            0

Transportation:            0

URGENT:            0







---------------------------------
Yahoo! Mail
 Stay connected, organized, and protected. Take the tour