Error for imputting the text.

[ybz12003]

Hello:

I have a problem when I am trying to create a SAS dataset.  As list below, the GEO_ID column contains the text  before the blank, such as '1400000US06001401300'.  While the GEO_display_lable contains the text after the blanks, such as '

Census Tract 4013, Alameda County, California'.    After I run my codes, I found all the text put into second column.   I think I need to add some dlm or dsd, but it didn't seem right.  Please advice how to fix it.  Thanks.

data have;

input geo_id $20. GEO_display_label $120.;

cards;

0400000US06 California

1400000US06001401300 Census Tract 4013, Alameda County, California

1400000US06037131400 Census Tract 1314, Los Angeles County, California

1400000US06037408627 Census Tract 4086.27, Los Angeles County, California

;

run;

[Reeza]

What's the delimiter in the file? This looks like Census data so it's usually well formed...

[Astounding · Accepted solution]

I would take the easy way out:

data want;

length geo_id $ 20 geo_display_label $ 120;

input geo_id geo_display_label &;

cards;

0400000US06 California

1400000US06001401300 Census Tract 4013, Alameda County, California

1400000US06037131400 Census Tract 1314, Los Angeles County, California

1400000US06037408627 Census Tract 4086.27, Los Angeles County, California

;

[ybz12003]

Cool, Astounding!