SAS Support Communities

So I have to do the exact same thing over and over again for multiple dataset, so I figured a macro might be helpful. This is the code I am trying to run. %macro lab (fich, num); data &fich; set &fich; if CRF&num=" " then CRF&num="MISSING"; %let &num=%eval(&num+1); if CRF&num=" " then CRF&num="MISSING"; run; %mend lab; %lab(temp,55); %lab(temp1,60); So basically, I have variables (CRF55, CRF56, CRF57..and so on) that I want it to insert the word "MISSING" when the character value is blank.  And then the same thing again for another dataset starting with var CRF60 (so this case will be CRF60, CRF61, CRF62 and so on). I have to do this for 4 varaibles per dataset and all in numerical order (e.g 55,56,57,58 and then another dataset for 60,61,62,63...etc.) Can someone suggests an easy way to do this without manually coding every dataset? The only other solution I can think of is create multiple datasteps and do the %let statement to change the num inbetween each datasets. but I feel there is a more efficient way to code this. %macro lab (fich, num); data &fich; set &fich; if CRF&num=" " then CRF&num="MISSING"; run; %let &num=%eval(&num+1); data &fich; set &fich; if CRF&num=" " then CRF&num="MISSING"; run; %mend lab; Thank you!!! ... View more

In my dataset from an actual clinical trial, I have 64 ID numbers (numbered 1 to 64), where 32 goes to treatment group A and 32 goes to treatment B and a score (outcome) So I want to add a hypothetical variable where I want to generate a variable (let's call it Gender/Sex, so 2 levels)  that is sex is evenly and randomly distributed within each group (16 males and 16 females per treatment group). How do I do this randomly? ... View more

Dataset ID Y X1 (Categorical) X2 (categorical) 1 85 2 1 2 156 4 5 3 78 1 8 4 456 3 9 1) I think by default, proc reg selects the lowest values as the reference variable right? In this case the reference value of X1/X2 will be 1.  If I were to run: Proc reg data=have; model y=x1 x2; run; 2) If I wanted the reference value to be 2 for the X1 variable, how do I do it? ... View more

So this is what I have right now proc format;   value namefmt 1="Experiment" 2="Control"; run; data have; input name  count; datalines; 1 16 2 8 ; run; data have; set have; format name namefmt.; run; data want; set have; wantvar=name||" (N="||count||")"; run; So in my want database, my wantvar is showing up as "1 (N=          16)", where I want it to actually show up as "Experiment (N=16)". How can I get it to show the formatted value and not the actual value without creating a new variable? ... View more

So I have this sample data format ID Block Value WANT 1 A -10 1 1 A 0 2 1 A 0.52 3 1 A 18 4 1 A 20 5 1 A 25 6 1 b -19 1 1 b 0.25 2 1 b 0.96 3 1 b 21 4 1 b 32 5 1 b 45 6 So I want to code a rank based on the values for each ID/block.  All patients have 12 records (6 for block A and 6 for block B). So I did the first step where I used proc sort by ID Block and Value. Now I want to create that WANT variable where it indicates the rank within each ID/Block. What is the easiest way to do this? Thanks! ... View more

So is there a way to make an array work outside of the data statement? So basically I have to run this: I have to run the following macro for 200 variables: %macro %somemacro(var); proc sgpanel data=dataset;   panelby  visit/rows=1 columns=3 spacing=5 novarname;      vbox &var / category=subgrp;   rowaxis values=(0 to 100 by 20);   run; %mend somemacro; The variables are not in numerical order so I can't do a regular do loop. For example a few variables: race, aduPH, BMI)... I thought an array would be helpful for this situation but I I think it is only for the data statement. SO I am wondering if there is a more efficient solution? This is what I have tried: array adu{*} race bmi aduPH aduFEEL aduVIEW aduSPORT; do i=1 to dim(adu);   %somemacro(adu(i)); end; ... View more