topic Re: Proc Freq distribution issue in SAS Programming

Proc Freq distribution issue

tobyfarms — Wed, 18 Apr 2018 13:57:09 GMT

Hello, I am trying to create a proc freq that would produce the KWH (a numeric value) where the frequency counts are. Instead my KWH values are listed above as if they are headers.

ods graphics on;

proc freq data= work.sample_summary2;

tables nem_hud*kwh /nocol norow nopercent chisq;

output out=table1;

by profilecode2;

run;

ods graphics off;

Re: Proc Freq distribution issue

PaigeMiller — Wed, 18 Apr 2018 14:04:04 GMT

Your picture is just too small to be of any use in understanding what you want.

Can you fix that? Can you type in a (portion of) the table the way you would like it to be?

Re: Proc Freq distribution issue

PeterClemmensen — Wed, 18 Apr 2018 14:04:49 GMT

Can't see the picture 🙂

Re: Proc Freq distribution issue

tobyfarms — Wed, 18 Apr 2018 14:08:21 GMT

Table of NEM_HUD by KWH KWH(KWH) Total438 938 6278 7000 7559 8269 5452066 9549687 12876498 15214957NEM_HUD NEM FrequencyNon_NEM Frequency Total Frequency

1	1	1	1	1	1	0	0	0	0	6
0	0	0	1	1	0	1	1	1	1	6
1	1	1	2	2	1	1	1	1	1	12

profilecode2=NJAMP

Re: Proc Freq distribution issue

tobyfarms — Wed, 18 Apr 2018 14:13:21 GMT

Re: Proc Freq distribution issue

tobyfarms — Wed, 18 Apr 2018 14:18:00 GMT

ods graphics on;

proc freq data= work.sample_summary2;

tables nem_hud*kwh /nocol norow nopercent chisq;

output out=table1;

by profilecode2;

run;

ods graphics off;

Re: Proc Freq distribution issue

PaigeMiller — Wed, 18 Apr 2018 14:28:45 GMT

Now we can see the picture. Can you please type in an example of what you want the output to look like? Use the {i} box, or the running man icon when you do this.

Re: Proc Freq distribution issue

tobyfarms — Wed, 18 Apr 2018 14:48:51 GMT

I'm looking to summarize the variable "kwh" in the tables statement.  in the results I would like to see the kwh values where the counts are.


proc freq data= work.sample_summary2;
tables nem_hud*sum(kwh)  /nocol norow nopercent chisq;
output out=table1;
by profilecode2;
run;

Re: Proc Freq distribution issue

Reeza — Wed, 18 Apr 2018 14:52:30 GMT

tables nem_hud*kwh /nocol norow nopercent chisq LIST;

Try the LIST option.

@tobyfarms wrote:

ods graphics on;

proc freq data= work.sample_summary2;

tables nem_hud*kwh /nocol norow nopercent chisq;

output out=table1;

by profilecode2;

run;

ods graphics off;

Re: Proc Freq distribution issue

tobyfarms — Wed, 18 Apr 2018 15:25:30 GMT

@Reeza hello, I am still receiving the same result using the LIST option.

Re: Proc Freq distribution issue

Reeza — Wed, 18 Apr 2018 15:40:48 GMT

PROC FREQ only generates counts. If you want SUMs you need to use PROC MEANS instead.

Otherwise I think you need to show what you expect - as of now we're guessing.

Also, read your log. Your code as posted generates errors, so it has issues beyond what you're stating here.

proc freq data= work.sample_summary2;
tables nem_hud*sum(kwh)  /nocol norow nopercent chisq; <- no sum available here;
output out=table1;
by profilecode2;
run;