Recently in the SAS Community Library: SAS' @BethEbersole reveals 4 steps to stop money laundering, solve law-enforcement cases, find missing children and more with SAS Visual Investigator.
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