cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mayasak
‎02-20-2024
  • 140 Posts
  • 27 Likes Given
  • 1 Solutions
  • 1 Likes Received

Re: percent of total

by Quartz | Level 8 in SAS Programming
‎12-09-2021 10:32 AM
‎12-09-2021 10:32 AM
When I run the code, I get the ps_n, it_n and ns_n for each hospital in a drug_bug combination and a total for all the hospitals' ps_n, it_n and ns_n. What I need is the % of ps_n for all hospitals and not the totals. ... View more

Re: percent of total

by Quartz | Level 8 in SAS Programming
‎12-08-2021 04:39 PM
‎12-08-2021 04:39 PM
Hi, I've posted the datalines and the code I used for the analysis. Just checking if you had the time to look at it!   Thank you ... View more

Re: percent of total

by Quartz | Level 8 in SAS Programming
‎12-05-2021 12:55 PM
‎12-05-2021 12:55 PM
The code gives me aggregates for each drug_bug combination and Ps (percent susceptible) for each hospital within the drug_bug combination. For example, for each combination I got the percent susceptibility for each hospital. What I'm looking for is an aggregate percent susceptibility for all hospitals combined, if possible. Thank you ... View more

Re: percent of total

by Quartz | Level 8 in SAS Programming
‎12-04-2021 08:53 PM
‎12-04-2021 08:53 PM
Thank you.   Here's the code I ran.   data final_drugbug;   set hou.Drugbug_combined_gn_2020;   if ns_n='.' then delete;   if ns_n =0 then delete;   if it_n='.' then it_n=isolates_hospital_n; run;   And here's the data step with datalines sample:   data Get; length filename $150 hospital $150 drug_bug $500 drug $300 bug $300 OrganismName $300; input filename $ hospital $ type $ drug_bug $ drug $ bug $ OrganismName $ isolates_hospital it ps psd isolate_hospital_n it_n ps_n ns_n psd_n nsd_n;    datalines; C:\Users\StMary_AB2020.xlsm StMary NM Amikacin-Ecoli Amikacin Ecoli Ecoli 54 54 96 4 54 54 0.96 52 0.04 2 C:\Users\Memorial_AB2020.xlsm Memorial NM Ampicillin_Strep Ampicillin Strep Strep 19 19 95 5 19 19 0.95 18 0.05 1 C:\Users\Medical_AB2020.xlsm Medical NM Toromycin_Enterobac Toromycin Enterobac Enterobac 195 190 88 5 195 190 0.92 175 0.05 10 ; run;   proc sort data= final_drugbug;   by drug_bug; run; proc univariate data=final_drugbug;   by drug_bug;   var ps_n;   histogram;   output out=means mean=ps_mean std=ps_std; run;   data MDRO_2020;   merge final_drugbug means;   by drug_bug; run;   proc print data=MDRO_2020;   by drug_bug;   sum it_n ps_n ns_n;   var hospital drug bug isolates_hospital_n it_n ps_n ns_n; run;   proc print data=MDRO_2020 noobs;   where abs(ps_n-ps_mean) > 2*ps_std ;   by drug_bug;   var hospital drug bug isolates_hospital_n it_n ps_n ns_n; run; ... View more

Re: percent of total

by Quartz | Level 8 in SAS Programming
‎12-04-2021 08:39 PM
‎12-04-2021 08:39 PM
Thank you Koen. Here's a data step with datalines:   data Get;    length filename $150 hospital $150 drug_bug $500 drug $300 bug $300 OrganismName $300; input filename $ hospital $ type $ drug_bug $ drug $ bug $ OrganismName $ isolates_hospital it ps psd isolate_hospital_n it_n ps_n ns_n psd_n nsd_n;    datalines; C:\Users\StMary_AB2020.xlsm StMary NM Amikacin-Ecoli Amikacin Ecoli Ecoli 54 54 96 4 54 54 0.96 52 0.04 2 C:\Users\Memorial_AB2020.xlsm Memorial NM Ampicillin_Strep Ampicillin Strep Strep 19 19 95 5 19 19 0.95 18 0.05 1 C:\Users\Medical_AB2020.xlsm Medical NM Toromycin_Enterobac Toromycin Enterobac Enterobac 195 190 88 5 195 190 0.92 175 0.05 10 ; run; ... View more

percent of total

by Quartz | Level 8 in SAS Programming
‎12-04-2021 03:35 AM
‎12-04-2021 03:35 AM
  Hi, I'm working on a complex data set which includes the % susceptibility, number of isolates tested for different bug drug combinations in different hospitals. So each hospital has the following:   I ran my SAS coding and got the total numbers of isolates tested  and total number of susceptibles for each drug-bug combination in all the hospitals:   My report should have the % susceptible for all hospitals in each drug-organism (bug) combinations as below: and: So is there a way to aggregate the data in one % susceptible for all hospitals in each drug-bug combination instead of having them the way I did?   Thank you       ... View more

Re: Using macros in reports

by Quartz | Level 8 in SAS Programming
‎11-30-2021 02:51 PM
‎11-30-2021 02:51 PM
Thank you Tom. It worked but I have a question. Is there a way that we get aggregated, hospital numbers, ps_n (percent susceptibility) and # of isolates (ns_n)  data for each drug-bug combinations as in the table below?.      ... View more

Re: Using macros in reports

by Quartz | Level 8 in SAS Programming
‎11-29-2021 10:43 PM
‎11-29-2021 10:43 PM
Thank you, the drug_bug variable is the one changing from each iteration.   ... View more

Using macros in reports

by Quartz | Level 8 in SAS Programming
‎11-29-2021 06:52 PM
‎11-29-2021 06:52 PM
I'm preparing a report that shows % susceptibilities for different drug-bugs combinations, histogram, IQR for % susceptibles, number of hospitals, number of isolates (ns_n) and number of susceptibles (ps_n)  and I'm using the following:    proc sort data= drugbug_combined out=drugbug; by drug_bug; run; data 2018_drugbug; set drugbug; if ns_n='.' then delete; if ns_n =0 then delete; run; data final_drugbug; set 2018_drugbug; if it_n='.' then do; it_n=isolates_hospital_n; end; run; proc univariate data=final_drugbug; by drug_bug; var ps_n; where drug_bug='Drug1 bug 1'; histogram; run; data Ami_ab; set final_drugbug; where drug_bug='Drug1 bug 1'; run; proc sql noprint;; select mean (ps_n) into: mean from Ami_ab; select std (ps_n) into : std from Ami_ab; quit; data Ami_abQC; set Ami_ab; where drug_bug='Drug 1 bug 1' AND ps_n< &mean-2*&std OR ps_n > &mean+2*&std; proc print noobs; var hospital drug_bug drug bug isolates_hospital_n it_n ps_n ns_n; run; proc print data=Ami_ab; sum it_n ps_n ns_n; var hospital drug_bug drug bug isolates_hospital_n it_n ps_n ns_n; run;   I would like to use a macro since I have more than 25 different drug bug combinations.   Thank you   ... View more

Re: WHERE clause operator requires compatible variables Error

by Quartz | Level 8 in SAS Programming
‎01-06-2021 02:13 PM
‎01-06-2021 02:13 PM
There are 2 values for "test_loinc" and more values for "test_result" such as results with all lower case and results with mixedletters (first letter only upper case). Thank you, Razina ... View more

Re: WHERE clause operator requires compatible variables Error

by Quartz | Level 8 in SAS Programming
‎01-06-2021 01:17 PM
‎01-06-2021 01:17 PM
Thank you, I expanded this to: select (test_loinc); when ("94759-8") do; select (upcase(test_result)); when ("DETECTED") result_snomed = 260373001; when ("NEGATIVE") result_snomed = 260385009; when ("POSITIVE") result_snomed = 10828004; otherwise result_snomed = 260415000; end; select (lowcase(test_result)); when ("detected") result_snomed = 260373001; when ("negative") result_snomed = 260385009; when ("positive") result_snomed = 10828004; otherwise result_snomed = 260415000; end; select (propcase(test_result)); when ("Detected") result_snomed = 260373001; when ("Negative") result_snomed = 260385009; when ("Positive") result_snomed = 10828004; otherwise result_snomed = 260415000; end; end; when ("94558-4") do; select (upcase(test_result)); when ("DETECTED") result_snomed = 260373001; when ("NEGATIVE") result_snomed = 260385009; when ("POSITIVE") result_snomed = 10828004; otherwise result_snomed = 260415000; end; select (lowcase(test_result)); when ("detected") result_snomed = 260373001; when ("negative") result_snomed = 260385009; when ("positive") result_snomed = 10828004; otherwise result_snomed = 260415000; end; select (propcase(test_result)); when ("Detected") result_snomed = 260373001; when ("Negative") result_snomed = 260385009; when ("Positive") result_snomed = 10828004; otherwise result_snomed = 260415000; end; end; end;   Does it look fine? Especially for the use of end; Thank you, Razina   ... View more

Re: WHERE clause operator requires compatible variables Error

by Quartz | Level 8 in SAS Programming
‎01-06-2021 09:56 AM
‎01-06-2021 09:56 AM
data; input name $ test_loinc $ test_result $; datalines; John 94759-8 Positive Michelle 94558-4 Not detected Grace 94759-8 DETECTED ; So the issue is that we're getting an excel sheet from a hospital that have different variables (in additition to the test_result and test_loinc) and we need to import into to our system. They use only 2 loincs (tests) (used in the example) and the result comes in different formats such as DETECTED, Detected, Positive, positive... etc. What I needed to do is to code all different result formats into the standard snomed (results) codes such as 10828004 for all postive results because our system accepts only codes for loincs and snomeds. BTW I'm not sure if the test_result is a character or numerical but I'm assuming it's a character in the example! Thank you     ... View more

WHERE clause operator requires compatible variables Error

by Quartz | Level 8 in SAS Programming
‎01-06-2021 08:16 AM
‎01-06-2021 08:16 AM
Hi,   I have this SAS code that I need to use so I can have the snomed codes to cover all the types of result texts that I have in excel sheet.   if test_loinc="94558-4" then do; /*Note: this is an antigen test*/ result_snomed=10828004; where (test_result="Positive" or test_result="POSITIVE" or test_result="positive"); result_snomed=260373001; where (test_result="Detected" or test_result="DETECTED" or test_result="detected"); result_snomed=260385009; where (test_result="Negative" or test_result="NEGATIVE" or test_result="negative"); result_snomed=260415000; where (test_result="Not Detected" or test_result="NOT DETECTED" or test_result="not detected" or test_result="Not detected"); end; else if test_loinc="94759-8" then do; /*Note: this is a PCR test*/ result_snomed=10828004; where (test_result="Positive" or test_result="POSITIVE" or test_result="positive"); result_snomed=260373001; where (test_result="Detected" or test_result="DETECTED" or test_result="detected"); result_snomed=125154007; where (test_result="Unsatisfactory" or test_result="UNSATISFACTORY" or test_result="unsatisfactory"); result_snomed=260385009; where (test_result="Negative" or test_result="NEGATIVE" or test_result="negative"); result_snomed=260415000; where (test_result="Not Detected" or test_result="NOT DETECTED" or test_result="not detected" or test_result="Not detected"); result_snomed=280416009; where (test_result="Indeterminate" or test_result="INDETERMINATE" or test_result="indeterminate"); result_snomed=419984006; where (test_result="Inconclusive" or test_result="INCONCLUSIVE" or test_result="inconclusive"); end;   First thing I got this error (after each if statement): if test_loinc="94558-4" then do; /*Note: this is an antigen test*/ 220 result_snomed=10828004; 221 where (test_result="Positive" 222 or test_result="POSITIVE" 223 or test_result="positive"); ERROR: WHERE clause operator requires compatible variables. Also is there another simpler way to do this rather than having this long code? Thank you.   ... View more

Re: Format phone numbers

by Quartz | Level 8 in SAS Programming
‎12-16-2020 06:25 PM
‎12-16-2020 06:25 PM
This actually worked thank you so much ... View more

Format phone numbers

by Quartz | Level 8 in SAS Programming
‎12-15-2020 10:13 PM
1 Like
‎12-15-2020 10:13 PM
1 Like
Hi, I have data sets that have mixed formats of phone numbers such as: +1 (915) 111-1111 + (202) 509-3114 +1 (915) 1234567 + (202) 5093114 (777) 123-4567 3334445678 123.222.1334 How can I standardize the numbers into the following format: 717-333-4545 Thank you       ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-20-2024 03:05 PM
Likes given to
Likes from
View All
Quick links