SAS Retain1

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.

image

Challenge :

so we need the dataset to be in exact order:
label, escalation yes, escalation no, all, order

[caption id="attachment_2252" align="alignnone" width="500"] image

anaterate / Pixabay[/caption]

Solution Code:

Key statement: **Retain **

data t;
retain lbl esc_y esc_n all ord;
set all; 
keep esc_y lbl esc_n all ord;
run;

Final Output:

image

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!

Happy Practicing!