Changing attribute name / does not display complete string

Reply
Contributor
Posts: 35

Changing attribute name / does not display complete string

Hello,

 

I am tying to change the name of the each region on the following dataset: 

 

Untitled.png

 

I have wrote very simpe data step in sas: 

 

data changName;
set data.region;
if region="STATE" then region="Missouri";
if region="EASTERN" then region="Eastern District";
if region="CENTRAL" then region="Central District";
if region="SOUTHWEST" then region="South Western District";
if region="SOUTHEAST" then region="South Eastern District";
if region="NORTHWEST" then region="North Western District";
run;

but what I got from this code is: 

Untitled.png

 

as you can see it does not show the entire strings! 

 

I would really be appriciate if someone help me with this. 

 

Thank you.

Respected Advisor
Posts: 4,609

Re: Changing attribute name / does not display complete string

Make variable Region larger. Insert length region $24; before the set statement.

PG
Contributor
Posts: 44

Re: Changing attribute name / does not display complete string

Ask a Question
Discussion stats
  • 2 replies
  • 170 views
  • 1 like
  • 3 in conversation