topic Re: Making histogram of the output that i got after running proc freq. in New SAS User

Making histogram of the output that i got after running proc freq.

hiteshchauhan1 — Tue, 28 May 2019 10:33:14 GMT

Can i make a histogram in sas of the data that i obtained after running proc freq.

below is the example:

proc freq data=A.testrun;
TABLE uncd;
run;

The output i got after running the code is in this form (only first two columns are relevant to me):

MNPBPNPSSNSSWS

58083	CD	58083	3.22
32952	ML	91035	5.04
148357	LO	239392	13.25
730125	CL	969517	53.68
480939	ZX	1450456	80.30
42497	VC	1492953	82.66
281371	AD	1774324	98.23
29846	RT	1804170	99.89
2036	GN	1806206	100.00

Now i want to make a histogram which has these values like GN,RT,AD,VC on the X-Axis and The numbers in first column on Y- axis The first column is actually the frequency. Can this be achieved?

Re: Making histogram of the output that i got after running proc freq.

PeterClemmensen — Tue, 28 May 2019 10:41:06 GMT

Yes it is possible. However, you don't have to use the PROC FREQ output to do so. you can simply use PROC SGPLOT directly on your data and do something like this

proc sgplot data=A.testrun;
   vbar uncd;
run;

Re: Making histogram of the output that i got after running proc freq.

hiteshchauhan1 — Tue, 28 May 2019 11:43:06 GMT

Thanks @PeterClemmensen working flawlessly.

Re: Making histogram of the output that i got after running proc freq.

PeterClemmensen — Tue, 28 May 2019 11:53:43 GMT

@hiteshchauhan1, Anytime, glad to help 🙂

Re: Making histogram of the output that i got after running proc freq.

hiteshchauhan1 — Tue, 28 May 2019 11:51:27 GMT

Hey @PeterClemmensen ,I think the output that i got is not a histogram and instead a bar chart. :

Re: Making histogram of the output that i got after running proc freq.

PeterClemmensen — Tue, 28 May 2019 11:56:05 GMT

I think you're right. You can use the Histogram Statement directly instead like this

proc sgplot data=A.testrun;
   histogram uncd;
run;

Use the PROC SGPLOT Histogram documentation to improve the plot to your liking 🙂

Re: Making histogram of the output that i got after running proc freq.

hiteshchauhan1 — Tue, 28 May 2019 11:58:20 GMT

Thanks @PeterClemmensen

Re: Making histogram of the output that i got after running proc freq.

PeterClemmensen — Tue, 28 May 2019 12:01:17 GMT

@hiteshchauhan1 Did this work for you? 🙂

If you want a more precise code answer, please post a part of your actual data

Re: Making histogram of the output that i got after running proc freq.

hiteshchauhan1 — Tue, 28 May 2019 12:09:13 GMT

The code is working but to create a histogram the data should be numeric and the variable that i am using does not have numeric values. So, not working in my case but nonetheless the code is fine.

Re: Making histogram of the output that i got after running proc freq.

PeterClemmensen — Tue, 28 May 2019 12:14:24 GMT

Ok. If you need help with variable type conversion, post an example of your data 🙂