Hi Community,   Here I have a sample dataset, I want to extract the gram/milligram values from the string. I tried up with compress method, but even I need more efficient step to extract in particular format.   data have; input drug1$30.; cards; metformin 500MG Glycopride 250mg GLYCOMET 1GM gLYCOMET 1GM GLYCIPHAGE 850MG GLYCIPHAGE 500mg ; run; data want; set have; d1 = compress(drug1,'1234567890mgMG','k'); run; SAS Output Obs drug1 d1123456 metformin 500MG mm500MG Glycopride 250mg G250mg GLYCOMET 1GM GM1GM gLYCOMET 1GM gM1GM GLYCIPHAGE 850MG GG850MG GLYCIPHAGE 500mg GG500mg   Expected Output  500MG 250mg 1GM 850MG 500mg Please suggest the code which extract the output in the given format.   NOTE : To more simpler, Atleast let me know how to remove the characters in front of numeric value.   Thanks in advance!   ... View more

Hi all,   Here I have tried with the formula but I get a partial output. By using the sample data set please proceed with the formula code.   data have; input age bmi diab diab_bln$ alt ast plat albu; cards; 61.3 25.43252595 1 no 22 18 3.29 3.2 74.4 30.04768905 2 yes 23 17 2.29 4.2 70.4 24.26987561 22 yes 19 21 2.98 4.4 56.4 38.17497196 5 no 33 25 1.97 4.4 75.4 40.96495221 2 yes 49 103 1.84 3.2 69.4 21.60288505 8 no 16 15 2.64 4.1 run; proc print; run; /*Apart from 2 and 22, whatever the value on diab column it should be NO in diab_bln column*/ data want; set have; Score = -1.675+(0.037*age)+(0.094*bmi)+(1.13*(diab_bln = ifn(diab_bln='yes')* 1)) + (0.99*AST/ALT) - (0.013*plat) - (0.66*albu); run; proc print; run;   This is the exact formula: NAFLD Score = -1.675 + (0.037*age[years]) + (0.094*BMI) + (1.13*diab [yes = 1, no = 0]) + (0.99*AST/ALT ratio) – (0.013*platelet count [×109/L]) – (0.66*albumin)   You may get any answer by using the formula but  To cross check the result, The given link will use to verify the score value.   https://qxmd.com/calculate/calculator_341/nafld-fibrosis-score   Thanks in advance!     ... View more

Hi community,   Here i have a example dataset    data xxx; input col1 col2 col3; cards; 20 20 25.34 55 10 22.33 42 55 22.22 22 45 14.22 run; proc print; run; I want to summarize the value using   Var Yes No col1≥40 2 0 col2/col1 ratio≥1 1 0 col3≥25 1.5 0   The output should be like, Condition: if col11 ge 40 and ratio ge 1 and col3 ge 25  result = 4.5     Result   2.5 (0+1+1.5) 3 (2+1+0) 2 (2+0+0) 0 (0+0+0) I'm looking for Result column. I can done this by calculate individual column. but that takes more time and line of codes. Can anyone suggest me the effective codes to resolve this method. ... View more

Hi Community,   Just consider the dataset as an example.  w - wood; p- plastic ; s - steel  ; Items 1 2 3 4 5....(wooditem1 w1; plasticitem5 p5; steelitem3 s3 and so on).... Here these 3 stuffs have a value. I want to sum up the value by category.   data xxx; input aa$ bb$ cc$ dd$ c1 c2 c3 c4; cards; w1 p2 s4 w3 10 45 14 5 s1 s3 w2 p4 20 14 15 84 p2 w4 w5 w4 12 18 45 7 s1 w3 p5 s2 23 56 87 44 run; proc print data = xxx; run; This is how my output should be as a result     W S P 15 14 45 34 15 84 12 0 70 … … … Could any one suggest some code by SAS or Proc SQL to resolve it. Thanks in advance! ... View more

Hi Community,   I tried to get an output in PDF format in (D:\ drive) ods pdf file ='D:\egfr.pdf'; proc print data = fbs5; var fbs5_mean; run; ods pdf close; Once i run this program, I get a result in (sas9.4) output window. There is no pdf file in given location as well in my log    84 ods pdf close; 85 ods pdf file ='D:\egfr.pdf' ; ERROR: Physical file does not exist, C:\WINDOWS\Fonts\saswcur.ttf.. 86 proc print data = fbs5; 87 run;   Please suggest some ideas to solve it. ... View more

Hi community,   In  the given table few of dates are not convert to the actual column pls help me to resolve it. data dos; set proj.saswrk; diab_date = input(strip(diab_dateonset),mmddyy10.); format diab_date mmddyy10.; run; Diab_dateonset - varchar datatype   Diab_dateonset diab_date 14/03/2009 . 21/11/1992 .   .   .   . 09/10/2006 09/10/2006   .   . 07/08/2010 07/08/2010 14/08/2009 . 15/03/2012 .   . 25/04/2013 . 09/12/2009 09/12/2009   . 08/08/2015 08/08/2015   ... View more