Convert Label Values to Character String Column

[dewittme]

Hi,

I have a data set that has formatting. I would like to do some calculations, then append the the values while keeping the formatted text. What I would like to do is to convert the format text to a text in another column. 

MY ideal output would be "class_2" that has all of the text from the formatting for "class" but stored as text. MY actual data isn't this symbol...but that is what I would like to do.

DATA toy;
    input class count;
	cards;
	1 5
	2 9
	3 5
	4 13
	;
RUN;

PROC FORMAT;
   value myformat 1 = 'From $1-100'
2 = 'From $101-200'
3 = 'From $201-300'
4 = 'From $301-400';
RUN;

DATA toy;
    SET toy;
	format class myformat.;
RUN;

DATA my_toy;
    SET toy;
	class_2 = put(class, 18.);
RUN;

[Reeza]

DATA my_toy;
    SET toy;
	class_2 = put(class, myformat.);
RUN;

Is that what you're trying to do?

---

@dewittme wrote:

Hi,

I have a data set that has formatting. I would like to do some calculations, then append the the values while keeping the formatted text. What I would like to do is to convert the format text to a text in another column. 

MY ideal output would be "class_2" that has all of the text from the formatting for "class" but stored as text. MY actual data isn't this symbol...but that is what I would like to do.

DATA toy;
    input class count;
	cards;
	1 5
	2 9
	3 5
	4 13
	;
RUN;

PROC FORMAT;
   value myformat 1 = 'From $1-100'
2 = 'From $101-200'
3 = 'From $201-300'
4 = 'From $301-400';
RUN;

DATA toy;
    SET toy;
	format class myformat.;
RUN;

DATA my_toy;
    SET toy;
	class_2 = put(class, 18.);
RUN;

---

[dewittme]

Yep, exactly along those lines, except I don't have access to the myformat format. My real data is a SAV file.