Hi Community,   Happy Friday! I need to write a piece of code to do the following:     If weight_unit = ‘kg’ and weight is between Low and high in the table below, then dose_volume = value in column 3     Low   High   ≥45 ≤49 6 >49 ≤54 7 >54 ≤59 7 >59 ≤64 8 >64 ≤69 9 >69 ≤74 9 >74 ≤79 10 >79 ≤84 11 >84 ≤89 11 >89 ≤94 12 >94 ≤99 13 >99 ≤120 13.5 If weight_unit = ‘lbs’ and weight is between Low and high below, then dose_volume = value in column 3     Low   High   ≥ 99 ≤108 6 >108 ≤119 7 >119 ≤130 7 >130 ≤141 8 >141 ≤152 9 >152 ≤163 9 >163 ≤174 10 >174 ≤185 11 >185 ≤196 11 >196 ≤207 12 >207 ≤218 13 >218 ≤264 13.5    Any good code suggestion?   THANKS!! ... View more

Dear community,   I need to merge two datasets with the variable ‘Subject’, but ‘Subject’ variable appear to be different type in each dataset as below: Column Name Type Length Format Informat Subject Text 8 $8. $8.   Column Name Type Length Format Informat Subject Num 8 BEST12. BEST32.   Could someone tell me how I can convert the type ‘Num’ to ‘Text’ or ‘Text’ to ‘Num’, please.   Thank you ... View more

Dear fellow community,   I am running a simple Proc Freq   data example1; input x y $ z; cards; 6 A 60 6 A 70 2 A 100 2 B 10 3 B 67 2 C 81 3 C 63 5 C 55 ; run;   proc freq data = example1; tables y * x / norow nocol nopercent out = test; run; The output dataset ‘test’ looks like below: y x Frequency Percent of Count Total Frequency A 2 1 12.5 A 6 2 25 B 2 1 12.5 B 3 1 12.5 C 2 1 12.5 C 3 1 12.5 C 5 1 12.5   But I really want my test dataset looks exactly as it appears in the result view window as below, is there any simple way to do this without going through proc transpose   Frequency Table of y by x y x 2 3 5 6 Total A 1 0 0 2 3 B 1 1 0 0 2 C 1 1 1 0 3 Total 3 2 1 2 8    Thanks as always! ... View more

  Hi Community,   I have a dataset where I need only to change the red vs2 date to a day later  (in below the first vs2 date really should be 24APR2015:00:06:00) and the last vs2 date really should be 22NOV2017:00:04:00, while the other dates should remain the same. How should I handle situation like this?  Thanks as always    vs1 vs2 23APR2015:23:51:00 23APR2015:00:06:00 05MAY2015:13:00:00 05MAY2015:12:59:00 06JUN2015:18:52:00 06JUN2015:18:52:00 23AUG2015:23:32:00 23AUG2015:23:30:00 10SEP2015:20:39:00 10SEP2015:20:32:00 23SEP2015:21:48:00 23SEP2015:21:44:00 07DEC2015:12:45:00 07DEC2015:12:27:00 21NOV2017:23:40:00 21NOV2017:00:04:00 ... View more