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;
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;
Yep, exactly along those lines, except I don't have access to the myformat format. My real data is a SAV file.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.