I am using the proc glimmix procedure with ODS OUTPUT statement. I am puzzled by the error I received when trying to output estimates for random effects. Has anyone encountered this issue? PROC GLIMMIX DATA=BSHP /*NOCLPRINT*/ MAXLMMUPDATE=100; CLASS H_S_ID AGE_GRP PRIOR_CSECTION ADMIT_WEEKDAY RACE_DESC &comorbidities.; ODS OUTPUT SOLUTIONR=R; MODEL COMPOSITE_COMPLICATION(event="1") = AGE_GRP PRIOR_CSECTION ADMIT_WEEKDAY RACE_DESC &comorbidities./D=B LINK=LOGIT SOLUTION; RANDOM INTERCEPT/SUBJECT=H_S_ID; RANDOM _RESIDUAL_; OUTPUT OUT=PRED_1     PRED(BLUP ILINK)=PREDPROB PRED(NOBLUP ILINK)=EXPPROB; NLOPTIONS TECH=NRRIDG; run; WARNING: Output 'SOLUTIONR' was not created.  Make sure that the output object name, label, or          path is spelled correctly.  Also, verify that the appropriate procedure options are          used to produce the requested output object.  For example, verify that the NOPRINT          option is not used. Best, Mike ... View more

Community - I am having difficulty troubleshooting an issue. I have two macros below. The second macro callbreak(), looks at a data set, and at each first.ID it calls the break macro. The break() macro creates a new data set selecting obs from the original data for that ID. So simply, it is creating a data set for each new unique ID. Break() then saves a macro description from a value in the data set so it can be used to name an Excel file. In the final step, the break() macro exports the new data set into Excel. The problem is, in the file path, &grpdesc. does not update. So all Excel reports have the same name and just overwrite one another. I was able to validate that the grpdesc macro is updating with each macro run. It just doesn't update in the file path. Any ideas? %macro break(byval, tblnm, report);    data &report&byval;                                                                  set &tblnm.(where=(uniqid= "&byval"));    run;    /*get group name for workbook*/ PROC SQL noprint; SELECT DISTINCT description into :grpdesc FROM &report&byval ; QUIT; PROC EXPORT DATA= &report&byval      OUTFILE= "C:\Documents and Settings\mmangi01\Desktop\dump\&grpdesc. report.xlsx"      DBMS=EXCEL REPLACE;      SHEET=&report; RUN; %mend;                                                                              %macro callbreak(tblnm, report); data _null_ ;                                                                 set &tblnm.;                                                                by uniqid;                                                                   if first.uniqid then     call execute( '%break('||uniqid||', &tblnm, &report )' );                         run; %mend callbreak; %callbreak(Be_pct2, be); ... View more

I would like to use Proc Glimmix to compare the difference in hospital effects between each hospital in my study and the average. So basically I want to look at each Hospital (42 in total) and compare them with the average. Using the SAS documentation and a couple of online searches I have been able to get my code (simplified) to what is pasted below. This gives me the OR and CL for one hospital. What I am uncertain of is how to be sure which hospital I am analyzing. In the example below, which hospital is HOSPITAL 41? And if I change it to 40, which is 40? How can I get SAS to include the Hospital ID in the output so I am absolutely sure which hospital is being reported on? Alternatively, how could I set this approach up to step through each Hospital and give me my results? Code: proc glimmix data = Analysis_vaginal_final; class HOSPITAL; model Y(event="1") = X    / dist=BINARY link=LOGIT ddfm=BW solution; random HOSPITAL / solution;    estimate 'HOSPITAL1 vs Avg' | HOSPITAL    41 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1         -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1         -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1         -1 -1 -1 -1 -1 / divisor=42 df=41 OR CL; run; Desired Output: HOSPITAL Relative Risk P-Value 01 1.01 0.27 02 0.75 0.81 03 1.55 0.04 … … … ... View more

I am looking for a solution to collapse claims into a single row by claim number and in need of assistance. Have: CLAIM_NUM ER_ENC_DATE CT_SCAN_DATE ER_FLAG HEAD_INJ_FLAG CT_SCAN_FLAG CT_SCAN_COST 1 . . 0 1 0 0 1 . 01/01/2014 0 0 1 $200 1 01/01/2014 . 1 0 0 0 2 . . 0 1 0 0 2 . 01/06/2014 0 0 1 $100 2 01/04/2014 . 1 0 0 0 3 . . 0 1 0 0 3 . . 0 0 0 0 3 01/10/2014 . 1 0 0 0 4 . 0 0 0 0 4 . 0 0 0 0 4 01/10/2014 . 1 0 0 0 Want: CLAIM_NUM ER_ENC_DATE CT_SCAN_DATE ER_FLAG HEAD_INJ_FLAG CT_SCAN_FLAG CT_SCAN_COST 1 01/01/2014 01/01/2014 1 1 1 $200 2 01/04/2014 01/06/2014 1 1 1 $100 3 01/10/2014 . 1 1 0 0 4 01/10/2014 . 1 0 0 0 ... View more

Hello, I have a variable that is formatted $3. Within this variable there is a value '  .' which was causing me some confusion. Initially I thought '.' was the null value for numeric, not character. However it seems this value has 2 spaces in front of it, hence '  .' , which lead me to believe it was a character Also, when I enter the following tests: if variable = '  .'; if variable =.; Both return true. Please help me to understand what this value is that I have here. What is a practical approach from a data hygiene perspective for cleaning this? How is a character variable identified as being equal to both a character value and a numeric value at the same time? Best regards, Mike ... View more