SAS Day 35
Once, I supposed to generate an Overall Response dataset including Label(lbl), patients with escalation(esc_y), patients without escalation(esc_n), and total patient(all) . Most of the time, the following dataset is sufficient for the purpose, however, the request was special, we have a tiny challenge.
so we need the dataset to be in exact order:
label, escalation yes, escalation no, all, order
Key statement: Retain
data t; retain lbl esc_y esc_n all ord; set all; keep esc_y lbl esc_n all ord; run;
Note：the request was really late, thanks very much to Cindy to share the Retain trick with me! so i can update it in 2 mins and go to my YOGA Class!