topic Re: Renamig values of a string variables in SAS Programming

Renamig values of a string variables

samface — Wed, 29 Aug 2018 13:33:12 GMT

Hello,

I need help renaming values of a string variable and perform a proc freq procedure. The column looks like this:

Column name: Product

Column values: (org1-2, ban3-3)

I would like to change the format of my column values to:

org1-2 = orange

ban3-3 = banana

I used the following code:

proc format;

value $product 'Orange' = 'org1-2';

run;

proc freq data=work.food;

tables product;

format product $product.;

run;

I ran the code, the values didn't change to the format I specified in my code. Any help?

Re: Renamig values of a string variables

PaigeMiller — Wed, 29 Aug 2018 13:34:38 GMT

proc format;

value $product 'Orange' = 'org1-2';

run;

should be

proc format;
    value $product 'org1-2' = 'Orange';
run;

Re: Renamig values of a string variables

samface — Wed, 29 Aug 2018 13:39:25 GMT

It worked thanks @PaigeMiller , I was close just had to inverse the order. Thanks again.

Re: Renamig values of a string variables

samface — Wed, 29 Aug 2018 13:51:45 GMT

@PaigeMiller

Another question, when I ran the same code for the other value, the additional aren't formatted. Do you know why?

proc format;
    value $product 'org1-2' = 'Orange'
                   'ban3-3 = 'banana';
run;

I used the above code.

Re: Renamig values of a string variables

samface — Wed, 29 Aug 2018 13:55:12 GMT

proc format;

value $product 'org1-2' = 'Orange'

'ban3-3' = 'banana';

run;

Re: Renamig values of a string variables

PaigeMiller — Wed, 29 Aug 2018 13:57:40 GMT

@samface wrote:

Another question, when I ran the same code for the other value, the additional aren't formatted. Do you know why?

I don't know what this means.

Re: Renamig values of a string variables

samface — Wed, 29 Aug 2018 14:04:36 GMT

OK sorry for the typo.

I used the code below to format additional value whitin my column but nothing has changed.

proc format;

value $product 'org2-2' = 'orange'

'ban3-3' = 'banana';

run;

When I ran it, the formatting only works for 'orange' and not 'banana'. Am I doing something wrong? or do I need to create a new format for each additional value in my product colum?

Thanks.

Re: Renamig values of a string variables

samface — Wed, 29 Aug 2018 14:08:31 GMT

No worries I got it.