Hello,   Please help me to set up macro to do 'proc npar1way' analysis. I have 20 variables in 'dicom_cat', and I would like to set up 'class' by selecting 1 variable from 'dicom_cat' each time for the analysis. So far, I've got SAS codes like these but it is not working... Please help me how I should set them up. Thank you very much! %macro KWloop(class= ); %let count=1; %do %until (%scan(&dicom_cat, &count)=); %let x=%scan(&dicom_cat, &count); proc npar1way data=&dsn; class &x; var &feature_vars; run; %let count=%eval(&count+1); %end; %mend KWloop; %KWloop (class=1); ... View more

Hello,   My dataset has 1000 columns (named 'Simulation1', 'Simulation2',------, 'Simulation1000'), and each column has 28 rows. I obtain the SAS code to calculate the product row for column 1 (Simulation1).  I would like to do the same calculation for each 1000 column. Please help me to set up those calculation. Thank you very much!   /* DATA step method to compute the product down the rows */ data want1; retain Prod 1 n 0; /* n = number of nonmissing */ set have end=EOF; if ^missing(Simulation1) then do; n + 1; Prod = Prod * Simulation1; end; if EOF then do; if n=0 then Prod=.; put n= / prod=; end; run;   ... View more