topic Re: histogram and qqplot side by side using proc univarriate not working as it should in SAS Programming

histogram and qqplot side by side using proc univarriate not working as it should

brook2 — Sun, 17 Feb 2019 20:15:02 GMT

*** Not spam !!!!! real programming question ** Thanks

I have data (2584 record) with three columns ( subject , Education level as Educ and income during 2005 as Income2005) and a category of five types under education level ( =12, 13-15 , 16, <12, >16) this is a bucket that contains income for each education distribution at Income2005 column . I want to draw Histogram and QQ plot of income 2005 distro side by side for each educ level . why this code is not working ? Thanks

proc import datafile='/folders/myfolders/ex0525.csv'
DBMS=csv out=IncomeData replace;
run;
proc print data=IncomeData; 
run;

proc univariate data = incomedata;
 class Educ;
 var income2005;
 run;
 
** the above code works fine but the below code doesn't plot the 5 histograms and 5 QQ plots  of Income 2005 distribution for each Educ category 
it just spits out Descriptive stat as Educ= 12 , ( there is no error but unneeded output) 

proc univariate data = incomedata;
by Educ;
histogram income2005; 
qqplot income2005; 
run;

Re: histogram and qqplot side by side using proc univarriate not working as it should

PGStats — Sun, 17 Feb 2019 21:35:37 GMT

Note that PROC UNIVARIATE uses the formatted values of the CLASS variables to determine the classification levels, but uses the internal values for BY processing. Problems related to this difference typically generate errors in the SAS log.

Re: histogram and qqplot side by side using proc univarriate not working as it should

brook2 — Mon, 18 Feb 2019 01:40:43 GMT

There is no error generated , it just gives result ( descriptive stat) for the code shown. I want to generate histogram and qq plot side by side. I am expecting a result set showing all his and QQ under each category of Educ ( <12 yrs ,12yrs , 13-15 yrs , 16 yrs , >16 yrs ).Can you help me with a working solution using the code or any other way as an example.Thanks

Re: histogram and qqplot side by side using proc univarriate not working as it should

PGStats — Mon, 18 Feb 2019 04:00:25 GMT

Here is an example that works for me:

proc sort data=sashelp.heart out=sortedHeart; by smoking_status; run;

ods pdf file="Brook2_example.pdf";
proc univariate data = sortedHeart noprint;
where smoking_status is not missing;
by smoking_status;
histogram cholesterol; 
qqplot cholesterol; 
run;
ods pdf close;

Result pdf attached.

Re: histogram and qqplot side by side using proc univarriate not working as it should

brook2 — Tue, 19 Feb 2019 01:10:47 GMT

@PGStats Thanks for your time and help . But I am still missing three categories for Educ <12 , Educ 13-15 Educ >16 catagory , it is only giving me Educ =12 and Educ =16 , looks like it is not taking the less than or greater than or in between values

I reused the code you posted below ,here is the result

Re: histogram and qqplot side by side using proc univarriate not working as it should

brook2 — Tue, 19 Feb 2019 01:23:51 GMT

For some reason I cant copy paste my actual code like u did , but I have attached the result set in pdf in the next thread.
I cant even add the screen shot of the code and attache it as image file !! little weird ! but I have exactly replicated your code!! thanks