topic Re: Proc format: add format to existing varaible without change the values in New SAS User

Proc format: add format to existing varaible without change the values

Ronein — Tue, 25 Feb 2020 08:17:03 GMT

Hello

I want to add format to variable x .

When I look at values of X in data set b I see that the values are the formatted values and not the original values.

Why did it happen?

What is the way to solve it?

I want to keep have the original values of X (222,333,444,555) but with a formatted values in behind (abcd,efgh,aabb,ddnn)

Data a;
input x ;
cards;
222
333
444
555
;
Run;

proc format;
value FFmt
222='abcd'
333='efgh'
444='aabb'
555='ddnn'
;
Run;

Data b;
set a;
format x FFmt.;
Run;

Re: Proc format: add format to existing varaible without change the values

PeterClemmensen — Tue, 25 Feb 2020 08:19:59 GMT

Do you want the formatted value to be in another variable or?

Re: Proc format: add format to existing varaible without change the values

Kurt_Bremser — Tue, 25 Feb 2020 08:20:21 GMT

The values never change by assigning a format, only the display. If you want to see both formatted and raw values in a dataset viewer, you need to have two variables, one with and one without the format.

Re: Proc format: add format to existing varaible without change the values

ed_sas_member — Tue, 25 Feb 2020 11:21:19 GMT

Hi @Ronein

Does this answer your question?

proc format;
	invalue $in_FFmt '222'='abcd' '333'='efgh' '444'='aabb' '555'='ddnn';
	value   $FFmt 'abcd'=222 'efgh'=333 'aabb'=444 'ddnn'=555;
Run;

Data a;
	input x $in_FFmt.;
	cards;
222
333
444
555
;
Run;

title "Without format (= real stored value)";
proc print noobs data=a;
run;

title "With format";
proc print noobs data=a;
	format x $FFmt.;
run;

Re: Proc format: add format to existing varaible without change the values

Tom — Tue, 25 Feb 2020 14:05:51 GMT

Changing the format only changes how the data is displayed, it does not change the data.

Perhaps you want to use a different format that shows both the raw and formatted values (code and decode)?

proc format;
value FFmt_both
222='222 abcd'
333='333 efgh'
444='444 aabb'
555='555 ddnn'
;
Run;