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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.