About Dhana18

Dhana18 · ‎06-24-2019

Hi, I have a data something like this ID Visit date Gender of Sex partner 11263 9/1/2017 2 11263 9/6/2017 9 11263 9/13/2017 9 11736 9/4/2018 1 11736 9/14/2018 9 11891 6/6/2017 9 11891 7/17/2017 2 11891 8/2/2017 2 11894 8/9/2017 9 11894 9/18/2017 9 11893 9/21/2017 3 11893 10/20/2017 9 gender of sex partners(gender_sp) code is 1=male, 2-female, 3=both, 9=unknown I want to copy mostly prior visit's gender of sex partners' info to other visits . in some situation gender of sex partner is missing in fist visit but is available in second visit. I want to copy gender of sp to all visit if it is the same patient. How can i do this? I have 9588 records cannot fix this manually. Please help. SAS community is a GREAT resource for me. i want like this from the previous table ID Visit date Gender of Sex partner 11263 9/1/2017 2 11263 9/6/2017 2 11263 9/13/2017 2 11736 9/4/2018 1 11736 9/14/2018 1 11891 6/6/2017 2 11891 7/17/2017 2 11891 8/2/2017 2 11894 8/9/2017 9 11894 9/18/2017 9 11893 9/21/2017 3 11893 10/20/2017 3

Dhana18 · ‎06-21-2019

I have a data set like this; id k_race p_race b_race 1 black 2 white 3 asian i want this to be like id race 1 black 2 white 3 asian how do i code this? please help.

Dhana18 · ‎06-13-2019

data checking_A; set checking; ID=put(event_id, best11.);/*converting numeric CL_eventid to character EventID as it is in the other dataset*/ run; proc sort data=checking_a; by ID; run; data chris_checking_A(keep=EventID); length EventID $11.; set chris_checking; where CL_Facility_location="MIL-01"; run; data chris_checking_B; set chris_checking_A; rename eventid=id; label eventid=id; run; proc sort data=chris_checking_B; by ID; run; proc sql; create table CheckingAA as select id.* from checking_A as a left join chris_checking_B as b on a.id=b.id ; quit; 547 proc sql; 548 create table CheckingAA as 549 select id.* 550 from checking_A as a 551 left join 552 chris_checking_B as b 553 on a.id=b.id 554 ; ERROR: Could not expand id.*, correlation name not found. ERROR: Ambiguous reference, column id is in more than one table. 555 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.03 seconds

Dhana18 · ‎06-13-2019

Do all of the variables name match in both datasets even one of the data set has only ids?

Dhana18 · ‎06-13-2019

I used the first code you sen to me; the log says this; NOTE: There were 9346 observations read from the data set WORK.CHECKING_A. NOTE: There were 2576 observations read from the data set WORK.CHRIS_CHECKING_A. NOTE: The data set WORK.WANT has 0 observations and 58 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds And the result is only name of the variables with no values

Dhana18 · ‎06-13-2019

Good morning, I have 2 data sets set like this id name age sex Data set 1: 1 sima 23 f 2 shyam 34 m 3 ana 35 f 4 jacob 26 m 5 chris 34 m data set 2: id 1 3 5 how can i have output like this? 1 sima 23 f 3 ana 35 f 5 chris 34 m

Dhana18 · ‎06-11-2019

This is a secure message HOW TO OPEN To read this message on desktop, open the securedoc_20190611T134759.html attachment in a web browser. To read this message on a mobile device, forward this message to mobile@res.cisco.com to receive a mobile login URL. Need Help? - https://res.cisco.com/websafe/help?topic=RegEnvelope Contact the sender directly if you are not sure about the validity of this message. Copyright ?? 2011-2019 Cisco Systems, Inc. and/or its affiliates. All rights reserved.

Dhana18 · ‎06-10-2019

Options 4 hours ago I have data set like this with more than 50 variables Doxycycline_100MG_PO_BID_X_07 ACYCLOVIR_400MG_TID_X_7_DAYS METRONIDAZOLE_500MG_POBID_X14D DOXYCYCLINE 100MG PO BID X 07 ACYCLOVIR 400MG TID X 7 DAYS METRONIDAZOLE 500MG POBID X14D DOXYCYCLINE 100MG PO BID X 07 METRONIDAZOLE 500MG POBID X14D ACYCLOVIR 400MG TID X 7 DAYS I am using if then statement like this - if METRONIDAZOLE_500MG_POBID_X14D="METRONIDAZOLE 500MG POBID X14D" then METRONIDAZOLE_500MG_POBID_X14D="1"; else METRONIDAZOLE_500MG_POBID_X14D="0"; There are more than 50 variables and it is taking time to code with if then statement. Is there a way to do it with a single code? I would like to have 1 if the response is present and 0 if there is no response for each variable. How can I do it at once?

Dhana18 · ‎06-10-2019

it should only be two categories, if the response is present that should be coded "1" if the response is missing then that should be coded "0" please help my life make my life easier.

Dhana18 · ‎06-10-2019

Sorry I am not very clear of your code suggestion I used like this and it did not work. data LANLYSIS.Clinic_MEDICATION_CODED; set LANLYSIS.Clinic1_SYMPTOMS_CODED; METRONIDAZOLE_500MG_POBID_X_7D =WHICHC('METRONIDAZOLE 500MG POBID X 7D' , CEFTRIAXONE_ROCEPHIN_250MG_IM='CEFTRIAXONE(ROCEPHIN)250MG IM') >'0'; run; the result is metronidazole all coded 0 and nothing happened in CEFTRIAXONE_ROCEPHIN_250MG_IM. Please help. Thank you.

Dhana18 · ‎06-10-2019

I have data set like this with more than 50 variables Doxycycline_100MG_PO_BID_X_07 ACYCLOVIR_400MG_TID_X_7_DAYS METRONIDAZOLE_500MG_POBID_X14D DOXYCYCLINE 100MG PO BID X 07 ACYCLOVIR 400MG TID X 7 DAYS METRONIDAZOLE 500MG POBID X14D DOXYCYCLINE 100MG PO BID X 07 METRONIDAZOLE 500MG POBID X14D ACYCLOVIR 400MG TID X 7 DAYS I want to code these as if METRONIDAZOLE_500MG_POBID_X14D="METRONIDAZOLE 500MG POBID X14D" then METRONIDAZOLE_500MG_POBID_X14D="1"; else METRONIDAZOLE_500MG_POBID_X14D="0"; How can I do it at once?

Dhana18 · ‎05-16-2019

Yes, if in any visit sex with male or female is recorded as 1, and no info on other visits all visits should be 1

Dhana18 · ‎05-16-2019

Hi, My data looks like this. PATIENT_ID EVENT_ID VISIT_AGE VISIT_DT SEX Genital Exposure Oral Exposure Rectal Exposure Sex With Female Sex With Male Sex with Transgender 5855 57927 36 9/12/2017 Male Y B 0 1 0 0 5855 58140 36 9/22/2017 Male 0 0 0 7490 54781 38 4/17/2017 Female Y B R 0 1 0 7490 54923 38 4/24/2017 Female 0 0 0 0 0 0 8013 54361 42 3/27/2017 Female Y B 0 0 1 0 8013 54499 42 4/3/2017 Female 0 0 0 8013 54642 42 4/10/2017 Female 0 0 0 Please note that same patient(patient_id=5855) in their next visit has incomplete info for example in the table above sex with female info is missing or says 0 in second visit on 09/22. i want it to 1 as it was on 09/12 visit. Similarly, patient id 8013 visited three times but sex with male info is 1 in only on first visit, i want it to be 1 all three visits. How do i code to get the data i want?

Dhana18 · ‎05-13-2019

Thank you! you made my day.

Dhana18 · ‎05-13-2019

Can you explain to me please I did not understand what you are saying Then you need to supply example data in a form that leaves no room for ambiguities (data step with datalines).

Online Status	Offline
Date Last Visited	‎08-16-2021 12:28 PM

Re: count

what is wrong with this code

Re: count

count

Re: How to calculate relative Risk and confidence Interval

How to calculate relative Risk and confidence Interval

Re: how do I get value form a event row to event row where value is mi...

how do I get value form a event row to event row where value is missin...

Re: How do i find days betten first and second and second and third ep...

Re: How do i find days between first and second and second and third e...

Re: Here are the values in thsoe tow vars

Re: Merging

copying info

Creating a single variable from multiple variables

Re: merging

Re: merging

Re: merging

merging

Re: Recode values

Recode values

Re: Re coding multiple variables with three categories at once

Re: Re coding multiple variables with three categories at once

Re coding multiple variables with three categories at once

Re: PROC Transpose missing values

PROC Transpose missing values

Re: format and length

Re: format and length