1

I do this to get a TABLE like below

PROC FREQ data=projet.matchs;
    TABLES circuit/ NOCUM;
run;
Circuit Fréquence   Pourcentage
ATP      127           50.00
WTA      127           50.00

I need exactly the same except that I want "Male" instead of ATP and "female instead of "WTA" So i tues it is a renaming function but I don't know how to use it.

Thanks for the help

Richard
  • 25,390
  • 3
  • 25
  • 38

1 Answers1

1

Note those are not "row variable names". They are the actual (or formatted) values of your variable CIRCUIT.

Looks like you want to create a custom format to change how the values in your variable are displayed.

proc format ;
  value $gender 'ATP'='Male' 'WTA'='Female';
run;

Then tell the proc to use that format for your variable.

PROC FREQ data=projet.matchs;
    TABLES circuit/ NOCUM;
    format circuit $gender. ;
run;
Tom
  • 47,574
  • 2
  • 16
  • 29