topic Error for imputting the text. in SAS Programming

Error for imputting the text.

ybz12003 — Mon, 23 Oct 2017 19:02:22 GMT

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;

Re: Error for imputting the text.

Reeza — Mon, 23 Oct 2017 19:09:37 GMT

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

Re: Error for imputting the text.

Astounding — Mon, 23 Oct 2017 19:17:25 GMT

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

;

Re: Error for imputting the text.

ybz12003 — Mon, 23 Oct 2017 19:22:22 GMT

Cool, Astounding!