Create a macro list after Proc Freq?

ybz12003 — Fri, 28 Jun 2024 19:06:55 GMT

Hello,

I have a proc freq program list below. I would like to create a macro list for the LabIDs, the percentage of which is over 5%. Is there a way to do so? Thanks.

proc freq data=sample;
table LabIDs*test_order_codes*test_result_codes / list missing;
run;

Re: Create a macro list after Proc Freq?

ballardw — Fri, 28 Jun 2024 19:17:00 GMT

I strongly suggest providing an example data set and then show us which of the percentages that will appear in Lab_id that you are asking about.

Here is an example of creating a data set with the output percentages that you should be able to run to see what I mean:

proc freq data=sashelp.cars ;
  table origin*make*type/out=work.percent outpct ;
run;

Then it may be time to discuss how you intend to use that list of variables. it may be better to generate a data set(hint: likely needed for the macro approach) and use the values in the data set.

topic Re: Create a macro list after Proc Freq? in SAS Programming

Create a macro list after Proc Freq?

Re: Create a macro list after Proc Freq?