topic Re: Format in proc report in SAS Programming

Format in proc report

BrahmanandaRao — Thu, 31 Oct 2019 08:41:43 GMT

Hi Experts

Good Afternoon,

i trying to change format in sashelp.class

where sex F as Female

M as Male

data ds;
set sashelp.class;
run;

proc format ;
value $sex 'F'='Female'
           'M'='Male';
run;

proc report data= ds;
column name sex age;
define name/display;
define sex/display;
define age/display;
run;

i want to put like below can we do in proc report

Name	Sex	Age
Alfred	Male	14
Alice	Female	13
Barbara	Female	13
Carol	Female	14
Henry	Male	14
James	Male	12
Jane	Female	12
Janet	Female	15
Jeffrey	Male	13
John	Male	12
Joyce	Female	11
Judy	Female	14
Louise	Female	12
Mary	Female	15
Philip	Male	16
Robert	Male	12
Ronald	Male	15
Thomas	Male	11
William	Male	15

Re: Format in proc report

Kurt_Bremser — Thu, 31 Oct 2019 08:54:43 GMT

If you want to have any effect from your format, you need to use it, either in the data step that creates the data, or in the report procedure.

Read the documentation for the DEFINE statement to see how it's done.

Re: Format in proc report

BrahmanandaRao — Thu, 31 Oct 2019 09:04:42 GMT

i want in proc report

Re: Format in proc report

Kurt_Bremser — Thu, 31 Oct 2019 09:07:55 GMT

Then you only need to read the documentation I linked and apply what you learn from it.

Re: Format in proc report

BrahmanandaRao — Thu, 31 Oct 2019 09:25:29 GMT

sorry i cannot undertand clearly

Re: Format in proc report

Jagadishkatam — Thu, 31 Oct 2019 09:36:59 GMT

Please try the below code with format option in proc report

proc format ;
value $sex 'F'='Female'
           'M'='Male';
run;

proc report data= ds;
column name sex age;
define name/display;
define sex/display format=$sex.;
define age/display;
run;

Re: Format in proc report

Kurt_Bremser — Thu, 31 Oct 2019 09:40:21 GMT

@BrahmanandaRao wrote:

sorry i cannot undertand clearly

It is in fact so simple that I won't insult your intelligence by spoon-feeding it. If you could not manage it on your own, you would be too dumb to work with SAS, and you aren't. Do a little work and thinking by yourself.

Re: Format in proc report

BrahmanandaRao — Thu, 31 Oct 2019 16:35:07 GMT

Hi Jagadeesh

Thank your very much for your support