topic Re: How To derive desired sub-column variable to dataset from proc freq result in SAS Programming

How To derive desired sub-column variable to dataset from proc freq result

sooryavasudevan — Wed, 21 Sep 2016 01:24:06 GMT

Hi,

I need to extract one or two sub-column form the proc freq results involving. if i use list in the code, it doesnot show the 'total' column values. so couldnot opt that too.

From the attached image, i would need the values of Cylinders with (4.6.8 and total) column values.

Code:

proc freq data=sashelp.cars;

tables make*cylinders / nopercent nocol;

run;

I have masked the percentage from display. But also, it will be helpful if one could teach me to take the percentage values to separate column values as dataset?

Do pls teach.!

TIA.

Re: How To derive desired sub-column variable to dataset from proc freq result

Reeza — Wed, 21 Sep 2016 03:00:20 GMT

Please detail what you want as your output. Is this supposed to be a dataset or an output like PROC FREQ?

@sooryavasudevan wrote:

if i use list in the code, it doesnot show the 'total' column values. so couldnot opt that too.

I have masked the percentage from display. But also, it will be helpful if one could teach me to take the percentage values to separate column values as dataset?

I don't know what the first sentence means. The second portion, I think you want to include percentage as output?

Also, please refer to the documentation, there are examples that highlight several things you may be interested in:

http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_freq_examples.htm

Re: How To derive desired sub-column variable to dataset from proc freq result

Ksharp — Wed, 21 Sep 2016 05:07:59 GMT


It is good for SQL.



proc sql;
select make,cylinders,count(*) as freq,
count(*)/(select count(*) from sashelp.cars where make=a.make) as per,
(select count(*) from sashelp.cars where make=a.make) as total
from sashelp.cars as a
 where cylinders in ( 4 6 8)
  group by make,cylinders;
run;

Re: How To derive desired sub-column variable to dataset from proc freq result

Shmuel — Wed, 21 Sep 2016 05:15:44 GMT

By selecting specific cylinders your total will be different from total before selection.

So, either you want:

proc freq data=sashelp.cars(where=(cylinders in (4 6 8)));

tables make*cylinders / nopercent nocol;

run;

or:

proc freq data=sashelp.cars;

output out=my_freq((where=(cylinders in (4 6 8)));

tables make*cylinders / nopercent nocol;

run;

Try both and look at results. Chosse whatever fits your expectations.

Re: How To derive desired sub-column variable to dataset from proc freq result

sooryavasudevan — Wed, 21 Sep 2016 12:20:52 GMT

Hi,

So, i want my output as a dataset. Output 3.1.2: Crosstabulation Table click on the link and go the table.

Lets consider that as my output. then i want my dataset to be in the attached format.

and i need a code solution for that. Couldnot extract specifically.

Re: How To derive desired sub-column variable to dataset from proc freq result

Shmuel — Wed, 21 Sep 2016 13:46:33 GMT

Is this what you are looking for ?

proc freq data=sashelp.cars(where=(cylinders in (4 6 8)));

tables make*cylinders / nopercent nocol;

output out = want;

run;

If not - where is the problem ?

Re: How To derive desired sub-column variable to dataset from proc freq result

sooryavasudevan — Thu, 22 Sep 2016 02:28:56 GMT

Thanks much 🙂

That helped. Just made little changes to get percentage values.

Re: How To derive desired sub-column variable to dataset from proc freq result

sooryavasudevan — Thu, 22 Sep 2016 02:43:39 GMT

Hi,

Ok, so it gave me the output but still in a list format. my desired result are categorical format. PFA

like a tabular form as i given below.

Make | 4 | 6 | 8 | Total | Percent.

I know proc freq may not be proper solution. Still couldnot separate the sub-category values and take as output.

Re: How To derive desired sub-column variable to dataset from proc freq result

Reeza — Thu, 22 Sep 2016 04:56:32 GMT

Unfortunately none of the procedures will generate a data set in that format. Use a proc transpose to get the format you want.