proc import CSV file into SAS with data in cell text with comma

radha009 — Thu, 27 Jun 2019 23:06:33 GMT

i am trying to import CSV file from my local to SAS. The data includes in one of the column ' Description' with below long text with comma and special chars.

' The purpose of this application is to deliver a consistent and repeatable process that demonstrates maturity, comparable with basis.
The capabilities will include: Training & exercise management, crisis management, keep business resiliency program artifacts up to date (such as risk assessments for availability, '

proc import datafile=C:\SAS\Report.csv" out=mydata dbms=CSV replace;
delimiter=',';
GUESSINGROWS=32767;

The import breaking the Description text into multiple cells and creating multiple rows for one row data. Please help me I am trying below options

1. Delete description column before import. I don;t use the Description column in my report

2. Trim Description text before import

Thank you

run;

Re: proc import CSV file into SAS with data in cell text with comma

Reeza — Thu, 27 Jun 2019 23:19:59 GMT

Save it as Excel and import it as Excel. Or you need to process the file first to remove line returns and even then they could include other things that make it really hard to read that line of text.

Tom answered this question on here earlier this week (yesterday I think), for another question with an import issue. You can find his answer on here.

topic Re: proc import CSV file into SAS with data in cell text with comma in SAS Programming

proc import CSV file into SAS with data in cell text with comma

Re: proc import CSV file into SAS with data in cell text with comma