About Dhana18

Dhana18 · ‎05-13-2019

the for mat has to be like this F_AZIMIC_DD.

Dhana18 · ‎05-13-2019

so after i ma done fixing the length and the format i need to match with the master provided using this code options nofmterr; data marchsub.MIL_lab_2018_YE;; set mstruct.master_lab Marchsub.Lab1718_C; run; after i used this code, values in the variables AZI_MIC_DD changes from 0.125 to 0. which is inaccurate

Dhana18 · ‎05-13-2019

I used length 21 but no change in the result. the log says this NOTE: There were 6642 observations read from the data set MARCHSUB.LAB1718_B. NOTE: The data set MARCHSUB.LAB1718_C has 6642 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.09 seconds

Dhana18 · ‎05-13-2019

NOTE: There were 6642 observations read from the data set MARCHSUB.LAB1718_B. NOTE: The data set MARCHSUB.LAB1718_C has 6642 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 0.20 seconds cpu time 0.09 seconds

Dhana18 · ‎05-13-2019

Good morning, My data has this variable AZI_MIC_DD in character format and and length is $21, i need it to be in numeric and in length 8. i used this coded DATA Marchsub.Lab1718_A(DROP=DOB_LAB); SET Marchsub.Lab1718; AZIMIC_DD =INPUT(AZI_MIC_DD, BEST12.); DROP AZI_MIC_DD; RENAME AZIMIC_DD=AZI_MIC_DD; RUN; Is there anything wrong with this code?

Dhana18 · ‎05-08-2019

I have a data like this ANTIBIOTIC ANTIBIOTIC Frequency AZITHROMYCIN 1 CEFTRIAXONE/AZITHROMYCIN 3 DOXYCYCLINE 3 FLUCONAZOLE 1 METRONIDAZOLE 1 UNKNOWN 1 I wanted to have a table like this ANTIBIOT_NAME Frequency 4 3 9 3 11 4 77 3 i used this code DATA AprilNin.MERGE_April2019_E; SET AprilNin.MERGE_April2019_D; IF ANTIBIOTIC =: "AZI" then ANTIBIOT_NAME = "11"; ELSE IF ANTIBIOTIC =: "CEF" then ANTIBIOT_NAME = "04"; ELSE IF ANTIBIOTIC =: "DOX" then ANTIBIOT_NAME = "09"; ELSE IF ANTIBIOTIC = "" then ANTIBIOT_NAME = "00"; ELSE ANTIBIOT_NAME="77"; RUN; and result is this NOT what I want ANTIBIOT_NAME Frequency 4 3 9 3 11 1 77 3 the count of AZI (11) should be 4 but it is showing 1. How do i code to this CEFTRIAXONE/AZITHROMYCIN to count for both Azithromycin and Ceftriaxone?

Dhana18 · ‎05-07-2019

Yes, the dat does not have ceftriaxone separately. Is there a way to code to get both Ceftriaxone and Azithromycin info? Or I should separate then before I import to SAS?

Dhana18 · ‎05-07-2019

Good morning, i have a data like this ANTIBIOTIC ANTIBIOTIC Frequency AZITHROMYCIN 1 CEFTRIAXONE/AZITHROMYCIN 3 DOXYCYCLINE 3 FLUCONAZOLE 1 METRONIDAZOLE 1 UNKNOWN 1 I coded like this: DATA AprilNin.MERGE_April2019_E; SET AprilNin.MERGE_April2019_D; IF ANTIBIOTIC = "CEFTRIAXONE" then ANTIBIOT_NAME = "04"; ELSE IF UPCASE(ANTIBIOTIC) =: "AZ" OR UPCASE(ANTIBIOTIC) =: "ZI" then ANTIBIOT_NAME = "11"; ELSE IF UPCASE(ANTIBIOTIC) =: "CEFTRIAXONE/AZITHROMYCIN" then ANTIBIOT_NAME = "11"; ELSE IF UPCASE(ANTIBIOTIC) =: "DO" then ANTIBIOT_NAME = "09"; ELSE IF ANTIBIOTIC = "0" THEN ANTIBIOT_NAME = "00"; ELSE IF ANTIBIOTIC="" THEN ANTIBIOT_NAME="00"; ELSE ANTIBIOT_NAME="77"; RUN; /*CHECKING TO SEE IF THE CODE ABOVE WORKED*/ PROC FREQ DATA=AprilNin.MERGE_April2019_E; TABLE ANTIBIOT_NAME/NOROW NOCOL NOPERCENT; RUN; and the result shows: ANTIBIOT_NAME Frequency 9 3 11 4 77 3 Why am i not getting Ceftriaxone (04) in the result table?

Dhana18 · ‎04-29-2019

Thank you. I modified the like this and it worked. DATA MarchNin.MERGE_March2019_P; SET MarchNin.MERGE_March2019_O; IF HIV_COMBON_A="P" THEN GISP_HIVRESULT ="1"; else IF HIV_COMBON_A ="N" OR HIV_1_2_ABBLOOD ="N" OR HIV_GEENION_A="N" OR HIV_PCRN_A="N" THEN GISP_HIVRESULT ="0"; ELSE IF HIV_COMBON_A ="A" OR HIV_1_2_ABBLOOD ="A" OR HIV_GEENION_A="A" OR HIV_PCRN_A="A" THEN GISP_HIVRESULT ="9"; ELSE GISP_HIVRESULT ="7"; RUN; I did not have response "P" in all variables.

Dhana18 · ‎04-29-2019

Pleasse tell me what is wrong with this code? DATA MarchNin.MERGE_March2019_P; SET MarchNin.MERGE_March2019_O; IF HIV_COMBON_A ="N" OR HIV_1_2_ABBLOOD ="N" OR HIV_GEENION_A="N" OR HIV_PCRN_A="N" THEN GISP_HIVRESULT ="0"; ELSE IF HIV_COMBON_A ="A" OR HIV_1_2_ABBLOOD ="A" OR HIV_GEENION_A="A" OR HIV_PCRN_A="A" THEN GISP_HIVRESULT ="9"; ELSE IF HIV_COMBON_A="P" OR HIV_1_2_ABBLOOD="P" OR HIV_GEENION_A="P" OR HIV_PCRN_A="P" THEN GISP_HIVRESULT ="1"; ELSE GISP_HIVRESULT ="7"; RUN; PROC FREQ DATA=MarchNin.MERGE_March2019_P; TABLE GISP_HIVRESULT; RUN; Here is the result: GISP_HIVRESULT Frequency Percent CumulativeFrequency CumulativePercent079 241 64.61 241 64.61 128 34.32 369 98.93 4 1.07 373 100.00 Why am I not getting only 0, 7, and 9 and not 1 under GISP_HIVRESULT? Please help.

Dhana18 · ‎04-26-2019

It did not work. Log says this. 179 DATA NONSTDEM.PPWI_March_2019_B; 180 SET NONSTDEM.PPWI_March_2019_A; 181 format visdate_newview yymmdds10.; 182 run; NOTE: Variable visdate_newview is uninitialized. NOTE: There were 38 observations read from the data set NONSTDEM.PPWI_MARCH_2019_A. NOTE: The data set NONSTDEM.PPWI_MARCH_2019_B has 38 observations and 31 variables. NOTE: DATA statement used (Total process time): real time 1.41 seconds cpu time 0.03 seconds and the result is visit_dat_newview is . (blank)

Dhana18 · ‎04-26-2019

Thank you for replying my request, it did not work for me.

Dhana18 · ‎04-26-2019

I have visit_date that shows like this 20190321 20190216 20190516 this is in numeric best 12 format I would like it to be like this 2019/03/21 2019/02/16 2019/05/16 i did data want; data have; format visit_date mmddyy10.; run; it did not work. Help me please.

Dhana18 · ‎04-11-2019

Please help me to figure out what is wrong in this code. I am trying to merge data from two data sets if the records are in both data sets. data JanFeb_COMPLETE_2019; merge CONCATENATE_KEENAN_CLN19 (in=B) janfebs.CONCATENATE_JAN2FEB_2019(in=A); by UNIQUE_ID; If a and b; run;

Dhana18 · ‎04-11-2019

I just checked There are values of UNIQUE_ID that appear in both incoming data sets I just checked. It works if I say if a or if b but it just does not work when I say if a and b.

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

Re: format and length

Re: format and length

Re: format and length

Re: format and length

format and length

If-then statement: Multiple variables into one

Re: code to count Counting frequency

code to count Counting frequency

Re: if then statement

if then statement

Re: Date

Re: Date

Date

Re: merging

Re: merging