DATA Step, Macro, Functions and more

Convert Label Values to Character String Column

Reply
Occasional Contributor
Posts: 8

Convert Label Values to Character String Column

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;


 

Super User
Posts: 22,873

Re: Convert Label Values to Character String Column

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;


 



 

Occasional Contributor
Posts: 8

Re: Convert Label Values to Character String Column

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

Ask a Question
Discussion stats
  • 2 replies
  • 84 views
  • 0 likes
  • 2 in conversation