Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
proc sort data=oldTab; by tiliA tiliB; run;
data newTab;
set oldTab (rename=(tiliB=oneB));
by tiliA;
length tiliB $50; /* or whatever length you need */
retain tiliB;
if first.tiliA
then tiliB = left(oneB);
else tiliB = trim(tiliB) !! ' ' !! left(oneB);
if last.tiliA then
output;
run;