Good morning, the new vari i am trying to create MENSEX did not create. What is wrong with this code below? DATA NovDec19.MERGED_NUMPARTS_1; length mensex $3; SET NovDec19.MERGED_NovDec19_NUMPARTS; if gender_sp ="1" AND NUM_PRT_3M="1" THEN MENSEX= "1"; if gender_sp ="1" AND NUM_PRT_3M="2" THEN MENSEX="2"; if gender_sp ="1" AND NUM_PRT_3M="3" THEN MENSEX="3"; if gender_sp ="1" AND NUM_PRT_3M="5" THEN MENSEX="5"; if gender_sp in("3" , "9") AND NUM_PRT_3M in("1" , "2" , "3" , "5") THEN MENSEX="999"; run; ... View more

I have a data like this, attached.  I would like to have a row per id that includes  unduplicated info from other rows for all var in one row. Desired table is something like this: ID ThroatPain Dysuria GenitalDischarge RectalPain AbdominalPain Treatment TreatmentRx TreatmentRxOther TreatmentRx2 TOC SexAtBirth 773233 No Yes Yes Unknown No 7/6/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm Yes Male 783394 No No No Unknown No 8/17/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm Yes Male 785878 No No No Unknown Yes 8/1/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm   Female 976906 No No Yes Unknown No 11/27/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm Yes Male 976916 No No No Unknown No 11/29/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm   Female 979830 No No Yes Unknown No 11/29/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm   Female 005182 No Yes Yes Unknown No 12/12/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm Yes Male 005185 No No Yes Unknown No 12/12/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm Yes Male 010768 No No No Unknown No 12/19/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm Yes Male 013588 No Yes Yes Unknown No 12/15/2017 Ceftriaxone (Rocephin) 250 mg   Azithromycin (Zithromax) 1 gm   Male ... View more

I had TOC date in date format in excel. after imported in to SAS it became like this   TOC After imported in SAS 7/17/2017 42933 7/24/2017 42940 After imported it is in character format, I  used this code to change it to numeric date format DATA ALERTCSE.Alert_Cases_TOC; SET ALERTCSE.Alert_Cases; format Test_of_Cure mmddyy10.; TOC = INPUT (TOC, mmddyy10.); drop TOC; rename Test_of_Cure=TOC; run; and it says this; NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 85 at 193:16 NOTE: There were 166 observations read from the data set ALERTCSE.ALERT_CASES. NOTE: The data set ALERTCSE.ALERT_CASES_TOC has 166 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.14 seconds   And TOC column is with these dates which is WRONG TOC 4/29/1933 4/29/1940   Please help me. ... View more

HI I have the data like this and i would like to calculate p-value to  to see if the populations differ statistically in terms of these variable (event).    FEMALE   Alert   Non-Alert   # %   # % TOTAL 11     202   GENDER           Male 0 0%   0 0% Female 11 100%   202 100% Male to Female 0 0%   0 0% Unknown 0 0%   0 0% RACE                African American 11 100%   176 87%      White 0 0%   8 4%      Other 0 0%   18 9% ETHNICITY                Hispanic 1 9%   6 3%      Non-Hispanic 10 91%   191 95% Unknown 0 0%   5 2% GENDER SP                Male 9 82%   164 81%      Female 1 9%   26 13%      Both 1 9%   5 2% Unknown 0 0%   7 3% SYMPTOMS                Dysuria 0 0%   5 2%      Discharge 4 36%   49 24% GC History                Yes 0 0%   21 10%      No 11 100%   179 89% Unknown 0 0%   2 1% ... View more

Hello, I have this calculated and I am trying find if the differences in this three groups are significant or not. I know we did not have equal number of sample in each group.  I have never done statistical test so i am wondering if some one canhelp me find the 95% CI and pvalue of each variable i am comparing here.   FEMALE MSM MSW   Alert Non-Alert Seed Alert Non-Alert Seed Alert Non-Alert Seed   # % # % # % # % # % # % # % # % # % TOTAL 11 22% 202 21% 2 13% 22 44% 87 9% 3 19% 17 34% 651 69% 11 69% GENDER   Male 0 0% 0 0% 0 0% 22 100% 85 98% 3 100% 17 100% 649 100% 11 100% Female 11 100% 202 100% 2 100% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% Male to Female 0 0% 0 0% 0 0% 0 0% 2 2% 0 0% 0 0% 0 0% 0 0% Unknown 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 0 0% 2 0% 0 0% RACE        African American 11 100% 176 87% 2 100% 17 77% 59 68% 3 100% 13 76% 609 97% 9 82%      White 0 0% 8 4% 0 0% 3 14% 9 10% 0 0% 1 6% 21 3% 2 18%      Other 0 0% 18 9% 0 0% 2 9% 19 22% 0 0% 3 18% 21 3% 0 0% ETHNICITY        Hispanic 1 9% 6 3% 1 50% 3 14% 7 8% 1 33% 2 12% 24 4% 2 18%      Non-Hispanic 10 91% 191 97% 1 50% 19 86% 80 92% 2 67% 15 88% 612 96% 9 82% Unknown 0 0% 5 2% 0 0% 0 0% 0 0% 0 0% 0 0% 15 2% 0 0% GENDER SP        Male 9 82% 164 84% 1 100% 21 95% 75 86% 2 67% 0 0% 0 0% 0 0%      Female 1 9% 26 13% 0 0% 0 0% 0 0% 0 0% 15 100% 640 100% 11 100%      Both 1 9% 5 3% 0 0% 1 5% 12 14% 1 33% 0 0% 0 0% 0 0% Unknown 0 0% 7 3% 1 50% 0 0% 0 0% 0 0% 2 12% 11 2% 0 0% SYMPTOMS        Dysuria 0 0% 5 2% 0 0% 5 23% 21 24% 2 67% 4 24% 235 36% 7 64%      Discharge 4 36% 49 24% 1 50% 6 27% 10 11% 2 67% 5 29% 495 76% 10 91% GC History        Yes 0 0% 21 11% 0 0% 4 18% 18 21% 0 0% 0 0% 168 26% 8 73%      No 11 100% 179 90% 2 100% 18 82% 69 79% 3 100% 17 100% 480 74% 3 27% Unknown 0 0% 2 1% 0 0% 0 0% 0 0% 0 0% 0 0% 3 0% 0 0% ... View more

I have a data alike this  ID AlertType Gender MSM Gender_Sp Race Ethnicity Number of partners  Age  GCHX SXPharyngeal Discharge  Dysuria  SXAbdomen 1 Alert m Yes male White  hispanic 1 12 yes  yes  no  no  no  2 Non-Alert  f no female Black  non hispanic 5 45 no  no  yes  yes  yes  3 Seed m Unk Unknown other hispanic 3 23 no  no  no  no  no  4 alert f no female Black  non hispanic 4 36 yes  yes  no  no  no  5 seed mtf Unk Unknown other hispanic 5 25 no  no  yes  yes  yes  6 Seed m Yes male White  non hispanic 6 21 no  yes  no  no  no  7 Alert m no female Black  hispanic 1 24 no  no  no  no  no  8 Non-Alert  ftm no male other non hispanic 2 27 yes  no  yes  yes  yes  9 Seed f Unk male White  hispanic -2 28 no  yes  no  no  no  10 Non-Alert  m no female Black  non hispanic -4 23 yes  no  no  no  no  11 Seed f Unk Unknown other hispanic -6 21 no  yes  yes  yes  yes    I would like to have a output table like this:   Alert Non-Alert Seed   Male Female MSM Male Female MSM Male Female MSM Gender                   Race                   Ethnicity                   Number of Partners                   Gender_sp                   GCHX                   SXPharyngeal                   Discharge                    Dysuria                    SXAbdomen                     What is the best way to accomplish this in an efficient way? I greatly appreciate your help. ... View more

data uniqueid_count_Provider; set uniqueid_count_exclu_other; if Provider_Name1="PLANNED PARENTHOOD-EXPRESS CAPITOL DRIVE" OR Provider_Name1="PLANNED PARENTHOOD-WI AVENUE" OR Provider_Name1="PLANNED PARENTHOOD-NW" OR Provider_Name1="BRADY EAST STD CLINIC (BESTD)" OR Provider_Name1="HOLTON ST/*STD SPECIALTIES CLINIC" then Clinic="NSTD"; if Provider_Name1="MILWAUKEE HEALTH DEPARTMENT - KEENAN HEALTH CENTER" OR Provider_Name1="MILWAUKEE HEALTH DEPARTMENT - STD CLINIC" OR Provider_Name1="KHC-STD" OR Provider_Name1="KHC-FDTT" then Clinic="STD"; run; What is wrong with this code?   The log says this: 158 data uniqueid_count_Provider; 159 set uniqueid_count_exclu_other; 160 if Provider_Name1="PLANNED PARENTHOOD-EXPRESS CAPITOL DRIVE" OR Provider_Name1="PLANNED 160! PARENTHOOD-WI AVENUE" OR Provider_Name1="PLANNED PARENTHOOD-NW" 161 OR Provider_Name1="BRADY EAST STD CLINIC (BESTD)" OR Provider_Name1="HOLTON ST/*STD 161! SPECIALTIES CLINIC" then Clinic="NSTD"; 162 if Provider_Name1="MILWAUKEE HEALTH DEPARTMENT - KEENAN HEALTH CENTER" OR 162! Provider_Name1="MILWAUKEE HEALTH DEPARTMENT - STD CLINIC" 163 OR Provider_Name1="KHC-STD" OR Provider_Name1="KHC-FDTT" then Clinic="STD"; 164 run; NOTE: There were 1416 observations read from the data set WORK.UNIQUEID_COUNT_EXCLU_OTHER. NOTE: The data set WORK.UNIQUEID_COUNT_PROVIDER has 1416 observations and 21 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds   The result is this:(I am not getting the complete records with STD and NSTD categories.)  Clinic Frequency CumulativeFrequencySTDFrequency Missing = 28 40 40   ... View more

I have a daset like this   IncidentID MENSEX MaleSexPartners 1 1 0 2 10 0 3 1 1 4 1 0 5 2 0 7 5 5 10 5 0 12 5 0 13 5 0   I would like to copy variable from MENSEX variable to malesexpartners variable ONLY if malesexpartners's value is "0". I want my data to look like this IncidentID MENSEX MaleSexPartners 1 1 1 2 10 10 3 1 1 4 1 1 5 2 2 7 5 5 10 5 5 12 5 5 13 5 5 Please help me. Thank you ... View more