topic Re: Creating a dummy variable based on several different variables with a DO-LOOP in SAS Programming

Creating a dummy variable based on several different variables with a DO-LOOP

kmardinian — Mon, 27 Aug 2018 20:06:35 GMT

Hi, I have a pretty dense dataset that I would like to organize so I can run proc univariate or proc freq reports on it.

I would like to the first report to find the number of reads (obs) per machine per Mode. And the second report to find the number of reads per Machine per Mode per Study. So I would like to try to create a dummy variable to make that easier, I put two columns to show what I think the dummy variables should look like, but I am not sure whether this is the best way. Any advice is much appreciated!

A sample of the dataset is below:

Mode Study Machine Dummy1?? Dummy2??

EN A M1 EN-M1 EN-M1-A

EN A M2 EN-M2 EN-M1-A

EN B M1 EN-M1 EN-M1-B

HIS A M3 HIS-M3 HIS-M3-A

HIS C M3 HIS-M3 HIS-M3-C

HIS C M2 HIS-M2 HIS-M3-C

MR B M1 MR-M1 MR-M1-B

MR D M2 MR-M2 MR-M2-D

MR D M3 MR-M3 MR-M3-D

Re: Creating a dummy variable based on several different variables with a DO-LOOP

PaigeMiller — Mon, 27 Aug 2018 20:09:38 GMT

None of this is necessary, nor is it a good idea.

PROC FREQ does all of this, without any dummy variables at all.

Re: Creating a dummy variable based on several different variables with a DO-LOOP

Reeza — Mon, 27 Aug 2018 20:12:45 GMT

Not sure why you need dummy variables. See the want/want2 data set or output from the following. The LIST option tells SAS to arrange it in a list rather than cross tab.

proc freq data=have /*noprint*/;
table mode*machine / list out=want1;
table mode*machine*study/ list out=want2;
run;

Re: Creating a dummy variable based on several different variables with a DO-LOOP

Reeza — Mon, 27 Aug 2018 20:14:54 GMT

If you really want the dummy variables, use CATX().

Dummy1 = CATX('-', Mode, Machine);

Re: Creating a dummy variable based on several different variables with a DO-LOOP

kmardinian — Mon, 27 Aug 2018 20:19:15 GMT

Hi Reeza,

I see, that makes more sense. Is it possible to then export this into an excel file so that it looks like a nice report with Proc Freq?

Re: Creating a dummy variable based on several different variables with a DO-LOOP

Reeza — Mon, 27 Aug 2018 20:24:16 GMT

Depends on what you mean by 'nice report' but it's definitely possible. The results are also in data sets want1, want2.

You could wrap the code in ODS EXCEL and see how that works:

I find tabulate easier to control though.

ods excel file='/folders/myfolders/demo.xlsx';

{code from previous post};

{OR proc tabulate code};

ods excel close;

Re: Creating a dummy variable based on several different variables with a DO-LOOP

kmardinian — Mon, 27 Aug 2018 20:28:27 GMT

Thank you, Reeza! I am going to go ahead and try that now