Home

Ninja_turtle

Hi All, I am new to the ods and SAS and need to create a complex( attached )cover page. Can you please help how can I create it and export to xlxs with other tabs already present in the sheet? if we can't push with other sheets in workbook can we at least create a separate xlxs for this? Need help how we can create it in sas!! Thanks, NinJa

JeffMeyers · ‎03-23-2019

The field of clinical research often involves transferring data to and receiving from other research organizations, and this leads to the need for an app or program that can quickly summarize multiple datasets in a streamlined format. The CONTENTS procedure can give a quick summary of the variables contained within one or more datasets, but does not give any information about the values contained within those variables. The DATA_SPECS macro was developed to not only show the important metadata of the datasets within a library, but also gives distribution information that changes depending on the variable type. The macro also checks for variables that exist in multiple datasets which is important to determine if information potentially changes from one dataset to another. The DATA_SPECS macro then outputs all of this information into an EXCEL document using the Output Delivery System (ODS) EXCEL destination to give a streamlined report.

TomC4188

Given the following Oracle proxy user grant alter user service-account-name grant connect through personal-account-name; how might one establish a connection to an Oracle database using "personal-account-name[service-account-name]" as the user name in SAS? I don't have access to SAS myself but I work with people who do which makes it difficult for me to diagnose issues with Oracle proxy user access from within SAS. The only person I worked with so far could not get it to work. So I am trying to understand if SAS is capable of seeing and using the "[service-account-name]" clause in the user name field. I think the following is a valid example. proc sql; connect to oracle as myconn (USER='personal-account-name[service-account-name]' PASSWORD='personal-account-password' PATH='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WhateverHost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=WhateverServiceName)))'); select * from connection to myconn (select sys_context('USERENV','PROXY_USER') PROXY_USER, sys_context('USERENV','SESSION_USER') SESSION_USER from dual); disconnect from myconn; quit; Thank you.

pdick2

Hello again! I have a long dataset from the "Early Prediction of Sepsis from Clinical Data: the PhysioNet/Computing in Cardiology Challenge 2019" This has over 1.5 million rows of hourly data, with over 40,000 unique Patient_IDs. There are many variable (such as Hour, HR, Resp, O2Sat, various lab values , etc.) by one outcome variable (SepsisLabel. 0 for no sepsis, 1 for sepsis). I now have the dataset where SepsisLabel changes from 0 to 1, while excluding those who are only SepsisLabel=0 and excluding those who are only SepsisLabel=1. Now I want to do some other things to the data. I want to take the time difference between when sepsislabel changes from 0 to 1 before onset. Here is an example dataset. I've been using ChatGPT to help, but it doesn't seem to understand what I want. I kinda got the code it gave me to work with the time difference AFTER sepsislabel changes from 0 to 1, but not before. Before it gives me missing values. Code below and an example dataset for Patient_ID=34. data have; input Hour HR Temp SepsisLabel Patient_ID onset_time TimeDifference; datalines; 0 88 36.11 0 34 . . 1 88 36.17 0 34 . . 2 88 . 0 34 . . 3 83.5 . 1 34 3 0 4 80 . 1 34 3 1 5 88 36.5 1 34 3 2 6 91 . 1 34 3 3 7 88 . 1 34 3 4 8 80 . 1 34 3 5 9 80 . 1 34 3 6 10 80 . 1 34 3 7 11 82 . 1 34 3 8 12 77 . 1 34 3 9 ; data biosp.sepsis_0_to_1_time_diff; set biosp.sepsis_0_to_1; by Patient_ID; retain onset_time; if first.Patient_ID then onset_time =.; *Initialize the onset time for each unique patient_ID; if sepsislabel=1 and onset_time=. then onset_time=Hour; *Records when sepsislabel changes to 1; if not missing(onset_time) then TimeDifference = Hour - onset_time; /* Calculate time difference */ else TimeDifference=.; run; Please help me with this. Something else I want to do is get the mean, median, mode, q1, q3, min, and max for certain variables (such as HR, Resp, Temp., etc.) at certain time intervals before sepsislabel changes from 0 to 1. I was going to look at t=-4 hours, t=-6 hours, and t=-12 hours. This will single out this long data into 1 row per 1 patient_ID (instead of 11 rows, or 100 rows in some instances for one patient), but the rows will have the mean, median, etc. for those variables of interest (HR, Temp., etc.). This will create many datasheets (1 datasheet for mean values, 1 for median, 1 for q1, etc.), but this can be more usable in a logistic analysis in my opinion. Can anyone help me with this please? Thank you!!!