how to repeat a data set

[changxuosu]

Dear SAS community,

I have a data set like this

A

B

C

D

I want to repeat it 1000 times like

A

B

C

D

A

B

C

D

A

B

C

D

.

.

.

.

.

Is there any SAS function that achives this?

Thank you all! Happy holliday!

[FreelanceReinh]

Hi @changxuosu,

Try this if you really need that much redundancy in a dataset:

data want;
do repno=1 to 1000;
  do _n_=1 to n;
    set have nobs=n point=_n_;
    output;
  end;
end;
stop;
run;

You can drop variable REPNO if you don't need it (insert drop repno; between the STOP and the RUN statement).

[kiranv_]

one way to do is to use macro and proc append

 data have;
 input word $;
 datalines;
 A
 B
 C
 D
;
%macro abc;
%do i = 1 %to 1000;
PROC APPEND
     BASE=want
     DATA=have;
RUN;
%end;
%mend;

%abc;

[novinosrin]

Are you sure?

[kiranv_]

data have;
 input word $;
 datalines;
 A
 B
 C
 D
;
%macro abc;
%do i = 1 %to 1000;
PROC APPEND
     BASE=want
     DATA=have;
RUN;
%end;
%mend;

%abc;

proc sql number;
select * from want;

sure. I tried out, with and without %left it works

[novinosrin]

Can you show us the log output plz for both your codes and see if it producing 4000 records i.e 1000 repetitions as stated objective?

[kiranv_]

my log was pointed to another location. I see what you are saying. 

[novinosrin]

Forget the log, your results are not accurate

[Reeza]

---

@novinosrin wrote:

Forget the log, your results are not accurate

---

It works for me...but doesn't need the data _null_. It terminates automatically at the start of the PROC APPEND but doesn't affect the results.

SAS Output

word	Frequency	Percent	Cumulative Frequency	Cumulative Percent
A	1000	25.00	1000	25.00
B	1000	25.00	2000	50.00
C	1000	25.00	3000	75.00
D	1000	25.00	4000	100.00

[kiranv_]

you are right. thanks @Reeza and I have removed data _null_

[Reeza]

@kiranv_ your post with Data&i may be incorrect, not sure that one will work correctly. 

[kiranv_]

 @Reeza  code still works with a warning as shown below, but obviously it is not right way to do , so I have corrected that one too

93               DATA2
                  _____
                  1
 WARNING 1-322: Assuming the symbol DATA was misspelled as DATA2.

[kiranv_]

see the output and let me know if it is wrong, I will delete my answer, if you feel so

Obs	word
1	A
2	B
3	C
4	D
5	A
6	B
7	C
8	D
9	A
10	B
11	C
12	D
13	A
14	B
15	C
16	D
17	A
18	B
19	C
20	D
21	A
22	B
23	C
24	D
25	A
26	B
27	C
28	D
29	A
30	B
31	C
32	D
33	A
34	B
35	C
36	D
37	A
38	B
39	C
40	D
41	A
42	B
43	C
44	D
45	A
46	B
47	C
48	D
49	A
50	B
51	C
52	D
53	A
54	B
55	C
56	D
57	A
58	B
59	C
60	D
61	A
62	B
63	C
64	D
65	A
66	B
67	C
68	D
69	A
70	B
71	C
72	D
73	A
74	B
75	C
76	D
77	A
78	B
79	C
80	D
81	A
82	B
83	C
84	D
85	A
86	B
87	C
88	D
89	A
90	B
91	C
92	D
93	A
94	B
95	C
96	D
97	A
98	B
99	C
100	D
101	A
102	B
103	C
104	D
105	A
106	B
107	C
108	D
109	A
110	B
111	C
112	D
113	A
114	B
115	C
116	D
117	A
118	B
119	C
120	D
121	A
122	B
123	C
124	D
125	A
126	B
127	C
128	D
129	A
130	B
131	C
132	D
133	A
134	B
135	C
136	D
137	A
138	B
139	C
140	D
141	A
142	B
143	C
144	D
145	A
146	B
147	C
148	D
149	A
150	B
151	C
152	D
153	A
154	B
155	C
156	D
157	A
158	B
159	C
160	D
161	A
162	B
163	C
164	D
165	A
166	B
167	C
168	D
169	A
170	B
171	C
172	D
173	A
174	B
175	C
176	D
177	A
178	B
179	C
180	D
181	A
182	B
183	C
184	D
185	A
186	B
187	C
188	D
189	A
190	B
191	C
192	D
193	A
194	B
195	C
196	D
197	A
198	B
199	C
200	D
201	A
202	B
203	C
204	D
205	A
206	B
207	C
208	D
209	A
210	B
211	C
212	D
213	A
214	B
215	C
216	D
217	A
218	B
219	C
220	D
221	A
222	B
223	C
224	D
225	A
226	B
227	C
228	D
229	A
230	B
231	C
232	D
233	A
234	B
235	C
236	D
237	A
238	B
239	C
240	D
241	A
242	B
243	C
244	D
245	A
246	B
247	C
248	D
249	A
250	B
251	C
252	D
253	A
254	B
255	C
256	D
257	A
258	B
259	C
260	D
261	A
262	B
263	C
264	D
265	A
266	B
267	C
268	D
269	A
270	B
271	C
272	D
273	A
274	B
275	C
276	D
277	A
278	B
279	C
280	D
281	A
282	B
283	C
284	D
285	A
286	B
287	C
288	D
289	A
290	B
291	C
292	D
293	A
294	B
295	C
296	D
297	A
298	B
299	C
300	D
301	A
302	B
303	C
304	D
305	A
306	B
307	C
308	D
309	A
310	B
311	C
312	D
313	A
314	B
315	C
316	D
317	A
318	B
319	C
320	D
321	A
322	B
323	C
324	D
325	A
326	B
327	C
328	D
329	A
330	B
331	C
332	D
333	A
334	B
335	C
336	D
337	A
338	B
339	C
340	D
341	A
342	B
343	C
344	D
345	A
346	B
347	C
348	D
349	A
350	B
351	C
352	D
353	A
354	B
355	C
356	D
357	A
358	B
359	C
360	D
361	A
362	B
363	C
364	D
365	A
366	B
367	C
368	D
369	A
370	B
371	C
372	D
373	A
374	B
375	C
376	D
377	A
378	B
379	C
380	D
381	A
382	B
383	C
384	D
385	A
386	B
387	C
388	D
389	A
390	B
391	C
392	D
393	A
394	B
395	C
396	D
397	A
398	B
399	C
400	D
401	A
402	B
403	C
404	D
405	A
406	B
407	C
408	D
409	A
410	B
411	C
412	D
413	A
414	B
415	C
416	D
417	A
418	B
419	C
420	D
421	A
422	B
423	C
424	D
425	A
426	B
427	C
428	D
429	A
430	B
431	C
432	D
433	A
434	B
435	C
436	D
437	A
438	B
439	C
440	D
441	A
442	B
443	C
444	D
445	A
446	B
447	C
448	D
449	A
450	B
451	C
452	D
453	A
454	B
455	C
456	D
457	A
458	B
459	C
460	D
461	A
462	B
463	C
464	D
465	A
466	B
467	C
468	D
469	A
470	B
471	C
472	D
473	A
474	B
475	C
476	D
477	A
478	B
479	C
480	D
481	A
482	B
483	C
484	D
485	A
486	B
487	C
488	D
489	A
490	B
491	C
492	D
493	A
494	B
495	C
496	D
497	A
498	B
499	C
500	D
501	A
502	B
503	C
504	D
505	A
506	B
507	C
508	D
509	A
510	B
511	C
512	D
513	A
514	B
515	C
516	D
517	A
518	B
519	C
520	D
521	A
522	B
523	C
524	D
525	A
526	B
527	C
528	D
529	A
530	B
531	C
532	D
533	A
534	B
535	C
536	D
537	A
538	B
539	C
540	D
541	A
542	B
543	C
544	D
545	A
546	B
547	C
548	D
549	A
550	B
551	C
552	D
553	A
554	B
555	C
556	D
557	A
558	B
559	C
560	D
561	A
562	B
563	C
564	D
565	A
566	B
567	C
568	D
569	A
570	B
571	C
572	D
573	A
574	B
575	C
576	D
577	A
578	B
579	C
580	D
581	A
582	B
583	C
584	D
585	A
586	B
587	C
588	D
589	A
590	B
591	C
592	D
593	A
594	B
595	C
596	D
597	A
598	B
599	C
600	D
601	A
602	B
603	C
604	D
605	A
606	B
607	C
608	D
609	A
610	B
611	C
612	D
613	A
614	B
615	C
616	D
617	A
618	B
619	C
620	D
621	A
622	B
623	C
624	D
625	A
626	B
627	C
628	D
629	A
630	B
631	C
632	D
633	A
634	B
635	C
636	D
637	A
638	B
639	C
640	D
641	A
642	B
643	C
644	D
645	A
646	B
647	C
648	D
649	A
650	B
651	C
652	D
653	A
654	B
655	C
656	D
657	A
658	B
659	C
660	D
661	A
662	B
663	C
664	D
665	A
666	B
667	C
668	D
669	A
670	B
671	C
672	D
673	A
674	B
675	C
676	D
677	A
678	B
679	C
680	D
681	A
682	B
683	C
684	D
685	A
686	B
687	C
688	D
689	A
690	B
691	C
692	D
693	A
694	B
695	C
696	D
697	A
698	B
699	C
700	D
701	A
702	B
703	C
704	D
705	A
706	B
707	C
708	D
709	A
710	B
711	C
712	D
713	A
714	B
715	C
716	D
717	A
718	B
719	C
720	D
721	A
722	B
723	C
724	D
725	A
726	B
727	C
728	D
729	A
730	B
731	C
732	D
733	A
734	B
735	C
736	D
737	A
738	B
739	C
740	D
741	A
742	B
743	C
744	D
745	A
746	B
747	C
748	D
749	A
750	B
751	C
752	D
753	A
754	B
755	C
756	D
757	A
758	B
759	C
760	D
761	A
762	B
763	C
764	D
765	A
766	B
767	C
768	D
769	A
770	B
771	C
772	D
773	A
774	B
775	C
776	D
777	A
778	B
779	C
780	D
781	A
782	B
783	C
784	D
785	A
786	B
787	C
788	D
789	A
790	B
791	C
792	D
793	A
794	B
795	C
796	D
797	A
798	B
799	C
800	D
801	A
802	B
803	C
804	D
805	A
806	B
807	C
808	D
809	A
810	B
811	C
812	D
813	A
814	B
815	C
816	D
817	A
818	B
819	C
820	D
821	A
822	B
823	C
824	D
825	A
826	B
827	C
828	D
829	A
830	B
831	C
832	D
833	A
834	B
835	C
836	D
837	A
838	B
839	C
840	D
841	A
842	B
843	C
844	D
845	A
846	B
847	C
848	D
849	A
850	B
851	C
852	D
853	A
854	B
855	C
856	D
857	A
858	B
859	C
860	D
861	A
862	B
863	C
864	D
865	A
866	B
867	C
868	D
869	A
870	B
871	C
872	D
873	A
874	B
875	C
876	D
877	A
878	B
879	C
880	D
881	A
882	B
883	C
884	D
885	A
886	B
887	C
888	D
889	A
890	B
891	C
892	D
893	A
894	B
895	C
896	D
897	A
898	B
899	C
900	D
901	A
902	B
903	C
904	D
905	A
906	B
907	C
908	D
909	A
910	B
911	C
912	D
913	A
914	B
915	C
916	D
917	A
918	B
919	C
920	D
921	A
922	B
923	C
924	D
925	A
926	B
927	C
928	D
929	A
930	B
931	C
932	D
933	A
934	B
935	C
936	D
937	A
938	B
939	C
940	D
941	A
942	B
943	C
944	D
945	A
946	B
947	C
948	D
949	A
950	B
951	C
952	D
953	A
954	B
955	C
956	D
957	A
958	B
959	C
960	D
961	A
962	B
963	C
964	D
965	A
966	B
967	C
968	D
969	A
970	B
971	C
972	D
973	A
974	B
975	C
976	D
977	A
978	B
979	C
980	D
981	A
982	B
983	C
984	D
985	A
986	B
987	C
988	D
989	A
990	B
991	C
992	D
993	A
994	B
995	C
996	D
997	A
998	B
999	C
1000	D
1001	A
1002	B
1003	C
1004	D
1005	A
1006	B
1007	C
1008	D
1009	A
1010	B
1011	C
1012	D
1013	A
1014	B
1015	C
1016	D
1017	A
1018	B
1019	C
1020	D
1021	A
1022	B
1023	C
1024	D
1025	A
1026	B
1027	C
1028	D
1029	A
1030	B
1031	C
1032	D
1033	A
1034	B
1035	C
1036	D
1037	A
1038	B
1039	C
1040	D
1041	A
1042	B
1043	C
1044	D
1045	A
1046	B
1047	C
1048	D
1049	A
1050	B
1051	C
1052	D
1053	A
1054	B
1055	C
1056	D
1057	A
1058	B
1059	C
1060	D
1061	A
1062	B
1063	C
1064	D
1065	A
1066	B
1067	C
1068	D
1069	A
1070	B
1071	C
1072	D
1073	A
1074	B
1075	C
1076	D
1077	A
1078	B
1079	C
1080	D
1081	A
1082	B
1083	C
1084	D
1085	A
1086	B
1087	C
1088	D
1089	A
1090	B
1091	C
1092	D
1093	A
1094	B
1095	C
1096	D
1097	A
1098	B
1099	C
1100	D
1101	A
1102	B
1103	C
1104	D
1105	A
1106	B
1107	C
1108	D
1109	A
1110	B
1111	C
1112	D
1113	A
1114	B
1115	C
1116	D
1117	A
1118	B
1119	C
1120	D
1121	A
1122	B
1123	C
1124	D
1125	A
1126	B
1127	C
1128	D
1129	A
1130	B
1131	C
1132	D
1133	A
1134	B
1135	C
1136	D
1137	A
1138	B
1139	C
1140	D
1141	A
1142	B
1143	C
1144	D
1145	A
1146	B
1147	C
1148	D
1149	A
1150	B
1151	C
1152	D
1153	A
1154	B
1155	C
1156	D
1157	A
1158	B
1159	C
1160	D
1161	A
1162	B
1163	C
1164	D
1165	A
1166	B
1167	C
1168	D
1169	A
1170	B
1171	C
1172	D
1173	A
1174	B
1175	C
1176	D
1177	A
1178	B
1179	C
1180	D
1181	A
1182	B
1183	C
1184	D
1185	A
1186	B
1187	C
1188	D
1189	A
1190	B
1191	C
1192	D
1193	A
1194	B
1195	C
1196	D
1197	A
1198	B
1199	C
1200	D
1201	A
1202	B
1203	C
1204	D
1205	A
1206	B
1207	C
1208	D
1209	A
1210	B
1211	C
1212	D
1213	A
1214	B
1215	C
1216	D
1217	A
1218	B
1219	C
1220	D
1221	A
1222	B
1223	C
1224	D
1225	A
1226	B
1227	C
1228	D
1229	A
1230	B
1231	C
1232	D
1233	A
1234	B
1235	C
1236	D
1237	A
1238	B
1239	C
1240	D
1241	A
1242	B
1243	C
1244	D
1245	A
1246	B
1247	C
1248	D
1249	A
1250	B
1251	C
1252	D
1253	A
1254	B
1255	C
1256	D
1257	A
1258	B
1259	C
1260	D
1261	A
1262	B
1263	C
1264	D
1265	A
1266	B
1267	C
1268	D
1269	A
1270	B
1271	C
1272	D
1273	A
1274	B
1275	C
1276	D
1277	A
1278	B
1279	C
1280	D
1281	A
1282	B
1283	C
1284	D
1285	A
1286	B
1287	C
1288	D
1289	A
1290	B
1291	C
1292	D
1293	A
1294	B
1295	C
1296	D
1297	A
1298	B
1299	C
1300	D
1301	A
1302	B
1303	C
1304	D
1305	A
1306	B
1307	C
1308	D
1309	A
1310	B
1311	C
1312	D
1313	A
1314	B
1315	C
1316	D
1317	A
1318	B
1319	C
1320	D
1321	A
1322	B
1323	C
1324	D
1325	A
1326	B
1327	C
1328	D
1329	A
1330	B
1331	C
1332	D
1333	A
1334	B
1335	C
1336	D
1337	A
1338	B
1339	C
1340	D
1341	A
1342	B
1343	C
1344	D
1345	A
1346	B
1347	C
1348	D
1349	A
1350	B
1351	C
1352	D
1353	A
1354	B
1355	C
1356	D
1357	A
1358	B
1359	C
1360	D
1361	A
1362	B
1363	C
1364	D
1365	A
1366	B
1367	C
1368	D
1369	A
1370	B
1371	C
1372	D
1373	A
1374	B
1375	C
1376	D
1377	A
1378	B
1379	C
1380	D
1381	A
1382	B
1383	C
1384	D
1385	A
1386	B
1387	C
1388	D
1389	A
1390	B
1391	C
1392	D
1393	A
1394	B
1395	C
1396	D
1397	A
1398	B
1399	C
1400	D
1401	A
1402	B
1403	C
1404	D
1405	A
1406	B
1407	C
1408	D
1409	A
1410	B
1411	C
1412	D
1413	A
1414	B
1415	C
1416	D
1417	A
1418	B
1419	C
1420	D
1421	A
1422	B
1423	C
1424	D
1425	A
1426	B
1427	C
1428	D
1429	A
1430	B
1431	C
1432	D
1433	A
1434	B
1435	C
1436	D
1437	A
1438	B
1439	C
1440	D
1441	A
1442	B
1443	C
1444	D
1445	A
1446	B
1447	C
1448	D
1449	A
1450	B
1451	C
1452	D
1453	A
1454	B
1455	C
1456	D
1457	A
1458	B
1459	C
1460	D
1461	A
1462	B
1463	C
1464	D
1465	A
1466	B
1467	C
1468	D
1469	A
1470	B
1471	C
1472	D
1473	A
1474	B
1475	C
1476	D
1477	A
1478	B
1479	C
1480	D
1481	A
1482	B
1483	C
1484	D
1485	A
1486	B
1487	C
1488	D
1489	A
1490	B
1491	C
1492	D
1493	A
1494	B
1495	C
1496	D
1497	A
1498	B
1499	C
1500	D
1501	A
1502	B
1503	C
1504	D
1505	A
1506	B
1507	C
1508	D
1509	A
1510	B
1511	C
1512	D
1513	A
1514	B
1515	C
1516	D
1517	A
1518	B
1519	C
1520	D
1521	A
1522	B
1523	C
1524	D
1525	A
1526	B
1527	C
1528	D
1529	A
1530	B
1531	C
1532	D
1533	A
1534	B
1535	C
1536	D
1537	A
1538	B
1539	C
1540	D
1541	A
1542	B
1543	C
1544	D
1545	A
1546	B
1547	C
1548	D
1549	A
1550	B
1551	C
1552	D
1553	A
1554	B
1555	C
1556	D
1557	A
1558	B
1559	C
1560	D
1561	A
1562	B
1563	C
1564	D
1565	A
1566	B
1567	C
1568	D
1569	A
1570	B
1571	C
1572	D
1573	A
1574	B
1575	C
1576	D
1577	A
1578	B
1579	C
1580	D
1581	A
1582	B
1583	C
1584	D
1585	A
1586	B
1587	C
1588	D
1589	A
1590	B
1591	C
1592	D
1593	A
1594	B
1595	C
1596	D
1597	A
1598	B
1599	C
1600	D
1601	A
1602	B
1603	C
1604	D
1605	A
1606	B
1607	C
1608	D
1609	A
1610	B
1611	C
1612	D
1613	A
1614	B
1615	C
1616	D
1617	A
1618	B
1619	C
1620	D
1621	A
1622	B
1623	C
1624	D
1625	A
1626	B
1627	C
1628	D
1629	A
1630	B
1631	C
1632	D
1633	A
1634	B
1635	C
1636	D
1637	A
1638	B
1639	C
1640	D
1641	A
1642	B
1643	C
1644	D
1645	A
1646	B
1647	C
1648	D
1649	A
1650	B
1651	C
1652	D
1653	A
1654	B
1655	C
1656	D
1657	A
1658	B
1659	C
1660	D
1661	A
1662	B
1663	C
1664	D
1665	A
1666	B
1667	C
1668	D
1669	A
1670	B
1671	C
1672	D
1673	A
1674	B
1675	C
1676	D
1677	A
1678	B
1679	C
1680	D
1681	A
1682	B
1683	C
1684	D
1685	A
1686	B
1687	C
1688	D
1689	A
1690	B
1691	C
1692	D
1693	A
1694	B
1695	C
1696	D
1697	A
1698	B
1699	C
1700	D
1701	A
1702	B
1703	C
1704	D
1705	A
1706	B
1707	C
1708	D
1709	A
1710	B
1711	C
1712	D
1713	A
1714	B
1715	C
1716	D
1717	A
1718	B
1719	C
1720	D
1721	A
1722	B
1723	C
1724	D
1725	A
1726	B
1727	C
1728	D
1729	A
1730	B
1731	C
1732	D
1733	A
1734	B
1735	C
1736	D
1737	A
1738	B
1739	C
1740	D
1741	A
1742	B
1743	C
1744	D
1745	A
1746	B
1747	C
1748	D
1749	A
1750	B
1751	C
1752	D
1753	A
1754	B
1755	C
1756	D
1757	A
1758	B
1759	C
1760	D
1761	A
1762	B
1763	C
1764	D
1765	A
1766	B
1767	C
1768	D
1769	A
1770	B
1771	C
1772	D
1773	A
1774	B
1775	C
1776	D
1777	A
1778	B
1779	C
1780	D
1781	A
1782	B
1783	C
1784	D
1785	A
1786	B
1787	C
1788	D
1789	A
1790	B
1791	C
1792	D
1793	A
1794	B
1795	C
1796	D
1797	A
1798	B
1799	C
1800	D
1801	A
1802	B
1803	C
1804	D
1805	A
1806	B
1807	C
1808	D
1809	A
1810	B
1811	C
1812	D
1813	A
1814	B
1815	C
1816	D
1817	A
1818	B
1819	C
1820	D
1821	A
1822	B
1823	C
1824	D
1825	A
1826	B
1827	C
1828	D
1829	A
1830	B
1831	C
1832	D
1833	A
1834	B
1835	C
1836	D
1837	A
1838	B
1839	C
1840	D
1841	A
1842	B
1843	C
1844	D
1845	A
1846	B
1847	C
1848	D
1849	A
1850	B
1851	C
1852	D
1853	A
1854	B
1855	C
1856	D
1857	A
1858	B
1859	C
1860	D
1861	A
1862	B
1863	C
1864	D
1865	A
1866	B
1867	C
1868	D
1869	A
1870	B
1871	C
1872	D
1873	A
1874	B
1875	C
1876	D
1877	A
1878	B
1879	C
1880	D
1881	A
1882	B
1883	C
1884	D
1885	A
1886	B
1887	C
1888	D
1889	A
1890	B
1891	C
1892	D
1893	A
1894	B
1895	C
1896	D
1897	A
1898	B
1899	C
1900	D
1901	A
1902	B
1903	C
1904	D
1905	A
1906	B
1907	C
1908	D
1909	A
1910	B
1911	C
1912	D
1913	A
1914	B
1915	C
1916	D
1917	A
1918	B
1919	C
1920	D
1921	A
1922	B
1923	C
1924	D
1925	A
1926	B
1927	C
1928	D
1929	A
1930	B
1931	C
1932	D
1933	A
1934	B
1935	C
1936	D
1937	A
1938	B
1939	C
1940	D
1941	A
1942	B
1943	C
1944	D
1945	A
1946	B
1947	C
1948	D
1949	A
1950	B
1951	C
1952	D
1953	A
1954	B
1955	C
1956	D
1957	A
1958	B
1959	C
1960	D
1961	A
1962	B
1963	C
1964	D
1965	A
1966	B
1967	C
1968	D
1969	A
1970	B
1971	C
1972	D
1973	A
1974	B
1975	C
1976	D
1977	A
1978	B
1979	C
1980	D
1981	A
1982	B
1983	C
1984	D
1985	A
1986	B
1987	C
1988	D
1989	A
1990	B
1991	C
1992	D
1993	A
1994	B
1995	C
1996	D
1997	A
1998	B
1999	C
2000	D
2001	A
2002	B
2003	C
2004	D
2005	A
2006	B
2007	C
2008	D
2009	A
2010	B
2011	C
2012	D
2013	A
2014	B
2015	C
2016	D
2017	A
2018	B
2019	C
2020	D
2021	A
2022	B
2023	C
2024	D
2025	A
2026	B
2027	C
2028	D
2029	A
2030	B
2031	C
2032	D
2033	A
2034	B
2035	C
2036	D
2037	A
2038	B
2039	C
2040	D
2041	A
2042	B
2043	C
2044	D
2045	A
2046	B
2047	C
2048	D
2049	A
2050	B
2051	C
2052	D
2053	A
2054	B
2055	C
2056	D
2057	A
2058	B
2059	C
2060	D
2061	A
2062	B
2063	C
2064	D
2065	A
2066	B
2067	C
2068	D
2069	A
2070	B
2071	C
2072	D
2073	A
2074	B
2075	C
2076	D
2077	A
2078	B
2079	C
2080	D
2081	A
2082	B
2083	C
2084	D
2085	A
2086	B
2087	C
2088	D
2089	A
2090	B
2091	C
2092	D
2093	A
2094	B
2095	C
2096	D
2097	A
2098	B
2099	C
2100	D
2101	A
2102	B
2103	C
2104	D
2105	A
2106	B
2107	C
2108	D
2109	A
2110	B
2111	C
2112	D
2113	A
2114	B
2115	C
2116	D
2117	A
2118	B
2119	C
2120	D
2121	A
2122	B
2123	C
2124	D
2125	A
2126	B
2127	C
2128	D
2129	A
2130	B
2131	C
2132	D
2133	A
2134	B
2135	C
2136	D
2137	A
2138	B
2139	C
2140	D
2141	A
2142	B
2143	C
2144	D
2145	A
2146	B
2147	C
2148	D
2149	A
2150	B
2151	C
2152	D
2153	A
2154	B
2155	C
2156	D
2157	A
2158	B
2159	C
2160	D
2161	A
2162	B
2163	C
2164	D
2165	A
2166	B
2167	C
2168	D
2169	A
2170	B
2171	C
2172	D
2173	A
2174	B
2175	C
2176	D
2177	A
2178	B
2179	C
2180	D
2181	A
2182	B
2183	C
2184	D
2185	A
2186	B
2187	C
2188	D
2189	A
2190	B
2191	C
2192	D
2193	A
2194	B
2195	C
2196	D
2197	A
2198	B
2199	C
2200	D
2201	A
2202	B
2203	C
2204	D
2205	A
2206	B
2207	C
2208	D
2209	A
2210	B
2211	C
2212	D
2213	A
2214	B
2215	C
2216	D
2217	A
2218	B
2219	C
2220	D
2221	A
2222	B
2223	C
2224	D
2225	A
2226	B
2227	C
2228	D
2229	A
2230	B
2231	C
2232	D
2233	A
2234	B
2235	C
2236	D
2237	A
2238	B
2239	C
2240	D
2241	A
2242	B
2243	C
2244	D
2245	A
2246	B
2247	C
2248	D
2249	A
2250	B
2251	C
2252	D
2253	A
2254	B
2255	C
2256	D
2257	A
2258	B
2259	C
2260	D
2261	A
2262	B
2263	C
2264	D
2265	A
2266	B
2267	C
2268	D
2269	A
2270	B
2271	C
2272	D
2273	A
2274	B
2275	C
2276	D
2277	A
2278	B
2279	C
2280	D
2281	A
2282	B
2283	C
2284	D
2285	A
2286	B
2287	C
2288	D
2289	A
2290	B
2291	C
2292	D
2293	A
2294	B
2295	C
2296	D
2297	A
2298	B
2299	C
2300	D
2301	A
2302	B
2303	C
2304	D
2305	A
2306	B
2307	C
2308	D
2309	A
2310	B
2311	C
2312	D
2313	A
2314	B
2315	C
2316	D
2317	A
2318	B
2319	C
2320	D
2321	A
2322	B
2323	C
2324	D
2325	A
2326	B
2327	C
2328	D
2329	A
2330	B
2331	C
2332	D
2333	A
2334	B
2335	C
2336	D
2337	A
2338	B
2339	C
2340	D
2341	A
2342	B
2343	C
2344	D
2345	A
2346	B
2347	C
2348	D
2349	A
2350	B
2351	C
2352	D
2353	A
2354	B
2355	C
2356	D
2357	A
2358	B
2359	C
2360	D
2361	A
2362	B
2363	C
2364	D
2365	A
2366	B
2367	C
2368	D
2369	A
2370	B
2371	C
2372	D
2373	A
2374	B
2375	C
2376	D
2377	A
2378	B
2379	C
2380	D
2381	A
2382	B
2383	C
2384	D
2385	A
2386	B
2387	C
2388	D
2389	A
2390	B
2391	C
2392	D
2393	A
2394	B
2395	C
2396	D
2397	A
2398	B
2399	C
2400	D
2401	A
2402	B
2403	C
2404	D
2405	A
2406	B
2407	C
2408	D
2409	A
2410	B
2411	C
2412	D
2413	A
2414	B
2415	C
2416	D
2417	A
2418	B
2419	C
2420	D
2421	A
2422	B
2423	C
2424	D
2425	A
2426	B
2427	C
2428	D
2429	A
2430	B
2431	C
2432	D
2433	A
2434	B
2435	C
2436	D
2437	A
2438	B
2439	C
2440	D
2441	A
2442	B
2443	C
2444	D
2445	A
2446	B
2447	C
2448	D
2449	A
2450	B
2451	C
2452	D
2453	A
2454	B
2455	C
2456	D
2457	A
2458	B
2459	C
2460	D
2461	A
2462	B
2463	C
2464	D
2465	A
2466	B
2467	C
2468	D
2469	A
2470	B
2471	C
2472	D
2473	A
2474	B
2475	C
2476	D
2477	A
2478	B
2479	C
2480	D
2481	A
2482	B
2483	C
2484	D
2485	A
2486	B
2487	C
2488	D
2489	A
2490	B
2491	C
2492	D
2493	A
2494	B
2495	C
2496	D
2497	A
2498	B
2499	C
2500	D
2501	A
2502	B
2503	C
2504	D
2505	A
2506	B
2507	C
2508	D
2509	A
2510	B
2511	C
2512	D
2513	A
2514	B
2515	C
2516	D
2517	A
2518	B
2519	C
2520	D
2521	A
2522	B
2523	C
2524	D
2525	A
2526	B
2527	C
2528	D
2529	A
2530	B
2531	C
2532	D
2533	A
2534	B
2535	C
2536	D
2537	A
2538	B
2539	C
2540	D
2541	A
2542	B
2543	C
2544	D
2545	A
2546	B
2547	C
2548	D
2549	A
2550	B
2551	C
2552	D
2553	A
2554	B
2555	C
2556	D
2557	A
2558	B
2559	C
2560	D
2561	A
2562	B
2563	C
2564	D
2565	A
2566	B
2567	C
2568	D
2569	A
2570	B
2571	C
2572	D
2573	A
2574	B
2575	C
2576	D
2577	A
2578	B
2579	C
2580	D
2581	A
2582	B
2583	C
2584	D
2585	A
2586	B
2587	C
2588	D
2589	A
2590	B
2591	C
2592	D
2593	A
2594	B
2595	C
2596	D
2597	A
2598	B
2599	C
2600	D
2601	A
2602	B
2603	C
2604	D
2605	A
2606	B
2607	C
2608	D
2609	A
2610	B
2611	C
2612	D
2613	A
2614	B
2615	C
2616	D
2617	A
2618	B
2619	C
2620	D
2621	A
2622	B
2623	C
2624	D
2625	A
2626	B
2627	C
2628	D
2629	A
2630	B
2631	C
2632	D
2633	A
2634	B
2635	C
2636	D
2637	A
2638	B
2639	C
2640	D
2641	A
2642	B
2643	C
2644	D
2645	A
2646	B
2647	C
2648	D
2649	A
2650	B
2651	C
2652	D
2653	A
2654	B
2655	C
2656	D
2657	A
2658	B
2659	C
2660	D
2661	A
2662	B
2663	C
2664	D
2665	A
2666	B
2667	C
2668	D
2669	A
2670	B
2671	C
2672	D
2673	A
2674	B
2675	C
2676	D
2677	A
2678	B
2679	C
2680	D
2681	A
2682	B
2683	C
2684	D
2685	A
2686	B
2687	C
2688	D
2689	A
2690	B
2691	C
2692	D
2693	A
2694	B
2695	C
2696	D
2697	A
2698	B
2699	C
2700	D
2701	A
2702	B
2703	C
2704	D
2705	A
2706	B
2707	C
2708	D
2709	A
2710	B
2711	C
2712	D
2713	A
2714	B
2715	C
2716	D
2717	A
2718	B
2719	C
2720	D
2721	A
2722	B
2723	C
2724	D
2725	A
2726	B
2727	C
2728	D
2729	A
2730	B
2731	C
2732	D
2733	A
2734	B
2735	C
2736	D
2737	A
2738	B
2739	C
2740	D
2741	A
2742	B
2743	C
2744	D
2745	A
2746	B
2747	C
2748	D
2749	A
2750	B
2751	C
2752	D
2753	A
2754	B
2755	C
2756	D
2757	A
2758	B
2759	C
2760	D
2761	A
2762	B
2763	C
2764	D
2765	A
2766	B
2767	C
2768	D
2769	A
2770	B
2771	C
2772	D
2773	A
2774	B
2775	C
2776	D
2777	A
2778	B
2779	C
2780	D
2781	A
2782	B
2783	C
2784	D
2785	A
2786	B
2787	C
2788	D
2789	A
2790	B
2791	C
2792	D
2793	A
2794	B
2795	C
2796	D
2797	A
2798	B
2799	C
2800	D
2801	A
2802	B
2803	C
2804	D
2805	A
2806	B
2807	C
2808	D
2809	A
2810	B
2811	C
2812	D
2813	A
2814	B
2815	C
2816	D
2817	A
2818	B
2819	C
2820	D
2821	A
2822	B
2823	C
2824	D
2825	A
2826	B
2827	C
2828	D
2829	A
2830	B
2831	C
2832	D
2833	A
2834	B
2835	C
2836	D
2837	A
2838	B
2839	C
2840	D
2841	A
2842	B
2843	C
2844	D
2845	A
2846	B
2847	C
2848	D
2849	A
2850	B
2851	C
2852	D
2853	A
2854	B
2855	C
2856	D
2857	A
2858	B
2859	C
2860	D
2861	A
2862	B
2863	C
2864	D
2865	A
2866	B
2867	C
2868	D
2869	A
2870	B
2871	C
2872	D
2873	A
2874	B
2875	C
2876	D
2877	A
2878	B
2879	C
2880	D
2881	A
2882	B
2883	C
2884	D
2885	A
2886	B
2887	C
2888	D
2889	A
2890	B
2891	C
2892	D
2893	A
2894	B
2895	C
2896	D
2897	A
2898	B
2899	C
2900	D
2901	A
2902	B
2903	C
2904	D
2905	A
2906	B
2907	C
2908	D
2909	A
2910	B
2911	C
2912	D
2913	A
2914	B
2915	C
2916	D
2917	A
2918	B
2919	C
2920	D
2921	A
2922	B
2923	C
2924	D
2925	A
2926	B
2927	C
2928	D
2929	A
2930	B
2931	C
2932	D
2933	A
2934	B
2935	C
2936	D
2937	A
2938	B
2939	C
2940	D
2941	A
2942	B
2943	C
2944	D
2945	A
2946	B
2947	C
2948	D
2949	A
2950	B
2951	C
2952	D
2953	A
2954	B
2955	C
2956	D
2957	A
2958	B
2959	C
2960	D
2961	A
2962	B
2963	C
2964	D
2965	A
2966	B
2967	C
2968	D
2969	A
2970	B
2971	C
2972	D
2973	A
2974	B
2975	C
2976	D
2977	A
2978	B
2979	C
2980	D
2981	A
2982	B
2983	C
2984	D
2985	A
2986	B
2987	C
2988	D
2989	A
2990	B
2991	C
2992	D
2993	A
2994	B
2995	C
2996	D
2997	A
2998	B
2999	C
3000	D
3001	A
3002	B
3003	C
3004	D
3005	A
3006	B
3007	C
3008	D
3009	A
3010	B
3011	C
3012	D
3013	A
3014	B
3015	C
3016	D
3017	A
3018	B
3019	C
3020	D
3021	A
3022	B
3023	C
3024	D
3025	A
3026	B
3027	C
3028	D
3029	A
3030	B
3031	C
3032	D
3033	A
3034	B
3035	C
3036	D
3037	A
3038	B
3039	C
3040	D
3041	A
3042	B
3043	C
3044	D
3045	A
3046	B
3047	C
3048	D
3049	A
3050	B
3051	C
3052	D
3053	A
3054	B
3055	C
3056	D
3057	A
3058	B
3059	C
3060	D
3061	A
3062	B
3063	C
3064	D
3065	A
3066	B
3067	C
3068	D
3069	A
3070	B
3071	C
3072	D
3073	A
3074	B
3075	C
3076	D
3077	A
3078	B
3079	C
3080	D
3081	A
3082	B
3083	C
3084	D
3085	A
3086	B
3087	C
3088	D
3089	A
3090	B
3091	C
3092	D
3093	A
3094	B
3095	C
3096	D
3097	A
3098	B
3099	C
3100	D
3101	A
3102	B
3103	C
3104	D
3105	A
3106	B
3107	C
3108	D
3109	A
3110	B
3111	C
3112	D
3113	A
3114	B
3115	C
3116	D
3117	A
3118	B
3119	C
3120	D
3121	A
3122	B
3123	C
3124	D
3125	A
3126	B
3127	C
3128	D
3129	A
3130	B
3131	C
3132	D
3133	A
3134	B
3135	C
3136	D
3137	A
3138	B
3139	C
3140	D
3141	A
3142	B
3143	C
3144	D
3145	A
3146	B
3147	C
3148	D
3149	A
3150	B
3151	C
3152	D
3153	A
3154	B
3155	C
3156	D
3157	A
3158	B
3159	C
3160	D
3161	A
3162	B
3163	C
3164	D
3165	A
3166	B
3167	C
3168	D
3169	A
3170	B
3171	C
3172	D
3173	A
3174	B
3175	C
3176	D
3177	A
3178	B
3179	C
3180	D
3181	A
3182	B
3183	C
3184	D
3185	A
3186	B
3187	C
3188	D
3189	A
3190	B
3191	C
3192	D
3193	A
3194	B
3195	C
3196	D
3197	A
3198	B
3199	C
3200	D
3201	A
3202	B
3203	C
3204	D
3205	A
3206	B
3207	C
3208	D
3209	A
3210	B
3211	C
3212	D
3213	A
3214	B
3215	C
3216	D
3217	A
3218	B
3219	C
3220	D
3221	A
3222	B
3223	C
3224	D
3225	A
3226	B
3227	C
3228	D
3229	A
3230	B
3231	C
3232	D
3233	A
3234	B
3235	C
3236	D
3237	A
3238	B
3239	C
3240	D
3241	A
3242	B
3243	C
3244	D
3245	A
3246	B
3247	C
3248	D
3249	A
3250	B
3251	C
3252	D
3253	A
3254	B
3255	C
3256	D
3257	A
3258	B
3259	C
3260	D
3261	A
3262	B
3263	C
3264	D
3265	A
3266	B
3267	C
3268	D
3269	A
3270	B
3271	C
3272	D
3273	A
3274	B
3275	C
3276	D
3277	A
3278	B
3279	C
3280	D
3281	A
3282	B
3283	C
3284	D
3285	A
3286	B
3287	C
3288	D
3289	A
3290	B
3291	C
3292	D
3293	A
3294	B
3295	C
3296	D
3297	A
3298	B
3299	C
3300	D
3301	A
3302	B
3303	C
3304	D
3305	A
3306	B
3307	C
3308	D
3309	A
3310	B
3311	C
3312	D
3313	A
3314	B
3315	C
3316	D
3317	A
3318	B
3319	C
3320	D
3321	A
3322	B
3323	C
3324	D
3325	A
3326	B
3327	C
3328	D
3329	A
3330	B
3331	C
3332	D
3333	A
3334	B
3335	C
3336	D
3337	A
3338	B
3339	C
3340	D
3341	A
3342	B
3343	C
3344	D
3345	A
3346	B
3347	C
3348	D
3349	A
3350	B
3351	C
3352	D
3353	A
3354	B
3355	C
3356	D
3357	A
3358	B
3359	C
3360	D
3361	A
3362	B
3363	C
3364	D
3365	A
3366	B
3367	C
3368	D
3369	A
3370	B
3371	C
3372	D
3373	A
3374	B
3375	C
3376	D
3377	A
3378	B
3379	C
3380	D
3381	A
3382	B
3383	C
3384	D
3385	A
3386	B
3387	C
3388	D
3389	A
3390	B
3391	C
3392	D
3393	A
3394	B
3395	C
3396	D
3397	A
3398	B
3399	C
3400	D
3401	A
3402	B
3403	C
3404	D
3405	A
3406	B
3407	C
3408	D
3409	A
3410	B
3411	C
3412	D
3413	A
3414	B
3415	C
3416	D
3417	A
3418	B
3419	C
3420	D
3421	A
3422	B
3423	C
3424	D
3425	A
3426	B
3427	C
3428	D
3429	A
3430	B
3431	C
3432	D
3433	A
3434	B
3435	C
3436	D
3437	A
3438	B
3439	C
3440	D
3441	A
3442	B
3443	C
3444	D
3445	A
3446	B
3447	C
3448	D
3449	A
3450	B
3451	C
3452	D
3453	A
3454	B
3455	C
3456	D
3457	A
3458	B
3459	C
3460	D
3461	A
3462	B
3463	C
3464	D
3465	A
3466	B
3467	C
3468	D
3469	A
3470	B
3471	C
3472	D
3473	A
3474	B
3475	C
3476	D
3477	A
3478	B
3479	C
3480	D
3481	A
3482	B
3483	C
3484	D
3485	A
3486	B
3487	C
3488	D
3489	A
3490	B
3491	C
3492	D
3493	A
3494	B
3495	C
3496	D
3497	A
3498	B
3499	C
3500	D
3501	A
3502	B
3503	C
3504	D
3505	A
3506	B
3507	C
3508	D
3509	A
3510	B
3511	C
3512	D
3513	A
3514	B
3515	C
3516	D
3517	A
3518	B
3519	C
3520	D
3521	A
3522	B
3523	C
3524	D
3525	A
3526	B
3527	C
3528	D
3529	A
3530	B
3531	C
3532	D
3533	A
3534	B
3535	C
3536	D
3537	A
3538	B
3539	C
3540	D
3541	A
3542	B
3543	C
3544	D
3545	A
3546	B
3547	C
3548	D
3549	A
3550	B
3551	C
3552	D
3553	A
3554	B
3555	C
3556	D
3557	A
3558	B
3559	C
3560	D
3561	A
3562	B
3563	C
3564	D
3565	A
3566	B
3567	C
3568	D
3569	A
3570	B
3571	C
3572	D
3573	A
3574	B
3575	C
3576	D
3577	A
3578	B
3579	C
3580	D
3581	A
3582	B
3583	C
3584	D
3585	A
3586	B
3587	C
3588	D
3589	A
3590	B
3591	C
3592	D
3593	A
3594	B
3595	C
3596	D
3597	A
3598	B
3599	C
3600	D
3601	A
3602	B
3603	C
3604	D
3605	A
3606	B
3607	C
3608	D
3609	A
3610	B
3611	C
3612	D
3613	A
3614	B
3615	C
3616	D
3617	A
3618	B
3619	C
3620	D
3621	A
3622	B
3623	C
3624	D
3625	A
3626	B
3627	C
3628	D
3629	A
3630	B
3631	C
3632	D
3633	A
3634	B
3635	C
3636	D
3637	A
3638	B
3639	C
3640	D
3641	A
3642	B
3643	C
3644	D
3645	A
3646	B
3647	C
3648	D
3649	A
3650	B
3651	C
3652	D
3653	A
3654	B
3655	C
3656	D
3657	A
3658	B
3659	C
3660	D
3661	A
3662	B
3663	C
3664	D
3665	A
3666	B
3667	C
3668	D
3669	A
3670	B
3671	C
3672	D
3673	A
3674	B
3675	C
3676	D
3677	A
3678	B
3679	C
3680	D
3681	A
3682	B
3683	C
3684	D
3685	A
3686	B
3687	C
3688	D
3689	A
3690	B
3691	C
3692	D
3693	A
3694	B
3695	C
3696	D
3697	A
3698	B
3699	C
3700	D
3701	A
3702	B
3703	C
3704	D
3705	A
3706	B
3707	C
3708	D
3709	A
3710	B
3711	C
3712	D
3713	A
3714	B
3715	C
3716	D
3717	A
3718	B
3719	C
3720	D
3721	A
3722	B
3723	C
3724	D
3725	A
3726	B
3727	C
3728	D
3729	A
3730	B
3731	C
3732	D
3733	A
3734	B
3735	C
3736	D
3737	A
3738	B
3739	C
3740	D
3741	A
3742	B
3743	C
3744	D
3745	A
3746	B
3747	C
3748	D
3749	A
3750	B
3751	C
3752	D
3753	A
3754	B
3755	C
3756	D
3757	A
3758	B
3759	C
3760	D
3761	A
3762	B
3763	C
3764	D
3765	A
3766	B
3767	C
3768	D
3769	A
3770	B
3771	C
3772	D
3773	A
3774	B
3775	C
3776	D
3777	A
3778	B
3779	C
3780	D
3781	A
3782	B
3783	C
3784	D
3785	A
3786	B
3787	C
3788	D
3789	A
3790	B
3791	C
3792	D
3793	A
3794	B
3795	C
3796	D
3797	A
3798	B
3799	C
3800	D
3801	A
3802	B
3803	C
3804	D
3805	A
3806	B
3807	C
3808	D
3809	A
3810	B
3811	C
3812	D
3813	A
3814	B
3815	C
3816	D
3817	A
3818	B
3819	C
3820	D
3821	A
3822	B
3823	C
3824	D
3825	A
3826	B
3827	C
3828	D
3829	A
3830	B
3831	C
3832	D
3833	A
3834	B
3835	C
3836	D
3837	A
3838	B
3839	C
3840	D
3841	A
3842	B
3843	C
3844	D
3845	A
3846	B
3847	C
3848	D
3849	A
3850	B
3851	C
3852	D
3853	A
3854	B
3855	C
3856	D
3857	A
3858	B
3859	C
3860	D
3861	A
3862	B
3863	C
3864	D
3865	A
3866	B
3867	C
3868	D
3869	A
3870	B
3871	C
3872	D
3873	A
3874	B
3875	C
3876	D
3877	A
3878	B
3879	C
3880	D
3881	A
3882	B
3883	C
3884	D
3885	A
3886	B
3887	C
3888	D
3889	A
3890	B
3891	C
3892	D
3893	A
3894	B
3895	C
3896	D
3897	A
3898	B
3899	C
3900	D
3901	A
3902	B
3903	C
3904	D
3905	A
3906	B
3907	C
3908	D
3909	A
3910	B
3911	C
3912	D
3913	A
3914	B
3915	C
3916	D
3917	A
3918	B
3919	C
3920	D
3921	A
3922	B
3923	C
3924	D
3925	A
3926	B
3927	C
3928	D
3929	A
3930	B
3931	C
3932	D
3933	A
3934	B
3935	C
3936	D
3937	A
3938	B
3939	C
3940	D
3941	A
3942	B
3943	C
3944	D
3945	A
3946	B
3947	C
3948	D
3949	A
3950	B
3951	C
3952	D
3953	A
3954	B
3955	C
3956	D
3957	A
3958	B
3959	C
3960	D
3961	A
3962	B
3963	C
3964	D
3965	A
3966	B
3967	C
3968	D
3969	A
3970	B
3971	C
3972	D
3973	A
3974	B
3975	C
3976	D
3977	A
3978	B
3979	C
3980	D
3981	A
3982	B
3983	C
3984	D
3985	A
3986	B
3987	C
3988	D
3989	A
3990	B
3991	C
3992	D
3993	A
3994	B
3995	C
3996	D
3997	A
3998	B
3999	C
4000	D

[novinosrin]

Ok , i didn't notice your latest edit which was about few mins ago. Nice work:)

[novinosrin]

data have;
 input word $;
 datalines;
 A
 B
 C
 D
;
data _null_;
if _n_=1 then do;
dcl hash H (ordered: "A",multidata:'y') ;
   h.definekey  ("_n_") ;
   h.definedata ("word") ;
   h.definedone () ;
end;
set have end=l;
do _n_=1 to 1000;
rc=h.add();
end;
if l then h.output(dataset:'want');
run;