About kalbo

kalbo · ‎02-26-2025

yes it should be smart enough to handle that.

kalbo · ‎02-26-2025

hi, yes there would be other data sets listed. The id is the coregroup of 1,2,3 or 4 (for ADSL) which corresponds to CORE1, 2, 4, 5 for all other data sets.

kalbo · ‎02-26-2025

The example I gave is a part of a data set (which is the metadata of adam data sets) which is about 1000 rows. I would need to replace any CORE value with observations from the ADSL. Can be up to 4 core groupings. So whenever CORE1, 2, 3 etc appears it should also work for those.

kalbo · ‎02-26-2025

For example to process CORE1, we need to find all records in ADSL with coregroup=1. Then add these 2 records in to replace CORE1. ADAE RAND Rand flag 1 ADAE SITEID Site ID 1 Then move to CORE2 and add in the following records to replace CORE2: ADAE ETHNEW New Ethnicity 2 The ADSL records can be added to any data set in the list which will contain all data sets. The list isnt so big. WANT: dataset variable label coregroup ADAE USUBJID Subject ID ADAE RAND Rand flag 1 ADAE SITEID Site ID 1 ADAE ETHNEW New Ethnicity 2 ADAE TRT Treatment ADMH USUBJID Subject ID ADMH MHTERM Medical History Term ADMH TRT Treatment Group ADSL USUBJID Subject ID ADSL RAND Rand flag 1 ADSL ETHNEW New Ethnicity 2 ADSL SITEID Site ID 1

kalbo · ‎02-26-2025

data have; infile cards dsd; input dataset $ variable : $10. label : $20. coregroup $; cards; ADAE,USUBJID,Subject ID, ADAE,:CORE1,, ADAE,:CORE2,, ADAE,TRT,Treatment, ADMH,USUBJID,Subject ID, ADMH,MHTERM,Medical History Term, ADMH,TRT,Treatment Group, ADSL,USUBJID,Subject ID, ADSL,RAND,Rand flag,1, ADSL,ETHNEW,New Ethnicity,2, ADSL,SITEID,Site ID,1, ;

kalbo · ‎02-26-2025

hi, I have a situation where ADSL variables are selectively added to a list. In this example CORE1 should be replaced by a list of variables present in ADSL that have a coregroup of 1. CORE2 should be replaced by a list of variables in ADSL with coregroup of 2 and so on. I would like to automate this addition of variables. HAVE: dataset variable label coregroup ADAE USUBJID Subject ID ADAE :CORE1 ADAE :CORE2 ADAE TRT Treatment ADMH USUBJID Subject ID ADMH MHTERM Medical History Term ADMH TRT Treatment Group ADSL USUBJID Subject ID ADSL RAND Rand flag 1 ADSL ETHNEW New Ethnicity 2 ADSL SITEID Site ID WANT: dataset variable label coregroup ADAE USUBJID Subject ID ADAE RAND Rand flag 1 ADAE ETHNEW New Ethnicity 2 ADAE TRT Treatment ADMH USUBJID Subject ID ADMH MHTERM Medical History Term ADMH TRT Treatment Group ADSL USUBJID Subject ID ADSL RAND Rand flag 1 ADSL ETHNEW New Ethnicity 2 ADSL SITEID Site ID

kalbo · ‎02-18-2025

Hi, Im trying to use index function to search for the following string: %put('ERROR However I think the % with single quote (enslosed by double quote marks" is causing errors. Is there a way to search for the string without errors? This is how I used the index function: index(intext, "%put('ERROR")=0

kalbo · ‎02-10-2025

Hi I have a data set with text from a log file. I have a variable called TEXT: TEXT put 'ERROR' blah blah blah put "ERROR:" blah blah blah var='ERROR' blah blah blah var="ERROR" blah blah blah I need to indentify cases where there is put followed by ERROR (in quotes) and cases where there is an = sign followed by ERROR (in quotes). I was thinking of using index but thought PRXMATCH might be better due to the quote marks.

kalbo · ‎01-26-2025

Thanks for the reply. USUBJID and VISIT are the keys. Changes in DATE are the ones to be flagged as "updated". I wanted to retain the original sort order of the data sets and do a comparison on them. Number of variables is going to be from 3 to 7, depending on number of keys. There will always be one variable to be compared.

kalbo · ‎01-25-2025

There would be 10000 rows estimate. I have already been asked to make a hash object. Thanks.

kalbo · ‎01-25-2025

Hi I need to compare 2 data sets (old and new) using the keys of USUBJID and VISIT using hashing method. (The real data sets I will be comparing are huge, hence the need for hashing). I would like to create output data sets that flag observations as NEW, DELETED or UPDATED. Also if possible I would like to add observations numbers to the output. Thanks data old; infile datalines dsd; input USUBJID $ VISIT: $8. DATE: $8.; datalines; R191,SCREEN,JAN R191,SCREEN,FEB R191,VISIT1,MAR R193,SCREEN,JAN R193,VISIT1,APR R194,VISIT4,FEB ; data new; infile datalines dsd; input USUBJID $ VISIT: $8. DATE: $8.; datalines; R191,SCREEN,JAN R191,SCREEN,SEP R191,VISIT1,FEB R191,VISIT2,APR R193,SCREEN,JAN R193,VISIT1,MAY R194,VISIT4,FEB R195,VISIT1,SEP ;

kalbo · ‎12-11-2024

Hi all I have AE data which is structured like: Arm Preferred_term A Headache A Zoster B Fatigue B Headache I want to use proc freq to create a data set containing risk difference (comparing Arm A and Arm B) like this: Arm Preferred_term Risk_diff A Headache 0.45 A Zoster 0.5 B Fatigue 0.1 B Headache 0.2 How do I structure the data prior to using proc freq? Thanks.

kalbo · ‎12-11-2024

Thanks for your reply. Do you know how data should be structured before using proc freq?

kalbo · ‎12-11-2024

Hi all, I need to add the calculated Risk Difference to listings of preferred terms for a trial. There are 2 arms: dose and placebo. Per FDA standards, I would like to add risk difference with 95% confidence intervals. This can be added to either the AE data set, or to the proc report. prefterm dose placebo riskdifference Cold 3 2 Flu 2 1 Headache 1 3

kalbo · ‎09-26-2024

Hi, I have a vital signs data set with multiple rows per subject/visit/timepoint. I would like to collapse the data so there is one row per subject/visit/timepoint. Have: SUBJECT VISIT TIMEPOINT TEMP SYSBP DIABP 101 C1 PRE 1 . . 101 C1 PRE . 21 43 101 C2 POST . 2 5 46 102 C1 PRE 1 22 32 102 C1 POST . 56 . 102 C1 POST 2 . 25 102 C2 POST 5 55 54 Want: SUBJECT VISIT TIMEPOINT TEMP SYSBP DIABP 101 C1 PRE 1 21 43 101 C2 POST . 2 5 46 102 C1 PRE 1 22 32 102 C1 POST 2 56 25 102 C2 POST 5 55 54

Online Status	Offline
Date Last Visited	‎03-05-2025 11:26 AM

Re: adding observations according to variable values

Re: adding observations according to variable values

Re: adding observations according to variable values

Re: adding observations according to variable values

Re: adding observations according to variable values

adding observations according to variable values

Index function with % and single quote

finding text with quotes

Re: Comparing 2 data sets using hashing

Re: Comparing 2 data sets using hashing

Re: Collapsing records for vital signs

Re: Collapsing records for vital signs

Re: identifying brackets using prx function

Re: using proc report to make excel heatmap

Re: Adding grouping variable

Re: Creating editable (ungroupable) graphs in powerpoint 2010

Re: adding observations according to variable values

Re: adding observations according to variable values

Re: adding observations according to variable values

Re: adding observations according to variable values

Re: adding observations according to variable values

adding observations according to variable values

Index function with % and single quote

finding text with quotes

Re: Comparing 2 data sets using hashing

Re: Comparing 2 data sets using hashing

Comparing 2 data sets using hashing

proc freq riskdiff how to structure data

Re: calculation of risk difference

calculation of risk difference

Collapsing records for vital signs