Challenge Practice: Importing Data with a Specific Delimiter

[CathyVI]

I am having an issue with my code its not running and this is the result from my log;

Code:

{proc import datafile="C:\Users\Adewumi\Documents\EPG194\data\np_traffic.dat"
dbms=dlm
out=traffic2
replace;
guessingrows=200;
delimiter="|";
run;}

log;

{NOTE: The quoted string currently being processed has become more than 262 characters long.
You might have unbalanced quotation marks.
400 proc import datafile= "C:\Users\Adewumi\Documents\EPG194\data\np_traffic.dat"
400! DBMS= dlm
401 out= traffic2 replace ;
402 guessingrows=3000;
403 delimiter= "|";
404 run;}

How do i fix this;

[Cynthia_sas · Accepted solution]

HI:

  It looks like you are working in the Programming 1 e-learning course. In the code you posted, it looks like your quotes are balanced -- in this step. However, my guess is that if you save this program (without the curly braces { }) and close your SAS session, then open SAS back up, you'll find the unbalanced quotes have been cleared. Typically, an error message about unbalanced quotes such as you show happens when a PREVIOUS step had unbalanced quotes and you didn't catch it in time to correct them. The unbalanced quotes from a previous step can impact a new step if you're not careful.

  Here's what the correct code should look like:

The guessingrows was set to 3000 to be sure that the entire raw data file was used to set the variable's type.

Hope this helps.

Cynthia

I believe there is a lecture in the e-learning course about debugging issues like unbalanced quotes. You may want to find it and re-watch the videos.