Thoughts of a Crime Show Junkie: Inadmissible Evidence
Recent Library Articles
Recently in the SAS Community Library: SAS' @RhondaWilliams reveals how SAS Law Enforcement Intelligence helps law enforcement agencies expedite detailed data entry using the Evidence Creation feature.
How to create a tabulated report based on data:
Column CATEGORY in H means a horizontal report. TITLE_LEVELS indicate how many levels of title there are. TITLE_LEVEL1 is the main header, TITLE_LEVEL2 is the sub-header of TITLE_LEVEL1, and TITLE_LEVEL3 is the sub-header of TITLE_LEVEL2.
All columns are Character data type
proc tabulate data=datset;
class TITLE_LEVEL1 TITLE_LEVEL2 TITLE_LEVEL3 Column1 ;
table TITLE_LEVEL1*
TITLE_LEVEL2*TITLE_LEVEL3;
run;
i have data
i want
PFA
... View more
Hi all,
At https://developer.sas.com/apis/rest/v3.5/#filters there is supposed to be a link that explains filter expressions:
For a complete description of filter expressions, see the Filtering reference.
However, when clicking this link (on the word "Filtering") I do not see any such page. It looks like this "got lost" during the switch to the new developers.sas.com web site.
Anyone knows where can I find the doc about API filter expressions?
... View more
Hi When dealing with SAS alerts, I make a description in notes before closing the alert. I always use the same sentence in the end like "Nothing suspicious found" Is there a way to make a shortcut to this text or like in word make an autotext? In stead of typing it in everytime, I would like to press fx "ALT+I"
... View more
I constructed a mmrm model as below: proc mixed data = have;
class id treatment week strata;
model chg = base treatment week treatment*week treatment*strata/ ddfm = KR;
repeated week/ subject = id type = UN;
lsmeans treatment*week/ cl alpha = 0.05 diff
ods output Tests3=tests3 lsmeans=lsmeans diffs=diffs;
run; (1) id: represents the patient id; (2) treatment: contains 2 group, "drug" and "placebo"; (3) chg: change from baseline of hba1c; (4) base: the value of hba1c at baseline; (5) week: contains 3 levels: "week8", "week16" and "week24" (6 )strata: stratification based on the median of baseline hba1c, ie group1=patients of those who have baseline hba1c <= median of baseline hba1c; group2=patients of those who have baseline hba1c > median of baseline hba1c. In general, I'd like to know how to the test the interaction between strata and treatment groups. I am not sure if I constructed the model in a right way because I looked at the results (as below), the values of Diffs in LS means were pretty close between strata, but p for interaction was significant. (The Diffs in LS means were got from the output file diffs, and the p for interaction were got from the output file test3.) I also checked the Diffs in LS means of week8 and week16, the diffs in LS means were all pretty close between 2 strata, but the p for interaction were all significant (p-value < 0.0001). So I am not sure if I interpret the result in the right way. What data should look quite different if the p for interaction is statistically significant? Thanks.
... View more
DATA ALT;
SET RCA.CLOSING_STATUS_TEST;
ARRAY COLS[*] _CHARACTER_;
ARRAY COLS_[*] _CHARACTER_;
DO I = 1 TO DIM(COLS);
IF MOD(I, 2) = 1 THEN
COLS_[(I+1)/2] = COLS[I];
END;
DROP I;
RUN;
Hi, I have been trying to select the alternate columns. If I am using this code then my third column's data shifts to second column and second's values are disappearing. I want to select alternate columns from my data set and my column names are in following: LOAN_NO, PRODUCT, FINAL_STATUS_05MAY24,DUE_N_TAG_05MAY24, FINAL_STATUS_06MAY24,DUE_N_TAG_06MAY24, FINAL_STATUS_07MAY24,DUE_N_TAG_07MAY24,... and so on. I want to create a table selecting columns:-
LOAN_NO, FINAL_STATUS_05MAY24, FINAL_STATUS_06MAY24, FINAL_STATUS_07MAY24... and so on. If there is any alternate approach for making the selection, please advise me or please help with the given array code.
... View more