cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RS
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Reading text files with carriage returns

by Calcite | Level 5 in SAS Programming
‎09-23-2010 09:32 PM
‎09-23-2010 09:32 PM
Hi Friends, Thanks for sending your suggestions. And sorry that I haven't responded immediately. The OS is windows and SAS version is 9.2. The Carriage Returns (CR) and Line Feeders (LF) are not present in first row and the fields are separated by commas and the values are given in double codes. The CR and LF are present in source file, i.e. access file and I have created a text file from here. I have used PROC import using DBMS=accesscs option and now I can able to create SAS datasets but however these CR and LF need to be removed in SAS datasets. Thanks a lot. -RS ... View more

Reading text files with carriage returns

by Calcite | Level 5 in SAS Programming
‎09-16-2010 11:17 AM
‎09-16-2010 11:17 AM
Hi, I have a text file where the total record length may come to 1500 in a row. In many fields carraige returns and line feeders are present and moreover the fields are embedded by double quotes and separated by commas. I have converted this text file from Microsoft access where I have lot of missing values. How can I create a sas dataset without data mismatch and without errors using this text file. Your reply is deeply appreciated. Thanks. RS ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links