Renamig values of a string variables

[samface]

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?

[PaigeMiller · Accepted solution]

proc format;

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

run; 

should be

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

[samface]

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

[samface]

@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.  

[samface]

proc format;

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

                        'ban3-3' = 'banana';

run;

[PaigeMiller]

---

@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.

[samface]

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.

[samface]

No worries I got it.