Hello,   I need to randomly match people from 2 lists, on a 1:1 basis.  One list contains mentors and one list contains mentees.     I know I can use proc surveyselect for randomization, however there is some criteria that I don't know how to incorporate:   1) Mentees must have a lower Level than their mentor 2) Mentees must not have the same subfunction as their mentor.    Does anyone have any ideas how to do this?  Sample data is attached.   Thank you in advance!!   ... View more

Hi everyone!   I was wondering if anyone has an idea that can help me with this issue I'm having.  I have a proc report statement that will write out a dataset that will vary in the number of columns each time.  I've figured out how to accommodate this for the Columns statement, but not for the define statement.  Any ideas or guidance that you can share with me?   Here is what I have now.  The dayvrs2 macro variable holds the number of columns that need to be addressed.  I haven't figured out a way to dynamically write out the Define statements, so I'm having to check each time I run the program and manually type all the Define statements.     proc report data=cm_combined nowd headline headskip spacing=3 split='|' missing ls=250 ps=42 ;   column      %macro columns;           %do i = 1 %to &dayvars2;                day&i._flag           %end;      %mend columns;      %columns      _all_ ; define cutoff / noprint; Define day1_flag / noprint; Define day2_flag / noprint; Define day3_flag / noprint; Define day4_flag / noprint; Define day5_flag / noprint; Define day6_flag / noprint; Define day7_flag / noprint; Define day8_flag / noprint; .... Define day90_flag / noprint; /* Color coding */ %macro colors; %do i = 1 %to &dayvars2; COMPUTE day&i; if day&i._flag.sum = 1 then do; call define(_col_,'style','style={background=lightyellow}'); end; ENDCOMP; %end; %mend colors; %colors; run;       Thanks! ... View more

Hi everyone,   I have been struggling with this for a couple days, so hope somebody out there has done this before.    I have a dataset that is currently vertical, and I want to transpose it to be horizontal.  That's no problem with PROC TRANSPOSE.  The tricky part is that after the data is transposed, I need to assign labels to the new variables from a field that existed in the initial data.     Currently I have something like this: variable_name       field_label INV                         Physician INST                       Institution   I have transposed the dataset to this: INV      INST Dr Joe  Hospital1 Dr Jane Hospital2   What I am not sure how to do is assign the values from field_label to the INV and INST variables after the transpose.    I have 397 rows in the intial dataset, and it can change in the future, so I really want to be able to do this dynamically.   Any suggestions?    Thanks! ... View more