About Dhana18

Dhana18 · ‎10-11-2018

Hi Reeza, I did order freq to find out if there are any duplicate ids and there are no duplicate ids proc freq data=STDTELMT.Treat18_TRANSPOSED order=freq; table event_id; run; the visit data set has 2105 observations, treat data set has 752 observation with common variable event_id. I sorted both data set by event_id and tried to merge and they are not merged by event id instead treat data set is stacked on top of visit data set. Could you please tell me what did do wrong? Sorting visit data by event_id: proc sort data=STDTELMT.VISIT18_MERGED; by event_id; run; /*SORTING TREATMENT DATA BEFORE TRANSPOSING BY EVENT_ID*/ PROC SORT DATA=RX_MERGED;; BY EVENT_ID; RUN; /*REMOVING DUPLICATES*/ data STDTELMT.TREAT_COUNT; set RX_MERGED; by event_id; t_f=first.event_id; t_l=last.event_id; if t_f=1; run; /*TRANSPOSING TREATMENT DATSET*/ proc transpose data=STDTELMT.TREAT_COUNT out=STDTELMT.Treat18_TRANSPOSED; by EVENT_ID ; ID RX; var RX; run; merging two (visit and treat) data sets DATA STDTELMT.MERGED ; MERGE STDTELMT.VISIT18_MERGED STDTELMT.Treat18_TRANSPOSED; by event_id; RUN; the log says : NOTE: There were 2105 observations read from the data set STDTELMT.VISIT18_MERGED. NOTE: There were 752 observations read from the data set STDTELMT.TREAT18_TRANSPOSED. NOTE: The data set STDTELMT.MERGED has 2857 observations and 41 variables. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.01 seconds

Dhana18 · ‎10-11-2018

Hi Reeza, I did order freq to find out if there are any duplicate ids and there are no duplicate ids proc freq data=STDTELMT.Treat18_TRANSPOSED order=freq; table event_id; run; the visit data set has 2105 observations, treat data set has 752 observation with common variable event_id. I sorted both data set by event_id and tried to merge and they are not merged by event id instead treat data set is stacked on top of visit data set. Could you please tell me what did do wrong? Sorting visit data by event_id: proc sort data=STDTELMT.VISIT18_MERGED; by event_id; run; /*SORTING TREATMENT DATA BEFORE TRANSPOSING BY EVENT_ID*/ PROC SORT DATA=RX_MERGED;; BY EVENT_ID; RUN; /*REMOVING DUPLICATES*/ data STDTELMT.TREAT_COUNT; set RX_MERGED; by event_id; t_f=first.event_id; t_l=last.event_id; if t_f=1; run; /*TRANSPOSING TREATMENT DATSET*/ proc transpose data=STDTELMT.TREAT_COUNT out=STDTELMT.Treat18_TRANSPOSED; by EVENT_ID ; ID RX; var RX; run; merging two (visit and treat) data sets DATA STDTELMT.MERGED ; MERGE STDTELMT.VISIT18_MERGED STDTELMT.Treat18_TRANSPOSED; by event_id; RUN; the log says : NOTE: There were 2105 observations read from the data set STDTELMT.VISIT18_MERGED. NOTE: There were 752 observations read from the data set STDTELMT.TREAT18_TRANSPOSED. NOTE: The data set STDTELMT.MERGED has 2857 observations and 41 variables. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.01 seconds

Dhana18 · ‎10-09-2018

I am trying to merge five dofferent files with event id. Eventid are sorted transposed except visit dataset that has 2105 records. After merging it should be 2105 observations, but it shows 2857. if i merge all four datasets except treat dataset it shows 2105 so i think there is something wrong in treat dataset, i could not tell. /*SORTING TREATMENT DATA BEFORE TRANSPOSING BY EVENT_ID*/ PROC SORT DATA=STDTELMT.TREAT18_SUBSET_1; BY EVENT_ID DATETX; RUN; /*TRANSPOSING TREATMENT DATSET*/ proc transpose data=STDTELMT.TREAT18_SUBSET_1 out=STDTELMT.Treat18_TRANSPOSED; by EVENT_ID DATETX; ID RX; var RX; run; NOTE: There were 2105 observations read from the data set STDTELMT.VISIT18_MERGED. NOTE: There were 1894 observations read from the data set STDTELMT.LAB18_TRANSPOSED. NOTE: There were 1075 observations read from the data set STDTELMT.SYMP18_SUBSET_TRANSPOSED. NOTE: There were 752 observations read from the data set STDTELMT.TREAT_COUNT. NOTE: There were 1948 observations read from the data set STDTELMT.TRANSPOSED_RISK_RENMD. NOTE: The data set STDTELMT.MERGED has 2857 observations and 110 variables. NOTE: DATA statement used (Total process time): real time 0.24 seconds cpu time 0.12 seconds Where did I do wrong?

Dhana18 · ‎09-20-2018

260 data surrg.merged_male_exposure2; 261 set surrg.merged_male_exposure1; 262 if rect_exp = "1" OR rect_interc = "1" then rectal_exposure = "Yes"; 263 run; NOTE: There were 3439 observations read from the data set SURRG.MERGED_MALE_EXPOSURE1. NOTE: The data set SURRG.MERGED_MALE_EXPOSURE2 has 3439 observations and 206 variables. NOTE: DATA statement used (Total process time): real time 0.50 seconds cpu time 0.07 seconds I did a frequency analysis of rect_exp there are 410 patients with that exposure and rect_interc has 263 patients and after this code there should be 473 rectal exposure but it only give me 425. That is wrong.

Dhana18 · ‎09-20-2018

data surrg.male_exposure2; set surrg._male_exposure1; if rect_exp = "1" OR rect_interc = "1" then rectal_exposure = "Yes"; else rectal_exposure = "0"; run;

Dhana18 · ‎09-13-2018

Hi I have a data like this; data symptoms; input id symptoms $ ; cards; 1 discharge 2 pain 3 sore 4 odor warts ; run; I transposed the data set and it looks this now id vaginal_discharge pain_on_sex peniel_sore 1 peniel_sore 2 vaginal_discharge 3 pain_on_sex 4 pain_on_sex peniel_sore instead of this i would like to have like THIS (below) id vaginal_discharge pain_on_sex peniel_sore 1 0 0 1 2 1 0 0 3 0 1 0 4 0 1 1 The underscore between word of the variable is not working. I used if then statement like this; if discharge ="discharge" then discharge="1"; but i have hundreds of symptoms to write if then statement. is there a shorter way macro or something to do it efficiently?

Dhana18 · ‎09-13-2018

It worked! It worked for the symptoms variable without dash in between but did not work for the variable like this "nickel_dime_les" , "Vaginal_lesion" do I need to add or delete something on the code you sent to me earlier?

Dhana18 · ‎09-13-2018

Hi I have a data like this; data symptoms; input id symptoms $ ; cards; 1 discharge 2 pain 3 sore 4 odor warts ; run; I transposed the data set and it looks this now id discharge pain sore odor 1 discharge 2 pain odor 3 sore 4 odor instead of this i would like to have like THIS (below) id discharge pain sore odor 1 1 0 0 0 2 0 1 0 1 3 0 0 1 0 4 0 0 0 1 I used if then statement like this; if discharge ="discharge" then discharge="1"; but i have hundreds of symptoms to write if then statement. is there a shorter way macro or something to do it efficiently?

Dhana18 · ‎09-10-2018

Thank you. You made my day!!!

Dhana18 · ‎09-10-2018

I converted the numeric date variable into character variable using this code proc sql; create table as date_char as select put (visit_dt,yymmdd10.) as visdate from stdtelmt merged; quit; it worked as I wanted but in my new table I only have new variable. how do I get all of the variable I had in the from table? or all of the variable in the previous dataset?

Dhana18 · ‎09-05-2018

Hi, I have this sample data. I would like to get each group of test for example NAAT only CULT only Both NAAT and CULTURE, either CULTURES or NAAT. what logic should i use? EVENTID HIV PMNS CULP CULG CULR NAATR NAATP NAATU NAATG 44 N P N N N P N P N 45 N N P N N N 46 N N N P N 47 N N 48 N N N N N P

Dhana18 · ‎09-05-2018

Thank you Reza, Here is sample data. i would like to count each group of test with result for example NAAT ONLY (NAATR,NAATP, NAATP, NAATG), CULTURE ONLY (CULP,CULG, CULR) and BOTH NAAT and CULTURE and EITHER NAAT or CULTURE. what logic should i use? EVENT_ID HIV_GEENIO HIV_COMBO PMNS GNID GNED HCG CULP CULG CULR NAATU NAATP NAATG NAATR 44 P P N P P 46 N N N 47 N N N N 51 N P N N N N 52 N N N 53 N N 55 N N N N N 56 N N 57 N N N N N N 58 N N N N 60 N N N N N 61 N N 62 N P N N N N 64 N N 65 N N 66 N P N N N 67 N N N N 68 N N N N 70 N P N 72 N P N N N 73 N N N

Dhana18 · ‎09-05-2018

My data is very complex with thousands of records. same person can visit the clinic many times in a year and at one visit the person can have many different tests. for example data test; input patient_id event_id test site $ results$; DATALINES; 1 01 300 U N 1 01 700 O P 1 01 700 P N 1 01 900 V N 1 01 700 R P 2 02 300 V P 2 01 900 B P ; RUN; For example, I want to find out any 700 tests in a visit / event in a given period of time with p or n result.

Dhana18 · ‎09-05-2018

Still having the same problem, spent all day today figuring this out,please help. ERROR: The ID value "HIV_COMBO" occurs twice in the same BY group. NOTE: The above message was for the following BY group: EVENT_ID=0210357151 ERROR: The ID value "HIV_COMBO" occurs twice in the same BY group. NOTE: The above message was for the following BY group: EVENT_ID=0210358360 WARNING: 2 BY groups omitted due to earlier errors.

Dhana18 · ‎08-31-2018

ERROR: The ID value "HIV_COMBO" occurs twice in the same BY group. NOTE: The above message was for the following BY group: EVENT_ID=0357151 ERROR: The ID value "HIV_COMBO" occurs twice in the same BY group. NOTE: The above message was for the following BY group: EVENT_ID=0358360 WARNING: 2 BY groups omitted due to earlier errors.

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

Merging

Re: merging

merging

Re: what is wrong with this code?

what is wrong with this code?

Re: %LET macro statement

Re: %LET macro statement

%LET macro statement

Re: converting numeric date variable into character date variable

converting numeric date variable into character date variable

Re: transposed error

Re: transposed error

Re: transposed error

Re: transposed error

Re: transposed error