Hi Good Morning,
i am trying to convert RTF file to SAS Dataset but i dn't get solution and i go through with some articles also but no use please get me out from this problem.
Study:XXXX Date: todaydate
Listing 10-3
Demographics
_________________________________________________________________________________
Subject/Age/Sex Treatment start
Date
_____________________________________________________________________________________________
0001-001/45/M 19Jan2013
0001-002/55/M 29Jan2013
0001-003/43/M 12Jan2013
0001-004/42/M 15Jan2013
0001-005/55/M 29Jan2013
0001-006/35/M 16Jan2013
_____________________________________________________________________________________________________________________________________
Note: All patients are shown.
Thanks in advance!!
Thanks in advance!!
Hima
- save as plain text file
- inspect with a good text editor
- determine how to identify the lines that contain data
- write a data step that reads the text file, discards unwanted lines, and converts the input either with a proper input statement or by manually splitting the _infile_ variable.
If this is one time job: copy/paste to flat file format. Edit so it will be in strict columnar format. Going via Excel might help doing the formatting.
If this is a repetitive task: contact the creator of the document and require a different file format.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.