topic Re: what is the split="_" option in proc print for proc univariate in SAS Programming

what is the split="_" option in proc print for proc univariate

chinaski — Mon, 18 Nov 2019 08:00:46 GMT

Hi,

I want my proc univariate report headings to be seen properly, just like we do in proc print with split="_" option. What is the solution for that. Thanks to anybody that helps.

Value

NAME_SURNAME

FIRM_NAME

PRODUCT_NAME

i want this to be like this in proc univariate report

Value

NAME
SURNAME

FIRM
NAME

PRODUCT
NAME

Re: what is the split="_" option in proc print for proc univariate

Astounding — Mon, 18 Nov 2019 16:22:02 GMT

This may be possible, but you will have to play with it to find out.

Assign labels to the variables, and see if UNIVARIATE will automatically use the labels:

label NAME_SURNAME = 'NAME SURNAME';

Re: what is the split="_" option in proc print for proc univariate

ballardw — Mon, 18 Nov 2019 17:32:35 GMT

@chinaski wrote:

Hi,

I want my proc univariate report headings to be seen properly, just like we do in proc print with split="_" option. What is the solution for that. Thanks to anybody that helps.

Value NAME_SURNAME FIRM_NAME PRODUCT_NAME

i want this to be like this in proc univariate report

Value NAME
SURNAME FIRM
NAME PRODUCT
NAME

Really need to show what Proc Univariate code you are running and indicate which part of the output you expect to appear like that.

Better would be to provide either example input data and the desired result or the desired result of using one of the SAS supplied data sets such as SASHELP.CLASS.

By default Univariate generates a fair amount of input and goes up quickly with additional options. I don't think any of the default tables will appear at all similar to what you are showing. So I am not sure exactly what you want to display.

Re: what is the split="_" option in proc print for proc univariate

chinaski — Fri, 22 Nov 2019 08:22:07 GMT

ods select extremeobs;
proc univariate data=sasuser.cars;
class make;
var MPG_CITY MPG_HIGHWAY;
id Make Model MPG_City MPG_City;
RUN;

Here is the result:

The UNIVARIATE Procedure

Variable: MPG_City (MPG (City))

Make = Acura

Extreme Observations
Lowest						Highest
Value	MPG_City	MPG_Highway	Make	Model	Obs	Value	MPG_City	MPG_Highway	Make	Model	Obs
17	17	24	Acura	NSX coupe 2dr manual S	7	18	18	24	Acura	3.5 RL 4dr	5
17	17	23	Acura	MDX	1	18	18	24	Acura	3.5 RL w/Navigation 4dr	6
18	18	24	Acura	3.5 RL w/Navigation 4dr	6	20	20	28	Acura	TL 4dr	4
18	18	24	Acura	3.5 RL 4dr	5	22	22	29	Acura	TSX 4dr	3
20	20	28	Acura	TL 4dr	4	24	24	31	Acura	RSX Type S 2dr	2

i want MPG_City and MPG_Highway look like this in the Results section:

MPG
City

MPG
Highway