DATA Step, Macro, Functions and more

Error for imputting the text.

Accepted Solution Solved
Reply
Super Contributor
Posts: 319
Accepted Solution

Error for imputting the text.

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;

 


Accepted Solutions
Solution
‎10-23-2017 03:22 PM
Super User
Posts: 5,518

Re: Error for imputting the text.

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

;

View solution in original post


All Replies
Super User
Posts: 19,878

Re: Error for imputting the text.

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

 

Solution
‎10-23-2017 03:22 PM
Super User
Posts: 5,518

Re: Error for imputting the text.

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

;

Super Contributor
Posts: 319

Re: Error for imputting the text.

Posted in reply to Astounding

Cool, Astounding!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 108 views
  • 3 likes
  • 3 in conversation