topic Re: After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset? in SAS/IML Software and Matrix Computations

After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset?

agille05 — Mon, 09 May 2022 21:43:09 GMT

Hi all,

First name here and in need of some assistance. I have a dataset that looks something like the following:

Q4 Q5_1 Q5_2 Q5_3

1 1 1 2

2 1 1 1

1 1 0 2

5 2 1 2

The values within the Q5_1, Q5_2, and Q5_3 columns are of the same type and I am looking to determine the frequency of the responses across the entire matrix (Q4 is a participant type). I have been able to develop an IML code to produce an output table for just one of the participant types as below.

PROC IML;
   Use Data.Have;
   Read all var{Q5_1 Q5_2 Q5_3} where (Q4 = 1) into x;
Close;
Call tabulate(level,freq,x,);
Print (level`)[l='level'] (freq`)[l='freq'];
Quit;

This generates an output table that looks like the following:

level freq

0	151
1	1399
2	206

What I am wondering is if it is possible to save this output table as a new dataset after using the Call Tabulate function?

Appreciate any and all suggestions and thank you!

Re: After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset?

Ksharp — Tue, 10 May 2022 03:47:51 GMT

Yes. you could. but you have to post it at IML forum.

https://communities.sas.com/t5/SAS-IML-Software-and-Matrix/bd-p/sas_iml

data have;
input Q4 Q5_1 Q5_2 Q5_3;
cards;
 1        1       1       2
 2        1       1       1
 1        1       0       2
 5        2       1       2
;

PROC IML;
   Use Have;
   Read all var{Q5_1 Q5_2 Q5_3} where (Q4 = 1) into x;
Close;
Call tabulate(level,freq,x,);

create want var{level freq};
append ;
close;
Quit;

Re: After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset?

agille05 — Tue, 10 May 2022 12:41:13 GMT

Will do! Thank you 🙂

After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset?

agille05 — Tue, 10 May 2022 12:48:08 GMT

Hi all,

First name here and in need of some assistance. I have a dataset that looks something like the following:

Q4 Q5_1 Q5_2 Q5_3

1 1 1 2

2 1 1 1

1 1 0 2

5 2 1 2

PROC IML;
   Use Data.Have;
   Read all var{Q5_1 Q5_2 Q5_3} where (Q4 = 1) into x;
Close;
Call tabulate(level,freq,x,);

Print (level`)[l='level'] (freq`)[l='freq'];

Quit;

This generates an output table that looks like the following:

level freq

0	151
1	1399
2	206

What I am wondering is if it is possible to save this output table as a new dataset after using the Call Tabulate function?

Appreciate any and all suggestions! Thank you 🙂

Re: After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset?

Rick_SAS — Tue, 10 May 2022 12:53:37 GMT

KSharp has already answered your question. See the end of his program.

Re: After Call Tabulate in Proc IML, Am I Able to Save the Output Table as a New Dataset?

agille05 — Tue, 10 May 2022 13:10:14 GMT

Oh I see it now! Thank you 🙂