想得到如下的字符串：
第一位是A1里的，第二位是A2里的，第三位是A3里的。
该怎么编程呢？
我做的循环大致如下：（按列，新建3个数据集）
set a b c;
do i=1 to 14;
if ida=i then name1=na;
do j=1 to 12;
if idb=j then name2=nb;
do k=1 to 12;
if idc=k then name3=nc;
namef=trim(name1)||trim(name2)||trim(name3);
end;end;end;
data a;
do ida =1 to 14;
na=byte(64+ida);
output;
end;
run;
data b;
do idb =1 to 12;
nb=byte(96+idb);
output;
end;
run;
data c;
do idc=1 to 12;
nc=cats(idc);
output;
end;
run;
proc sql;
create table test as
select distinct ida,idb,idc,na as name1, nb as name2, nc as name3
, cats(na,nb,nc) as namef
from a,b,c
order by ida,idb,idc;
quit;
data test1;
set a;
do i=1 to nobs_b;
set b nobs=nobs_b point=i;
do j=1 to nobs_c;
set c nobs=nobs_c point=j;
name1=na; name2=nb; name3=nc;
namef=cats(name1,name2,name3);
output;
end;
end;
run;
扫码加好友，拉您进群
全部版块
我的主页
收藏
