About hjjijkkl

hjjijkkl · ‎03-06-2023

I have a big data and I am trying to find total number of patient given one or combination of drugs given at the same day. The table i have below is just an example. Please help on how to approach analyzing this data. Thanks! Studyid Medication Med_date 1 rti 5/2/2022 1 levo 5/2/2022 3 emb 4/6/2022 4 rti 5/15/2022 4 clr 5/15/2022 4 levo 5/15/2022 7 clr 5/9/2022 7 sst 5/9/2022 1 llt 7/12/2022 1 rti 7/12/2022 2 Llt, rti 7/12/2022 8 emb 4/6/2022 Below is the outcome I am trying to analyze All drug combos given on the same day for same patient Number of patient Rti, levo 1 emb 2 Rti, clr, levo 1 Clr, sst 1 Llt, rti 2

hjjijkkl · ‎08-11-2021

I am trying to find the number of participants between specific time period. How would be able to calculate that in SAS. For example, How can determine the total number of hospital visitors from 10/20/2018 - until "today" who has positive flu test from the table below? Please help! Thank you! ID date Flu_test 1 2/8/2019 negative 2 6/12/2021 positive 3 7/10/2017 positive 4 6/23/2020 . 5 8/15/2019 positive 6 8/24/2017 negative 7 12/20/2020 positive the outcome will be 3 = positive 1 = negative

hjjijkkl · ‎08-04-2021

this is what I tried the code in different ways but, its not giving me the answer I wanted data want ; do until(last.ID); set need; by ID; t = max(t, test); end; if t > 0; keep ID test visitdate result; run;

hjjijkkl · ‎08-04-2021

I have a data where I would like to excludes records of a participant where "test" recorded 0's from the "first visitdate" to the "last visitdate". If the participant has 0's in between "visits" I would like to keep them. Please see the table below as an example. ID visitdate test Result 1 6/8/2020 1 87 1 9/6/2020 1 54 1 12/4/2020 0 76 2 7/4/2020 2 84 2 7/22/2021 1 33 3 1/3/2021 0 88 3 5/14/2021 0 65 4 7/9/2021 1 23 5 8/9/2020 0 98 5 12/4/2020 0 44 Below is how the output would look like ID visitdate test Result 1 6/8/2020 1 87 1 9/6/2020 1 54 1 12/4/2020 0 76 2 7/4/2020 2 84 2 7/22/2021 1 33 4 7/9/2021 1 23

hjjijkkl · ‎07-22-2021

I have a big data with 100+ variables and I want to keep records depending on the "Incident" variable. For example, I want to keep records only were the incident variable during (week0) is not missing "test and/or "date" variable. But, If the incident variable is missing "test" and "date" values during (week0) then I want to replace (or keep) the "1_week0" value in place of the week0. Please look the table below as an example and the outcome. ID Incident test date Result 1 Week0 34 2/2/2021 90 1 1_week0 40 3/4/2021 56 2 Week0 . . 100 2 1_week0 84 5/12/2021 34 2 Week1 50 5/23/2021 67 3 Week0 43 3/8/2021 98 3 1_week0 10 4/21/2021 80 3 Week1 23 5/1/2021 45 4 week0 . . 76 4 1_week0 64 3/7/2021 78 This is how I would want the outcome to look like ID Incident test date Result 1 Week0 34 2/2/2021 90 2 1_week0 84 5/12/2021 34 3 Week0 43 3/8/2021 98 4 1_week0 64 3/7/2021 78

hjjijkkl · ‎07-14-2021

I have a big data and I want to keep records where the term variable is either 0 or missing for that specific ID. For example in the table below, ID 2 has term=1 so, I want to delete the whole record for ID 2 from the data. How can I do that? D term 1 0 1 2 1 2 2 3 . 3 This is the outcome I want to have D term 1 0 1 3 . 3

hjjijkkl · ‎06-04-2021

I tried everything. nothing is working.

hjjijkkl · ‎06-03-2021

This is what the data looks like and i am using proc report but, the IQR is cutting off in the rft output. I have tried everything (format the data, decrease the front, increase the cell width) but its not working. the data isnt truncated and the problem is in proc report Obs var label Total ctl DDR Fmt 1 asote AbRTI 20 7 13 n 2 asote AbRTI 398.8 (241.5) 445.7 (185.1) 346.1 (297.0) Mean (SD) 3 asote AbRTI 434 (208 - 523) 454 (424 - 508) 284(82.5 - 654) Median (IQR) 4 asote AbRTI 2 - 755 44 - 755 2 - 726 Range

hjjijkkl · ‎06-03-2021

I am using ods- proc report to generate a report in rtf and i am having issue with some of the text cutting off. i increased the cell width but, it is not helping. How can i fix this issue ?

hjjijkkl · ‎05-30-2021

Is it possible to give one variable multiple names using format statement or label statement? I have a variable called "clinical" and I want to describe it in 3 different descriptions "visit", "lab" and patient". I am not sure if I will be bale to do it using label statement .

hjjijkkl · ‎05-21-2021

Meaning subtracting 36 weeks from date1 to get date 2

hjjijkkl · ‎05-21-2021

How do you subtract weeks from a given date? how can i code that for example I have a data with a date (date1 ) and I want to subtract 36 weeks and get a new date (date2). please look the table below for example. date1 date 2 5/3/2012 8/25/2011 6/4/2012 9/26/2011

hjjijkkl · ‎05-14-2021

I have a data with more than 50 variables, i wanted to add an observation 'S_1' a above every 6_w observation in the 'Event' variable. I also wanted to move the 'date' variable observations and other two more variable observation to 'S_1" row but, keep the rest of variables observation as it is. How can I do that? Please see the example below. ID event date sex 1 6_W 12/3/2010 F 1 8_W 2 6_W 4/7/2012 M 2 8_W 3 6_W 5/8/2012 M 3 8_W 3 10_W I would like to add an observation above every 6_W event called “S_1” and move the date to the new observation. So it would look like this below ID event date 1 S_1 12/3/2010 1 6_W F 1 8_W 2 S_1 4/7/2012 2 6_W M 2 8_W 3 S_1 5/8/2012 3 6_W M 3 8_W 3 10_W

hjjijkkl · ‎05-14-2021

this works, but i have more than 50 variables in the data. and i only want the date to move to the event 'S_1' and keep the rest as it is. How can i do that?

hjjijkkl · ‎05-14-2021

can someone help me on this please?

Online Status	Offline
Date Last Visited	‎03-10-2023 01:43 PM

Identifying total number patinets gieven a combination of drugs

Identifying number participants by subtracting date

Re: How to exclude specific records

How to exclude specific records

how to replace missing value

how to delete a record depending on specific variable

Re: Text string cutting off even though I increased the cell width

Re: Text string cutting off even though I increased the cell width

Text string cutting off even though I increased the cell width

Is it possible to give one variable multiple names

Re: Identifying number participants by subtracting date

Re: How to select specific records

Re: How to select with specific test results

Re: How to select specific records in big data

Re: How to create a table containing the first number only

How to read .Z in SAS

Identifying total number patinets gieven a combination of drugs

Identifying number participants by subtracting date

Re: How to exclude specific records

How to exclude specific records

how to replace missing value

how to delete a record depending on specific variable

Re: Text string cutting off even though I increased the cell width

Re: Text string cutting off even though I increased the cell width

Text string cutting off even though I increased the cell width

Is it possible to give one variable multiple names

Re: how to subtract weeks from date

how to subtract weeks from date

adding observation to a big data

Re: adding observation to an existing data

Re: adding observation to an existing data