Proc Freq distribution issue

[tobyfarms]

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;

[PaigeMiller]

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?

[PeterClemmensen]

Can't see the picture 🙂

[tobyfarms]

  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

[tobyfarms]

[tobyfarms]

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;

[PaigeMiller]

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.

[tobyfarms]

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;

[Reeza]

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;

---

[tobyfarms]

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

[Reeza · Accepted solution]

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;