topic Table help in proc iml in SAS/IML Software and Matrix Computations

Table help in proc iml

Tadeu1 — Fri, 28 Jan 2022 20:01:44 GMT

Dear,

I woud like criate a PESO variable string but I get an Error(1):

Also I woul like insert an new extra row like:

Carlos M 62 72 75

Thanks in advance

==================================================

proc iml;
tClass=TableCreateFromDataSet ("Sashelp", "Class");
call TablePrint(tClass);

Y=TableGetVarData (tClass, {"Weight" "Height"});
wt=Y[,1];
ht=Y[,2];
BMI=wt/ht##2 * 703;

if (BMI>=18.5) & (BMI<=24.9) then PESO="Normal";
if (BMI>=25.0) & (BMI<=29.9) then PESO="Sobrepeso";
if (BMI>=30.0) & (BMI<=39.9) then PESO="Obesidade";
if (BMI>=40.0) then PESO="Obesidade Grave";

quit;

call TableAddVar(tClass, "BMI", BMI);
call TableAddVar(tClass, "PESO", PESO);

Re: Table help in proc iml

Ksharp — Sat, 29 Jan 2022 05:45:59 GMT

Better post it at IML forum. and calling out @Rick_SAS

Re: Table help in proc iml

Rick_SAS — Sat, 29 Jan 2022 11:32:37 GMT

The reason your program is not working is that PESO must be a vector with the same number of elements as the BMI variable. There are two ways to do this:

1. Define a format and use the format to recode the BMI vector.

2. Use the BIN function in IML to classify each BMI value into a category.

The program below shows the second method:

proc iml;
tClass=TableCreateFromDataSet ("Sashelp", "Class");
*call TablePrint(tClass);

Y=TableGetVarData (tClass, {"Weight" "Height"});
wt=Y[,1];
ht=Y[,2];
BMI=wt/ht##2 * 703;

/* allocate vector that is the same length as the data */
catIdx = bin(BMI, cutpts);
/* set up cut points */
category = {'Abaixo do Peso' 'Normal' 'Sobrepeso' 'Obesidade' 'Obesidade Grave'};
cutpts = {.M               18.5     25           30          40               .I};
PESO = category[ catIdx ];

call TableAddVar(tClass, "BMI", BMI);
call TableAddVar(tClass, "PESO", PESO);
call TablePrint(tClass);