I'm importing some data from the web using an infile statement in a data step. Some of the fields contain carriage returns / line feeds in the middle of the data that cause bad records to be returned. I'm trying to find the simplest was to clean up the culprit fields which have these characters so the resulting data set in my work file doesn't have these errors. I was thinking of using the Compress function to remove the characters, but I don't know where to put it in the code. Compress(name,'0D0A'x) Here's a simplified version of my code that creates a work file but with errors. filename notes url "http://www.website.com/....";
data WORK.NOTES;
infile NOTES
delimiter = ','
MISSOVER
DSD
firstobs=2;
informat name $150. ;
informat note $300. ;
format name $150. ;
format note $300. ;
input
name $
note $;
run;
... View more