Dear All, I have a data file showed below: ID  a1  b1  c1 1   23  35  61 2   76  71  10 3   90        60 4        31   50 5   70 42  6   35 67  89 I want create a new variable 'd1' with highest number from a1, b1, c1. Thanks for your help. ... View more

Dear All, Here is my data file: ID type b1 b2 f1 f2 1   a      5  6 1   b               1   2 1   c               2   5 2   a      4  3 2   b              6   6 2   c              3   5 Variable b1 and b2 are baseline variables. f1 and f2 are follow up variables. b1 and f1 are same. b2 and f2 are same. Is there a way to combine these 2 same variables into 1 variable. Thanks for your help. ... View more

Hi, I have a excel file like below: ID wg wgunit   hg   hgunit 1 203    Lb      64.5 In (12 inches = 1 foot) 1 202.4 Lb      64.5 In (12 inches = 1 foot) 1 198    Lb      64    In (12 inches = 1 foot) 1 184    Lb      64    In (12 inches = 1 foot) 1 95      Kg      64    In (12 inches = 1 foot) 2 188    Lb      67    In (12 inches = 1 foot) 2 174.8 Lb     67    In (12 inches = 1 foot) I want to make variable with same unit. Here is my syntax: data a;   set b;   weightkg=wg;   if wgunit='lb' then weightkg=wg*0.4535924;   heightm=hg/100;   if hgunit='in' then heightm=hg*2.5/100; run; but output showed: weightkg heightm 203.000  0.6450 202.400  0.6450 198.000  0.6400 184.000  0.6400 95.000   0.6400 188.000 0.6700 174.800 0.6700 I tried to debug my syntax, but it doesn't work. Thanks for helping me. ... View more

Hi Everyone; I have a excel data file below: ID type sys dia DM RF 1   b   131 86   1   0 1   a   136 89   1   0 1   c   120 80   1   0 1   d   138 70   1   0 2   b   150 90   0   0 2   a   160 89   0   0 2   c   140 90   0   0 2   d   146 91   0   0 3   b   120 78   0   1 3   a   136 81   0   1 3   c   131 80   0   1 3   d   110 70   0   1 I want to classify when DM and RF =0, if sys>=140 or dia>=90 then bp=1; when DM=1, or RF=1, if sys>=130 or dia>=80 then bp=1; else bp=0; I have tried different ways of IF-THEN/ELSE Statements, but they did not work. Thanks you so much for helping me. ... View more

Dear All, I made a fit plot graph  with attached file using SAS 9.4, the program is below: ods listing sge = on; procreg data=baseline2; model ba=bs; run; I don't want legends especially 'observation, parameters, error DF, etc'. I appreciate your help. Thanks, Xinjian ... View more