topic Re: Adding row totals using the array statement in SAS Programming

Adding row totals using the array statement

UcheOkoro — Thu, 18 Feb 2021 16:29:11 GMT

Hello,

Please, I need help adding row totals using the array statement. The problem with my code is that where are missing observations, it reports it as 0 instead of missing.

I need help resolving this issue. Please, find below my codes

Data Demo_DOSS_HighRiskMed4;
Set Demo_DOSS_HighRiskMed;
   array DOSS_POS (*) $712 DOSS_POSITIVE1-DOSS_POSITIVE712 ( 0 1);
   x1=whichc(1, of DOSS_POS[*]);
   put x1=; 
run;

Thank you for your assistance.

Re: Adding row totals using the array statement

PaigeMiller — Thu, 18 Feb 2021 16:34:56 GMT

If "missing observations" means an observation where all variables have missing values, then all you have to do is test that beforehand.

Data Demo_DOSS_HighRiskMed4;
Set Demo_DOSS_HighRiskMed;
   array DOSS_POS (*) $712 DOSS_POSITIVE1-DOSS_POSITIVE712 ( 0 1);
   if n(of doss_pos[*])=0 then x1=.;
   else x1=whichc(1, of DOSS_POS[*]);
   put x1=; 
run;

Re: Adding row totals using the array statement

ballardw — Thu, 18 Feb 2021 17:27:15 GMT

@UcheOkoro wrote:

Hello,

Please, I need help adding row totals using the array statement. The problem with my code is that where are missing observations, it reports it as 0 instead of missing.

I need help resolving this issue. Please, find below my codes
Data Demo_DOSS_HighRiskMed4;
Set Demo_DOSS_HighRiskMed;
   array DOSS_POS (*) $712 DOSS_POSITIVE1-DOSS_POSITIVE712 ( 0 1);
   x1=whichc(1, of DOSS_POS[*]);
   put x1=; 
run;
Thank you for your assistance.

Please note that you have NO test for "missing". The documentation for WHICHC, and WHICHN clearly state that if the value is not found that the function returns zero for a value.

I bet you also have messages about "converting numeric to character" in your log. If the values are actually character 0 and 1 you should reference them as '0' and '1'.

Do you actually have 712 variables each of 712 character length?

If the variables you want to use already exist you do not need to provide a length or type.

array DOSS_POS (*) DOSS_POSITIVE1-DOSS_POSITIVE712 ;

Should work just fine.