topic Re: Convert Label Values to Character String Column in SAS Programming

Convert Label Values to Character String Column

dewittme — Thu, 19 Apr 2018 18:20:07 GMT

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;

Re: Convert Label Values to Character String Column

Reeza — Thu, 19 Apr 2018 18:31:33 GMT

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;

Re: Convert Label Values to Character String Column

dewittme — Thu, 19 Apr 2018 18:58:20 GMT

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