Massive brain spasms
Oct. 10th, 2006 11:51 am
Honestly, sometimes we open up a box from Japan and think, WTF?
Srsly, try spending your day writing stuffs like
%macro wide2long(var, dsn);
data ncc.&var; set ncc.&dsn;
keep id &var._2 &var._1 &var.0-&var.2;
run;
proc sort data=ncc.&var; by id; run;
proc transpose data=ncc.&var out=ncc.&var;
var &var._2 &var._1 &var.0-&var.2;
by id;
run;
data ncc.&var; set ncc.&var (rename=(col1=&var.));
if not missing(&var.);
year1=substr(_name_, %length(&var)+1, 2);
year=input(year1, ?? 2.);
if year1="_2" then year=-2;
if year1="_1" then year=-1;
keep id year &var.;
run;
proc sort data=ncc.&var; by id year; run;
%mend;
...for an hour or two and see whether you remember clicking on the "buy it now" box.

Aw, it's just adorable little finger rings. We're flying on cute autopilot!
Oooh....
Date: 2006-10-11 03:56 am (UTC)Re: Oooh....
Date: 2006-10-11 03:34 pm (UTC)Re: Oooh....
Date: 2006-10-11 04:33 pm (UTC)Re: Oooh....
Date: 2006-10-12 03:11 am (UTC)