topic Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally? in Statistical Procedures

Why proc freq is aligning categorical variable vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 21:30:17 GMT

Hi ,

I ran proc freq on my data (where my remarknew is a character var with certain length). See table below. So remarknew is newly created var and I used a format statement in datastep to change its format to $19. and verified with proc contents. But why is SAS aligning results this way (SAS9.4). I have to change misspelled categories here, but this alignment is just making it annoying to read words. Any help is appreciated?

Proc contents results;

46	remarknew	Char	19	$19.
47	id	Num	8
48	ptnew	Char	15
49	case	Char	19	$19.
50	trial	Char	19

Thanks

remarknew	Frequency	Percent	Cumulative Frequency	Cumulative Percent
B A E L I N E 1	12	0.15	12	0.15
B A S E L I N E 1	407	4.97	419	5.12
B A S E L I N E 2	420	5.13	839	10.25

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

PaigeMiller — Fri, 27 Sep 2019 19:50:36 GMT

What output destination is this?

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 19:51:22 GMT

ods html .

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Reeza — Fri, 27 Sep 2019 19:51:37 GMT

What's your output destination? What is your current setting for linesize?

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 19:55:42 GMT

I have not set the linesize, its default. ods HTML is output destination.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Reeza — Fri, 27 Sep 2019 19:57:50 GMT

Is it happening for all PROC FREQ or just this table?

What happens if you run the following?

proc freq data=sashelp.class;
table name;
run;

If it doesn't happen with that, its related to your data, not the PROC. If it does happen, it's a setting in SAS somewhere most likely.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Reeza — Fri, 27 Sep 2019 19:58:03 GMT

Have you ever modified your templates?

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 20:00:07 GMT

No I didn't. And its not happening with the data steps you provided.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 20:05:45 GMT

What can I do with my data about this issue?

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Reeza — Fri, 27 Sep 2019 20:33:18 GMT

Then it's a data issue of sorts. I would first try cleaning the data and removing any hard returns using COMPRESS().

data clean;
set old;

newVar = compress(oldVar, ,'s'); *note the two commas;

run;

proc freq data=clean;
table newVar;
run;

@Ruhi wrote:

No I didn't. And its not happening with the data steps you provided.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 20:59:36 GMT

This does not work either, I had already tried it.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

ballardw — Fri, 27 Sep 2019 21:00:18 GMT

Can you share the code you used to create the variable? And the exact proc freq code used to create the output?

Is there a specific reason that variable has a $19. Format assigned? And what was the format prior to you changing it? You don't show any values longer than what should be 9 or 10 characters so I'm not sure why the $19 was considered desirable.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 21:15:35 GMT

I added that format to data, based on how SAS read it from file. So remarks was the original column and I added compress and format to create the new variable remarknew as follows.

data full_sta;
set full;
	where motion_ = "No Motion";
	remarknew=input(upcase(compress(remarks,,'s')), $19.);
	case=input(compress(remarknew,' ',"d"), $19.);
	format remarknew $19. case $19.;
run;

proc freq data=full_sta;
table remarknew;
run;

Variables in Creation Order
#	Variable	Type	Len	Format	Informat
1	pt	Num	8	NLNUM12.	NLNUM32.
2	remarks	Char	19	$19.	$19.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Reeza — Fri, 27 Sep 2019 21:07:36 GMT

Show the code you tried.
Did you import the data from Excel?
Another method for debugging is to apply a hex format to your data and show us what that looks like.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 21:14:00 GMT

data full_sta;
set full;
where motion_ = "No Motion";
remarknew=input(upcase(compress(remarks,,'s')), $19.);
case=input(compress(remarknew,' ',"d"), $19.);
format remarknew $19. case $19.;
run;

I imported a csv file. I will try hex FORMAT.

Re: Whay proc freq ia aligning caterical varaible vertically rather than horizontally?

Ruhi — Fri, 27 Sep 2019 21:27:53 GMT

I dont know what changed but I saved an excel copy of my data and read and it worked fine now. Proc freq is giving me results the way I wanted now.

Thank you everyone for your help.