Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Comma in Text String of Excel Cell
- Thread starter mychal
- Start date
If you read the data in as a CSV file then yes, it'll cause problems, however, if you use the import procedure that should hopefully circumvent this issue.
If you HAVE to export it from Excel to a flat file, then read it in to SAS, use a different delimiter than a comma, personally, I always opt for using pipes "|" as delimiters as you can be pretty sure that there will not be any of those used in the actual text, whereas the two most common delimiters (tabs and commas) are frequently used (be especially careful of tab delimited files exported from Access).
Another pitfall to watch out for is header rows which I have occasionally come across containing carriage returns, which obviously signify the end of the line to SAS and can cause havoc.
If you HAVE to export it from Excel to a flat file, then read it in to SAS, use a different delimiter than a comma, personally, I always opt for using pipes "|" as delimiters as you can be pretty sure that there will not be any of those used in the actual text, whereas the two most common delimiters (tabs and commas) are frequently used (be especially careful of tab delimited files exported from Access).
Another pitfall to watch out for is header rows which I have occasionally come across containing carriage returns, which obviously signify the end of the line to SAS and can cause havoc.
- Status
Similar threads
- Locked
- Question
- Locked
- Question