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.
Head over to our Hackathon Community page and read about the Hackathon Kick-Off on May 30th, and how you can register for being a part of the problem solvers of the world who get access to the latest SAS product releases on SAS Viya (among which SAS Intelligent Decisioning as well):
Hackathon Community Kick-Off Announcement
... View more
I write one macro which works fine to split data into 2-subgroups.
Logic is 1) sort by target var 2) based on weight/wt, split into 2 subgroups.
BUT how to split into N-Subgroups with N as a parameter, say N=3 or 7?!
%macro bisect(ds, byvar, cutvar, note);
proc sort data=&ds.; by &byvar.; run;quit;
data &ds.;
set &ds.;
retain wt_sum;
wt_sum=coalesce(wt_sum,0)+&cutvar.;
run;quit;
data &ds.(drop=wt_sum);
set &ds.;
if wt_sum<=50 then ¬e.=1;
else ¬e.=0;
run;quit;
%mend;
... View more
Hi guys,
suppose to have the following:
data DB;
input Code_1 :$20. Code_2 :$20. Code_3 :$20. Explanation_1 :$20. Explanation_2 :$20. Explanation_3 :$20.;
cards;
89.7 0 89.65 General_Visit 0 Monitor
0 89.61 0 0 Check 0
89.7 89.65 0 General_Visit Pressure 0
0 0 0 0 ECG 0
0 0 91.49.2 0 0 0
.....
;
Is there a way to get the frequency of each Code* with associated Explanation* for the entire data set? The frequency should be reported also if there is only the Code or only the Explanation. Overall the dataset has Codes from *_1 to *_82 and Explanation from *_1 to *_82.
Desired output:
data DB1;
input Code :$20. Explanation :$20. Freq :$20.;
cards;
Code Explanation Freq
89.7 General_Visit 2
89.65 Monitor 1
89.65 Pressure 1
89.61 Check 1
. ECG 1
91.49.2 . 1
run;
Thank you in advance
... View more
Is it possible to use SAS for annotating the CRF(case report form in Clinical Trials) ? If so, please assist on how to do it? Looking forward to your response. Thanks In advance
... View more
Hello
I created a new library name called PanelOsh
I used this code and I see that the folder was created successfully
options dlcreatedir;
libname PanelOsh "/usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/";
I want to create also sub-Folder within library PanelOsh that will be called Raw_Data.
What is the way to do it?
I run following code but the folder was not created
options dlcreatedir;
libname Raw_Data "/usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/PanelOsh";
... View more