HI! I am having a problem getting an Excel file (xlsx) in a CSV file format that I can use to import into SAS. I have a very long text column in the Excel spreadsheet. When I save the file to a CSV file and use Proc Import, it appears that the column gets read in as individual rows instead of a column. When I open the CSV file in Excel, the format is fine. If I open the CSV file in Word, I can see that portion of the text column data is displayed as a row, whether than a continuous text column. Is there some other format I should be using to prevent this happening. Unfortunately, I have several files with long text columns that are acting the same way when I want to import the file in my SAS process. I have tried saving the file as a tab delimited instead of a comma delimited file with the same results.
Thanks!
... View more