Macros

cpowell13 — Sun, 15 Jul 2018 23:53:57 GMT

Hello,

I am having difficultly achieving the following objective when given an excel data file. I have started the code below, but cannot produce an output.

Objective using Macros:

From each of the 5 clinics (inst_num) randomly select 5 AML patients, 10 CML patients, 20 ALL patients, and 5 CLL patients (leu_type). If there are less than 5 AML patients then select all of them, if there are less than 10 CML patients then select all of them, if there are less than 20 ALL patients then select all of them, and if there are 5 CLL patients then select all of them.

Then find cross-tabulation of Leu_type and inst_num. Additionally, print final dataset.

Re: Macros

PaigeMiller — Sun, 15 Jul 2018 23:52:35 GMT

Is this a homework assignment? Because this thread works on almost the exact same data and the exact same variable names.

https://communities.sas.com/t5/Base-SAS-Programming/How-to-filter-a-dataset-with-an-IF-condition/m-p/478211#M123291

But, you don't need macros to do this. Assign a random number to each group, sort and then take the top 5 (or top 10, or top 20) etc to randomly select.

topic Re: Macros in SAS Programming

Macros

Re: Macros