Hi, I have a vital signs data set with multiple rows per subject/visit/timepoint. I would like to collapse the data so there is one row per subject/visit/timepoint.   Have: SUBJECT VISIT TIMEPOINT  TEMP    SYSBP DIABP  101             C1        PRE                  1              .             . 101             C1        PRE                  .               21         43 101             C2       POST                .             2 5        46 102            C1        PRE                  1             22          32 102            C1       POST                .              56          . 102            C1       POST               2              .              25 102           C2       POST               5               55          54   Want: SUBJECT VISIT TIMEPOINT  TEMP    SYSBP DIABP  101             C1        PRE                 1               21         43 101             C2       POST                .             2 5        46 102            C1        PRE                  1             22          32 102            C1       POST                2           56           25 102           C2       POST               5             55          54   ... View more

Hi I would like to replace the following code with a prx function possibly prxmatch. Essentially I want to exclude any rows from a data set where a variable value has at least one bracket.   data work.&ds.; set work.&ds.; if index(&var.,"{")=0 and index(&var.,"}")=0 and index(&var.,"[")=0 and index(&var.,"]")=0 and index(&var.,"(")=0 and index(&var.,")")=0; run; ... View more

I have a task.   Import all tabs of an excel workbook (xlsx) into SAS. Tabs can be called anything and number of tabs is variable. I then need to read out all data sets to recreate the workbook as before, with tabs in their original order.   I have tried reading in excel files using libname statement with xlsx engine which reads them in ok, but does not enable the sheet order to be obtained. I tried using: proc sql & dictionary.columns sashelp.vtable proc contents but none of these methods help.     ... View more

Hi, I am creating a heat map in excel based on the "have" data set.   I would like to shade the "run" cells for each trial red if there is no "run" value for a trial. And shade cells green if there is at least one value for "run" within each trial.   So based on the data below, "trial" 002 would have all "run" values shaded red in excel. All other trials would have green "run" values in excel.   Thanks.   %let outfile=; /*add excel path here*/ filename _xlsx_ "&outfile."; data have; input trial : $3. environment : $4. run $1.; datalines; 001 PROD Y 001 TEST 002 TEST 002 PROD 003 PROD Y 004 TEST Y 004 PROD Y ; /*ODS excel start*/ ods excel file=_xlsx_ style=statistical; ods excel options(frozen_headers="1" autofilter="all" flow="table" sheet_name="Blueprint"); proc report data=have nowd; columns trial environment run; define trial / order; define environment / display; define run / display; run; /*ODS excel end*/ ods excel close; ... View more