topic conditions on multiple variables in SAS Programming

conditions on multiple variables

cm3 — Thu, 14 Jan 2021 20:42:15 GMT

Hello,

I have data like below with different Item values

Item status_x status_y status_z

05 completed cancelled completed

05 cancelled completed

05 completed

05 completed completed completed

05 cancelled completed

05 cancelled completed completed

08 completed

- - - - - - - - - -

10 cancelled completed

- - - - - - - - - - - - -

I need counts of any one status completed, any two status completed and all 3 status completed by Item, like below table

Item 1statuscompleted 2statuscompleted 3statuscompleted nostatuscompleted

05 4 2 1 0

08 ----

10 -----

Appreciate your help.

TIA

Re: conditions on multiple variables

Reeza — Thu, 14 Jan 2021 21:13:21 GMT

I would do a PROC TRANSPOSE on your input table and then likely a PROC FREQ to get the summaries you want. Does it need to be dynamic or do you only need to consider 3 statuses at a time?

Re: conditions on multiple variables

Shmuel — Sun, 17 Jan 2021 06:32:00 GMT

Some clarification needed:

1) Is 1statuscompleted show the frequency of COMPLETED in status_x ?

or the first value of the item (excluding missing values), as in next example:

Item    status_x        status_y          status_z
08                      completed

2) Is nostatuscompleted frequency of CANCELED only or including missing values?

3) Do you need the output as a report or as a dataset?

Please check next code:

data temp;
 set have;
     array stat {3} $ status_x status_y status_z;
	 array frq {4} frq1-frq4;
	 do i=1 to dim(stat);
	    if stat(i) = 'completed' then j=i;
		else if not missing(stat(i)) then j=4;
		else j=0;
		if j then frq(j) = 1;
	 end;
	 keep item frq1-frq4;
run;
proc summary data=temp noprint nway;
     class item;
	 var frq1-frq4;
	 output out=want(drop _type_ _freq_) sum=;
run;
proc print data=want;
     var item frq1-frq4;
	 label
	    frq1 = "1statuscompleted"
		frq2 = "2statuscompleted"
		frq3 = "3statuscompleted"
		frq4 = "nostatuscompleted"
	 ;
run;

Re: conditions on multiple variables

cm3 — Thu, 14 Jan 2021 21:29:46 GMT

thanks for your help

1)any one of the Status value should be "completed"

other two status values could be "cancelled" or blank

2)none of the 3 status variables should have "completed"

3)need out put data set

Thanks again