Hi Greetings!!   I have: Subject Visit Id Score alive 1005 10 0 Yes 1005 40 2 Yes 1005 50 2 Yes 1005 60 . Yes 1005 80 . Yes 1006 10 0 Yes 1006 40 0 Yes 1006 50 2 Yes 1006 60 . Yes 1006 80 . Yes 1010 10 0 No 1010 40 . No 1010 50 . No 1010 60 . No 1010 80 . No 1008 10 0 Yes 1008 40 . Yes 1008 50 . Yes 1008 60 . Yes 1008 80 . Yes 1009 10 0 Yes 1009 40 4 Yes 1009 50 . Yes 1009 60 . Yes 1009 80 . Yes   I want impute Score of 100 when "alive" is "No" for that subject (differences highlighted): Subject Visit Id Score alive 1005 10 0 Yes 1005 40 2 Yes 1005 50 2 Yes 1005 60 . Yes 1005 80 . Yes 1006 10 0 Yes 1006 40 0 Yes 1006 50 2 Yes 1006 60 . Yes 1006 80 . Yes 1010 10 0 No 1010 40 100 No 1010 50 100 No 1010 60 100 No 1010 80 100 No 1008 10 0 Yes 1008 40 . Yes 1008 50 . Yes 1008 60 . Yes 1008 80 . Yes 1009 10 0 Yes 1009 40 4 Yes 1009 50 . Yes 1009 60 . Yes 1009 80 . Yes ... View more

Greetings!   I want to apply the following calculated mean + 1 SD and mean + 2 SD to another dataset  variables a_SD1 a_SD2 b_SD1 b_SD2 c_SD1 c_SD2 d_SD1 d_SD2 level . . 1.2059 1.5366 . . . . score 1.0951 1.584 . . . . . . SAE . . . . 1.3645 2.2222 . . PD . . . . . . 2.5832 3.9519   and get a dataset like below: 1001 01MAR17:12:52:00 Placebo a_SD1 a_SD2 b_SD1 b_SD2 c_SD1 c_SD2 d_SD1 d_SD2 1002 01MAR17:13:33:00 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1003 07MAR17:22:20:00 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1004 19MAR17:09:39:00 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1005 12APR17:11:54:00 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1006 26APR17:14:46:00 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1007 26MAY17:12:45:00 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1008 27MAY17:12:12:00 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1009 12JUN17:12:53:00 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1010 28JUN17:18:42:00 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1011 29JUN17:15:01:00 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1012 16SEP17:21:21:00 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1013 17SEP17:12:50:00 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1014 01MAR17:12:52:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1015 01MAR17:13:33:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1016 07MAR17:22:20:01 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1017 19MAR17:09:39:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1018 12APR17:11:54:01 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1019 26APR17:14:46:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1020 26MAY17:12:45:01 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1021 27MAY17:12:12:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1022 12JUN17:12:53:01 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1023 28JUN17:18:42:01 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1024 29JUN17:15:01:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1025 16SEP17:21:21:01 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1026 17SEP17:12:50:01 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1027 01MAR17:12:52:02 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1028 01MAR17:13:33:02 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1029 07MAR17:22:20:02 Active 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188 1030 19MAR17:09:39:02 Placebo 1.09512 1.5839 1.20585 1.53659 1.36451 2.22223 2.58318 3.95188   Thanks as always!! ... View more

Greetings! I have a Vital Sign dataset - systolic and diastolic blood pressure measured pre and post dose Site Subject Visit Date of Assessment VS Test Result 1 1001 Baseline 2019-12-06T20:01:00 Systolic_BP 111 1 1001 Baseline 2019-12-06T20:01:00 Diastolic_BP 75 1 1001 Baseline 2019-12-06T20:01:00 Pulse 89 1 1001 predose 2019-12-06T21:32:00 Systolic_BP 157 1 1001 predose 2019-12-06T21:32:00 Diastolic_BP 72 1 1001 postdose 2019-12-06T21:43:00 Systolic_BP 112 1 1001 postdose 2019-12-06T21:43:01 Diastolic_BP 64   I want to check the consecutive Systolic and Diastolic results be compared and if there is a drop of > 40 between predose and post dose, then flagged it as below   Site Subject Visit Date of Assessment VS Test Result Flag 1 1001 Baseline 2019-12-06T20:01:00 Systolic_BP 111   1 1001 Baseline 2019-12-06T20:01:00 Diastolic_BP 75   1 1001 Baseline 2019-12-06T20:01:00 Pulse 89   1 1001 predose 2019-12-06T21:32:00 Systolic_BP 157   1 1001 predose 2019-12-06T21:32:00 Diastolic_BP 72   1 1001 postdose 2019-12-06T21:43:00 Systolic_BP 112 Drop of > 40mmHg 1 1001 postdose 2019-12-06T21:43:01 Diastolic_BP 64     Thank you! ... View more

Greetings! I want the date and time displayed as "2018-09-15T14:52:22" in my report and I found the foolowing code in SAS help, but when I tried the output still show up as "1852642342", not "2018-09-15T14:52:22".   https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=leforinforref&docsetTarget=n03vr57gdozvean1klfaaa14c9c0.htm&locale=en#n15bfl5myitg9xn17h1i0ju8vseo   What do I missed??   data one; mydt='15sep2018 14:52:22'dt; put mydt e8601dt25.3; run;   Value of mydtResult 1852642342 2018-09-15T14:52:22.000     ... View more

Hi Community,   Kind of confused now, can proc transpose do this    have Subject Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11 Var12 Var13 Var14 Var15 Var16 Var17 Var18 Var19 Var20 AB 280 294 288 270 247 259 220 252 240 206 220 262 296 248 221 233 248 253 217 270 CD 267 238 252 254 272 278 244 215 224 224 290 228 224 242 205 284 255 253 291 283   want Subject Colname Value AB Var1 280 AB Var2 294 AB Var3 288 AB Var4 270 AB Var5 247 AB Var6 259 AB Var7 220 AB Var8 252 AB Var9 240 AB Var10 206 AB Var11 220 AB Var12 262 AB Var13 296 AB Var14 248 AB Var15 221 AB Var16 233 AB Var17 248 AB Var18 253 AB Var19 217 AB Var20 270 CD Var1 267 CD Var2 238 CD Var3 252 CD Var4 254 CD Var5 272 CD Var6 278 CD Var7 244 CD Var8 215 CD Var9 224 CD Var10 224 CD Var11 290 CD Var12 228 CD Var13 224 CD Var14 242 CD Var15 205 CD Var16 284 CD Var17 255 CD Var18 253 CD Var19 291 CD Var20 283   Thank you! ... View more