topic Re: listings help in SAS Programming

listings help

rashmirao99 — Fri, 09 Feb 2018 20:56:09 GMT

I need to create a listings. And trying to do it with proc report. is there anyway I can create a common Heading called 'Date' and under Date I have three columns(variables). Basically it should look like this: Is this possible in proc report?

Date

Birthdate Rficdtc Incdat

Hope it is understandable.

Thanks

Rashmi.

Re: listings help

Reeza — Fri, 09 Feb 2018 20:59:42 GMT

Yes its possible, usually use the option ACROSS within the DEFINE statement.

Vague questions get vague answers. If you need more help, post more details.

@rashmirao99 wrote:

Hi

I need to create a listings. And trying to do it with proc report. is there anyway I can create a common Heading called 'Date' and under Date I have three columns(variables). Basically it should look like this: Is this possible in proc report?

                                                      Date

                                 Birthdate          Rficdtc       Incdat

Hope it is understandable.

Thanks

Rashmi.

Re: listings help

PGStats — Sat, 10 Feb 2018 05:13:55 GMT

A small example:

proc report data=sashelp.cars;
where make="Acura";
columns model ("Miles per Gallon" MPG_City MPG_Highway);
define model / format=$24.;
define MPG_City / "City";
define MPG_Highway / "Highway";
run;

                                               Miles per Gallon
                   Model                          City    Highway
                    MDX                             17         23
                    RSX Type S 2dr                  24         31
                    TSX 4dr                         22         29
                    TL 4dr                          20         28
                    3.5 RL 4dr                      18         24
                    3.5 RL w/Navigation 4dr         18         24
                    NSX coupe 2dr manual S          17         24

The expression in parentheses in the columns statement does it.