data perm.sales07;
infile data07;
input ID $ @;
do Quarter=1 to 4;
input Sales : comma. @;
output;
end;
run;
data perm.sales07; infile data07 missover; input ID $ Sales : comma. @;
data perm.sales07;
infile data07 missover;
input ID $ Sales : comma. @;
do while (sales ne .);
data perm.sales08; infile data08 missover; input ID $ Sales : comma. @; Quarter=0; do while (sales ne .); quarter+1;
data perm.sales08; infile data08 missover; input ID $ Sales : comma. @; Quarter=0; do while (sales ne .); quarter+1; output; input sales : comma. @; end; run;
data perm.sales08; infile data08 missover; input ID $ Sales : comma. @; Quarter=0; do while (sales ne .); quarter+1; output; input sales : comma. @; end; run;
0
.
proc print data=perm.sales08; run;
3.143.0.85