cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
psusudzi92
‎09-01-2015
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Lesion diameter summary check

by Calcite | Level 5 in SAS Enterprise Guide
‎03-17-2010 10:01 AM
‎03-17-2010 10:01 AM
Thanks Scott, your input is appreciated! John ... View more

Re: Lesion diameter summary check

by Calcite | Level 5 in SAS Enterprise Guide
‎03-16-2010 05:15 PM
‎03-16-2010 05:15 PM
The baseline sum exists in the LDSUM variable in the SASUSER.QUERY_FOR_LS_SAS7BDAT_0006 dataset. All of the sums exist in the LDSUM variable and would be distinguished from each other by the date variable. As for the current program I posted, it runs fine and produces valid output, as posted below. I get lots of 0's that are irrelevant but I can ignore them. SUBJID LSVIS LSVISCD LSNUM LSSITE LSDESC LSDTN LSMTD LSDIA LSDIAU LDSUM MINLDSUM LDSUMCHG 001-001 PRE-STUDY 1 1 LUNG LEFT UPPER LOBE 06Jul2008 SPIRAL CT 11 cm 23.2 23.2 001-001 PRE-STUDY 1 2 LYMPH NODE LEFT AXILLA 06Jul2008 SPIRAL CT 2.3 cm 23.2 23.2 0.000 001-001 PRE-STUDY 1 3 LYMPH NODE PRE-VASCULAR 06Jul2008 SPIRAL CT 2.9 cm 23.2 23.2 0.000 001-001 PRE-STUDY 1 4 LYMPH NODE AORTICOPULMONARY 06Jul2008 SPIRAL CT 2.7 cm 23.2 23.2 0.000 001-001 PRE-STUDY 1 5 LYMPH NODE AORTICOPULMONARY #2 06Jul2008 SPIRAL CT 3.1 cm 23.2 23.2 0.000 001-001 PRE-STUDY 1 6 LYMPH NODE PRE-CARINAL 06Jul2008 SPIRAL CT 1.2 cm 23.2 23.2 0.000 001-001 CYCLE 2 2 1 LUNG LEFT UPPER LOBE 19Aug2008 SPIRAL CT 5.5 cm 13 13 -0.440 001-001 CYCLE 2 2 2 LYMPH NODE LEFT AXILLA 19Aug2008 SPIRAL CT 0.9 cm 13 13 0.000 001-001 CYCLE 2 2 3 LYMPH NODE PRE-VASCULAR 19Aug2008 SPIRAL CT 2.3 cm 13 13 0.000 001-001 CYCLE 2 2 4 LYMPH NODE ARTICOPULMONARY 19Aug2008 SPIRAL CT 1.9 cm 13 13 0.000 001-001 CYCLE 2 2 5 LYMPH NODE AORTICOPULMONARY #2 19Aug2008 SPIRAL CT 1.5 cm 13 13 0.000 001-001 CYCLE 2 2 6 LYMPH NODE PRE-CARNIAL 19Aug2008 SPIRAL CT 0.9 cm 13 13 0.000 001-001 CYCLE 4 3 1 LUNG LEFT UPPER LOBE 02Oct2008 SPIRAL CT 4.1 cm 8.6 8.6 -0.338 001-001 CYCLE 4 3 2 LYMPH NODE LEFT AXILLA 02Oct2008 SPIRAL CT 0 cm 8.6 8.6 0.000 001-001 CYCLE 4 3 3 LYMPH NODE PRE-VASCULAR 02Oct2008 SPIRAL CT 1.3 cm 8.6 8.6 0.000 001-001 CYCLE 4 3 4 LYMPH NODE AORTICOPULMONARY 02Oct2008 SPIRAL CT 1.4 cm 8.6 8.6 0.000 001-001 CYCLE 4 3 5 LYMPH NODE AORTICOPULMONARY #2 02Oct2008 SPIRAL CT 1 cm 8.6 8.6 0.000 001-001 CYCLE 4 3 6 LYMPH NODE PRE-CARINAL 02Oct2008 SPIRAL CT 0.8 cm 8.6 8.6 0.000 001-001 CYCLE 6 4 1 LUNG LEFT UPPER LOBE 18Nov2008 SPIRAL CT 3.2 cm 7.6 7.6 -0.116 001-001 CYCLE 6 4 2 LYMPH NODE LEFT AXILLA 18Nov2008 SPIRAL CT 0 cm 7.6 7.6 0.000 001-001 CYCLE 6 4 3 LYMPH NODE PRE-VASCULAR 18Nov2008 SPIRAL CT 1.3 cm 7.6 7.6 0.000 001-001 CYCLE 6 4 4 LYMPH NODE AORTICOPULMONARY 18Nov2008 SPIRAL CT 1.5 cm 7.6 7.6 0.000 001-001 CYCLE 6 4 5 LYMPH NODE AORTICOPULMONARY #2 18Nov2008 SPIRAL CT 0.8 cm 7.6 7.6 0.000 001-001 CYCLE 6 4 6 LYMPH NODE PRE-CARINAL 18Nov2008 SPIRAL CT 0.8 cm 7.6 7.6 0.000 001-001 CYCLE 9 7 1 LUNG LEFT UPPER LOBE 18Mar2009 SPIRAL CT 2.6 cm 4.8 4.8 -0.368 001-001 CYCLE 9 7 2 LYMPH NODE LEFT AXILLA 18Mar2009 SPIRAL CT 0 cm 4.8 4.8 0.000 001-001 CYCLE 9 7 3 LYMPH NODE PRE-VASCULAR 18Mar2009 SPIRAL CT 0 cm 4.8 4.8 0.000 001-001 CYCLE 9 7 4 LYMPH NODE AORTIOCOPULMONARY 18Mar2009 SPIRAL CT 0.9 cm 4.8 4.8 0.000 001-001 CYCLE 9 7 5 LYMPH NODE AORTIOCOPULMONARY #2 18Mar2009 SPIRAL CT 0.5 cm 4.8 4.8 0.000 001-001 CYCLE 9 7 6 LYMPH NODE PRE-CARINAL 18Mar2009 SPIRAL CT 0.8 cm 4.8 4.8 0.000 001-001 CYCLE 11 8 1 LUNG LEFT UPPER LOBE 08Apr2009 SPIRAL CT 2.4 cm 4.5 4.5 -0.062 001-001 CYCLE 11 8 2 LYMPH NODE LEFT AXILLA 08Apr2009 SPIRAL CT 0 cm 4.5 4.5 0.000 001-001 CYCLE 11 8 3 LYMPH NODE PRE-VASCULAR 08Apr2009 SPIRAL CT 0 cm 4.5 4.5 0.000 001-001 CYCLE 11 8 4 LYMPH NODE ANTICOPULMONARY 08Apr2009 SPIRAL CT 0.9 cm 4.5 4.5 0.000 001-001 CYCLE 11 8 5 LYMPH NODE ANTICOPULMONARY #2 08Apr2009 SPIRAL CT 0.5 cm 4.5 4.5 0.000 001-001 CYCLE 11 8 6 LYMPH NODE PRECARONAL 08Apr2009 SPIRAL CT 0.7 cm 4.5 4.5 0.000 001-001 UNSCHEDULED 5 1 LUNG LEFT UPPER LOBE 08May2009 SPIRAL CT 2.5 cm 4.6 4.5 0.022 001-001 UNSCHEDULED 5 2 LUNG LEFT AXILLA 08May2009 SPIRAL CT 0 cm 4.6 4.5 0.022 001-001 UNSCHEDULED 5 3 LYMPH NODE PRE-VASCULAR 08May2009 SPIRAL CT 0 cm 4.6 4.5 0.022 001-001 UNSCHEDULED 5 4 LYMPH NODE AORTICOPULMONARY 08May2009 SPIRAL CT 0.8 cm 4.6 4.5 0.022 001-001 UNSCHEDULED 5 5 LYMPH NODE AORTICOPULMONARY #2 08May2009 SPIRAL CT 0.5 cm 4.6 4.5 0.022 001-001 UNSCHEDULED 5 6 LYMPH NODE PRECARINAL 08May2009 SPIRAL CT 0.8 cm 4.6 4.5 0.022 001-001 CYCLE 13 9 1 LUNG LEFT UPPER LOBE 01Jun2009 SPIRAL CT 2.5 cm 7 4.5 0.556 001-001 CYCLE 13 9 2 LYMPH NODE LEFT AXILLA 01Jun2009 SPIRAL CT 0 cm 7 4.5 0.556 001-001 CYCLE 13 9 3 LYMPH NODE PRE-VASCULAR 01Jun2009 SPIRAL CT 0 cm 7 4.5 0.556 001-001 CYCLE 13 9 4 LYMPH NODE AORTICOPULMONARY 01Jun2009 SPIRAL CT 0.9 cm 7 4.5 0.556 001-001 CYCLE 13 9 5 LYMPH NODE AORTICOPULMONARY #2 01Jun2009 SPIRAL CT 0.6 cm 7 4.5 0.556 001-001 CYCLE 13 9 6 LYMPH NODE PRECARINAL 01Jun2009 SPIRAL CT 0.8 cm 7 4.5 0.556 001-001 CYCLE 13 9 7 SKIN/SOFT TISSUE PERICARDIAL FAT 01Jun2009 SPIRAL CT 2.2 cm 7 4.5 0.556 ... View more

Lesion diameter summary check

by Calcite | Level 5 in SAS Enterprise Guide
‎03-16-2010 04:53 PM
‎03-16-2010 04:53 PM
Hi, The following program produces output summarizing the changes in a sum of lesion diameters by comparing each sum to the smallest sum occurring previously. What I'd like to do is modify it so it compares each sum to the baseline value. Any suggestions on the most efficient way to do this? data SUMCHECK; set SASUSER.QUERY_FOR_LS_SAS7BDAT_0006; retain MINLDSUM; by SUBJID; if FIRST.SUBJID then do; MINLDSUM=.; LDSUMCHG=.; end; LDSUMCHG=(LDSUM-MINLDSUM)/MINLDSUM; MINLDSUM=min(MINLDSUM,LDSUM); format LDSUMCHG 8.3; run Many thanks in advance, John ... View more

Re: Left Join with Enterprise Guide

by Calcite | Level 5 in SAS Enterprise Guide
‎01-13-2010 01:54 PM
‎01-13-2010 01:54 PM
Thank you all for your help! ... View more

Re: Left Join with Enterprise Guide

by Calcite | Level 5 in SAS Enterprise Guide
‎01-12-2010 04:29 PM
‎01-12-2010 04:29 PM
So you're saying I need to add something else other than joining on the SUBJID? It really doesn't matter to me how the AEs get linked to the meds, I just wanted to produce a list that displayed the results for each subject from both tables. ... View more

Re: Left Join with Enterprise Guide

by Calcite | Level 5 in SAS Enterprise Guide
‎01-12-2010 03:27 PM
‎01-12-2010 03:27 PM
To further clarify, here are the two example tables and how I'd like to see the output. I now believe this should be an outer join but again I seem to keep getting cartesian output. CM subjid cmtrt 001 ASIPIRIN 001 ZOFRAN 002 DIGOXIN 002 CARDIZEM AE subjid aetrt 001 HEADACHE 001 NAUSEA 002 VOMITING 003 INDIGESTION Desired output: subjid cmtrt aetrt 001 ASPIRIN HEADACHE 001 ZOFRAN NAUSEA 002 DIGOXIN VOMITING 002 CARDIZEM (null) 003 (null) INDIGESTION ... View more

Left Join with Enterprise Guide

by Calcite | Level 5 in SAS Enterprise Guide
‎01-12-2010 02:17 PM
‎01-12-2010 02:17 PM
I am trying to put together some output displaying all subjects in the database with their medications and adverse events side by side, e.g. Subj, Med, AE. I need to use a join to pull the data from the CM and AE tables so I used the SUBJID in a left join (thinking this is correct). The problem is that in the output, I am getting a mashup of every med lnked with every AE for each subject, which appears to be a cartesian join and not what I was expecting in the output. The code is below, any suggestions in correcting this? I've plyed around with various other joins that Enterprise Guide allows but all seem to come up with a massive cartesian output. PROC SQL; CREATE TABLE SASUSER.QUERY_FOR_CM_SAS7BDAT_0002 AS SELECT t1.SUBJID, t1.CMTRT, t2.AETRT FROM EC100045.cm AS t1 LEFT JOIN EC100047.ae AS t2 ON (t1.SUBJID = t2.SUBJID) WHERE t1.SUBJID = '201-008' AND t1.CMTRT NOT = '' AND t2.AETRT NOT = '' ORDER BY t1.SUBJID, t1.CMTRT; QUIT; ... View more

Re: Insert a plus sign before a computed variable

by Calcite | Level 5 in SAS Enterprise Guide
‎01-12-2010 02:10 PM
‎01-12-2010 02:10 PM
Thanks Doc! I'll give it a shot. John ... View more

Insert a plus sign before a computed variable

by Calcite | Level 5 in SAS Enterprise Guide
‎01-07-2010 01:57 PM
‎01-07-2010 01:57 PM
Hi all, I put together a program to display Progression Free Survival (PFS) and Overall Survival (OS) for a listing, i.e. it displays these results as a number of days, 25, 110, etc. One of the requests from a reviewer (and common in these types of listings) is to display a + before the results if the subject is still alive, e.g. Subj 001 PFS = +99 (still alive) vs. Subj 002 PFS = 99 (died). I'm at a loss as to how to do this other than I know I'll have to check whether my Date of Death is either null or present. Any ideas? Thanks! John ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links