topic Re: Doing a SAS procedure within an array in SAS Procedures

Doing a SAS procedure within an array

Melk — Tue, 25 Jun 2019 22:01:09 GMT

I have a really large dataset that looks like this:

ID A B C -- ZZ A_new B_new C-new -- ZZ_new

1 0 1 1 -- 1 1 1 0 0

I want to perform a test of agreement between all variables of the same name + the suffix

i.e.

proc freq data=dat;

table A*A_new / agree;

table B*B_new / agree;

run;

I dont think we can use an array to do a SAS procedure - but is there another way to do this without have to write down every variable name?

Re: Doing a SAS procedure within an array

Melk — Tue, 25 Jun 2019 22:03:55 GMT

Another importnat thing to note is that I only really care about p-values for the kappa statistics right now. Ideally, I could output to a dataset and then sort by p-value to get the variables that are significant.

Re: Doing a SAS procedure within an array

Reeza — Tue, 25 Jun 2019 22:08:11 GMT

I would recommend transposing your data so you can use a BY statement instead.

Re: Doing a SAS procedure within an array

Melk — Tue, 25 Jun 2019 22:25:12 GMT

so I converted to longitudinal, extra vairable being new = 1 or 0. Buy how do a get a kappa statistic with a by statement?

Re: Doing a SAS procedure within an array

Melk — Tue, 25 Jun 2019 23:29:32 GMT

So what I did was concatenate the text to trigger the macro for all the variables in my data:

proc sql;
select cat('%mymacro(',name, ',', cats(name, '_new' ),')') into :renstr separated by ' ' from
dictionary.columns where libname = 'WORK' and memname='DATA';
quit;

Then I just copied and pasted the result into my SAS code....

Re: Doing a SAS procedure within an array

Reeza — Wed, 26 Jun 2019 00:39:18 GMT

Or add CALL EXECUTE which would just call the string so you don't have to copy it and run it manually

Re: Doing a SAS procedure within an array

Reeza — Wed, 26 Jun 2019 00:46:10 GMT

I would structure my data as:

ID Code Old New
1 A 1 1
1 B 0 1

etc then do:

proc freq data=have;
by code;
table old*new / agree ;
run;