Hi All,
I have a dataset like below
Characteristics | G1 | G2 | OVERALL | ord |
|
|
|
| 2 |
N | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 2 |
Mean(SD) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 2 |
Q2(Q1 Q3) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 2 |
|
|
|
| 5 |
N | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 5 |
Mean(SD) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 5 |
Q2(Q1 Q3) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 5 |
|
|
|
| 1 |
N | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 1 |
Mean(SD) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 1 |
Q2(Q1 Q3) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 1 |
|
|
|
| 3 |
N | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 3 |
Mean(SD) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 3 |
Q2(Q1 Q3) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | xx.xx(xx.xx%) | 3 |
|
|
|
|
|
Where characteristics rows are blank i would like to put values like age, weight , height ...etc since the table is very big(80 rows). All the results are coming from inidvidual datasets which i have used a set statement like below
Data d;
set OUTPUT_: ; /*here OUTPUT_: is written to get all the data sets sequentially due to the prefix name "OUTPUT_" is common to all.
run;
Kindly share your ideas how this can be done with macro since i have 22 values to fill in to those blank spaces with age,height,weight ...etc. in a sequential manner.
I'm thinking to assign all the variables in a %let statement and then passing them in to the loop , but don't know how exactly this can be done with the help of a do loop. If any thoughts around this , it will be very helpful.
Cheers,
Ram
Would something like this work?
%LET charnam=Age (years)$Weight (kg)$Height (cm)$BMI (kg/m^2);
DATA want;
SET have;
DO i=1 TO 4;
IF ord=i and characteristics="" THEN characteristics=scan("&charnam", i, "$");
END;
RUN;
You would of course have to make sure the order in the let statement matches the ord var numbering.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.