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;
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
;
What's the delimiter in the file? This looks like Census data so it's usually well formed...
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
;
Cool, Astounding!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.