![]() ![]() ![]() Use ACCESS to PC FILES (via PROC IMPORT, or the checkbox in the import wizard)Įither of those will allow you to read in your line feed characters.Convert the file to CSV from Excel yourself, and then read it in.The only way to get around this that I'm aware of is to either: It's referring to the LF character in that case. Translated to alternative characters so as to avoid transmission Some characters embedded within the spreadsheet data were You'll see that in the notes in the program it generates: ![]() Instead of keeping them, which would be possible but is riskier (remember, this has to work for any incoming file), what it does is convert those to periods. What it does is convert it to a delimited file, and it doesn't handle LF characters very cleanly there. In this case, what's happening is that SAS's method for reading the data in is very rudimentary. EG's import wizard is unique in SAS tools in how it works, and really was meant only to supply a way for data analysts who were not programmers to quickly bring in data it's not robust enough for production work. I would not recommend using the Import Wizard there are far better tools nowadays. My import code (variables replaced with 'text' for simplicity) for reference: data work.table Has anyone else come across this issue? Is there an option to change/set the default line feed replacement character in SAS? However, SAS does not provide a built-in procedure to import data directly from a Microsoft word (RTF formatted) document into SAS, however use of LIBNAME/ PROC IMPORT reads data from Microsoft. This prevents me from differentiating them from normal full stops, which means there's no possible workaround. However, the hex code for the period in my text (what used to be a line return in excel) is 2E, rather than the expected 0A. When I convert the text in excel to hex in excel using a formula, the new line feeds also show up as 0A. Usually line feeds or carriage returns are replaced by spaces, where the hex code (if you format the text as hex) is 0A. However, when viewing the data in SAS, cells with newlines have all line feeds (alt+Enter) replaced with a period (.) I am importing a dataset from excel using the built in import data wizard. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |