Assistance- Juan Albertorio NCHS, CDC

[Albertorio, Juan (NIH/NICHD) [V]]

Greetings! I need assistance with the following problem- read below. Any help is deeply appreciated.

 

Regards SPSS folks!

 

Juan :-)

 

_______________________________________

 

Juan R. Albertorio-Díaz

Statistician

_______________________________________

 

National Institute of Child and Human Development

[hidden email]

301.435-6984

[hidden email]

_______________________________________

NCHS

Office of Global Statistics, Office of Center Director

3311 Toledo Rd. Suite 2427

Hyattsville, MD, 20782

301.458.4634

[hidden email]

 

 

Hello!

At the Long-term Care Statistics Branch, they are testing an input statement for data users to create the medication public use file. The input statement successfully created the data file, but it also stripped the leading zeroes from the many codes in our data file. Is there a certain command or code we can insert into our input statement below to avoid the deletion of the leading zeroes?

Thanks in advance :-)

 

Juan

* 2004 NATIONAL NURSING HOME SURVEY
*PRESCRIBED MEDICATIONS PUBLIC USE DATA FILE
*SPSS INPUT STATEMENTS

FILE HANDLE DATA /NAME='K:\LTCSB2\PM\PUBLIC USE\MEDS_110906.TXT'  LRECL=2031.
DATA LIST FILE=DATA/
   FACNUM               1 - 4
   RESNUM               5 - 10
   PMCODE01     11 - 15
   PMCODE02     16 - 20
   PMCODE03     21 - 25
   PMCODE04     26 - 30
   PMCODE05     31 - 35
   PMCODE06     36 - 40
   PMCODE07     41 - 45
   PMCODE08     46 - 50
   PMCODE09     51 - 55
   PMCODE10     56 - 60
   PMCODE11     61 - 65
   PMCODE12     66 - 70
   PMCODE13     71 - 75
   PMCODE14     76 - 80
   PMCODE15     81 - 85
   PMCODE16     86 - 90
   PMCODE17     91 - 95
   PMCODE18     96 - 100
   PMCODE19     101 - 105
   PMCODE20     106 - 110
   PMCODE21     111 - 115
   PMCODE22     116 - 120
   PMCODE23     121 - 125
   PMCODE24     126 - 130
   PMCODE25     131 - 135
   OTHRPMED             136
   OTHPMC01     137 - 141
   OTHPMC02     142 - 146
   OTHPMC03     147 - 151
   OTHPMC04     152 - 156
   OTHPMC05     157 - 161
   OTHPMC06     162 - 166
   OTHPMC07     167 - 171
   OTHPMC08     172 - 176
   OTHPMC09     177 - 181
   OTHPMC10     182 - 186
   OTHPMC11     187 - 191
   OTHPMC12     192 - 196
   OTHPMC13     197 - 201
   OTHPMC14     202 - 206
   OTHPMC15     207 - 211
   ANYMEDS              212
   RXMED                213 - 214
   RXOTH                215 - 216
   RXTOT                217 - 218
   GEN01        219 - 223
   GEN02        224 - 228
   GEN03        229 - 233
   GEN04        234 - 238
   GEN05        239 - 243
   GEN06        244 - 248
   GEN07        249 - 253
   GEN08        254 - 258
   GEN09        259 - 263
   GEN10        264 - 268
   GEN11        269 - 273
   GEN12        274 - 278
   GEN13        279 - 283
   GEN14        284 - 288
   GEN15        289 - 293
   GEN16        294 - 298
   GEN17        299 - 303
   GEN18        304 - 308
   GEN19        309 - 313
   GEN20        314 - 318
   GEN21        319 - 323
   GEN22        324 - 328
   GEN23        329 - 333
   GEN24        334 - 338
   GEN25        339 - 343
   OGEN01       344 - 348
   OGEN02       349 - 353
   OGEN03       354 - 358
   OGEN04       359 - 363
   OGEN05       364 - 368
   OGEN06       369 - 373
   OGEN07       374 - 378
   OGEN08       379 - 383
   OGEN09       384 - 388
   OGEN10       389 - 393
   OGEN11       394 - 398
   OGEN12       399 - 403
   OGEN13       404 - 408
   OGEN14       409 - 413
   OGEN15       414 - 418
   COMST01      419
   COMST02      420
   COMST03      421
   COMST04      422
   COMST05      423
   COMST06      424
   COMST07      425
   COMST08      426
   COMST09      427
   COMST10      428
   COMST11      429
   COMST12      430
   COMST13      431
   COMST14      432
   COMST15      433
   COMST16      434
   COMST17      435
   COMST18      436
   COMST19      437
   COMST20      438
   COMST21      439
   COMST22      440
   COMST23      441
   COMST24      442
   COMST25      443
   OCOMST01     444
   OCOMST02     445
   OCOMST03     446
   OCOMST04     447
   OCOMST05     448
   OCOMST06     449
   OCOMST07     450
   OCOMST08     451
   OCOMST09     452
   OCOMST10     453
   OCOMST11     454
   OCOMST12     455
   OCOMST13     456
   OCOMST14     457
   OCOMST15     458
   RXST01       459
   RXST02       460
   RXST03       461
   RXST04       462
   RXST05       463
   RXST06       464
   RXST07       465
   RXST08       466
   RXST09       467
   RXST10       468
   RXST11       469
   RXST12       470
   RXST13       471
   RXST14       472
   RXST15       473
   RXST16       474
   RXST17       475
   RXST18       476
   RXST19       477
   RXST20       478
   RXST21       479
   RXST22       480
   RXST23       481
   RXST24       482
   RXST25       483
   ORXST01      484
   ORXST02      485
   ORXST03      486
   ORXST04      487
   ORXST05      488
   ORXST06      489
   ORXST07      490
   ORXST08      491
   ORXST09      492
   ORXST10      493
   ORXST11      494
   ORXST12      495
   ORXST13      496
   ORXST14      497
   ORXST15      498
   CONTR01      499
   CONTR02      500
   CONTR03      501
   CONTR04      502
   CONTR05      503
   CONTR06      504
   CONTR07      505
   CONTR08      506
   CONTR09      507
   CONTR10      508
   CONTR11      509
   CONTR12      510
   CONTR13      511
   CONTR14      512
   CONTR15      513
   CONTR16      514
   CONTR17      515
   CONTR18      516
   CONTR19      517
   CONTR20      518
   CONTR21      519
   CONTR22      520
   CONTR23      521
   CONTR24      522
   CONTR25      523
   OCONTR01     524
   OCONTR02     525
   OCONTR03     526
   OCONTR04     527
   OCONTR05     528
   OCONTR06     529
   OCONTR07     530
   OCONTR08     531
   OCONTR09     532
   OCONTR10     533
   OCONTR11     534
   OCONTR12     535
   OCONTR13     536
   OCONTR14     537
   OCONTR15     538
   RX1ING1      539 - 543
   RX2ING1      544 - 548
   RX3ING1      549 - 553
   RX4ING1      554 - 558
   RX5ING1      559 - 563
   RX6ING1      564 - 568
   RX7ING1      569 - 573
   RX8ING1      574 - 578
   RX9ING1      579 - 583
   RX10ING1     584 - 588
   RX11ING1     589 - 593
   RX12ING1     594 - 598
   RX13ING1     599 - 603
   RX14ING1     604 - 608
   RX15ING1     609 - 613
   RX16ING1     614 - 618
   RX17ING1     619 - 623
   RX18ING1     624 - 628
   RX19ING1     629 - 633
   RX20ING1     634 - 638
   RX21ING1     639 - 643
   RX22ING1     644 - 648
   RX23ING1     649 - 653
   RX24ING1     654 - 658
   RX25ING1     659 - 663
   RX1ING2      664 - 668
   RX2ING2      669 - 673
   RX3ING2      674 - 678
   RX4ING2      679 - 683
   RX5ING2      684 - 688
   RX6ING2      689 - 693
   RX7ING2      694 - 698
   RX8ING2      699 - 703
   RX9ING2      704 - 708
   RX10ING2     709 - 713
   RX11ING2     714 - 718
   RX12ING2     719 - 723
   RX13ING2     724 - 728
   RX14ING2     729 - 733
   RX15ING2     734 - 738
   RX16ING2     739 - 743
   RX17ING2     744 - 748
   RX18ING2     749 - 753
   RX19ING2     754 - 758
   RX20ING2     759 - 763
   RX21ING2     764 - 768
   RX22ING2     769 - 773
   RX23ING2     774 - 778
   RX24ING2     779 - 783
   RX25ING2     784 - 788
   RX1ING3      789 - 793
   RX2ING3      794 - 798
   RX3ING3      799 - 803
   RX4ING3      804 - 808
   RX5ING3      809 - 813
   RX6ING3      814 - 818
   RX7ING3      819 - 823
   RX8ING3      824 - 828
   RX9ING3      829 - 833
   RX10ING3     834 - 838
   RX11ING3     839 - 843
   RX12ING3     844 - 848
   RX13ING3     849 - 853
   RX14ING3     854 - 858
   RX15ING3     859 - 863
   RX16ING3     864 - 868
   RX17ING3     869 - 873
   RX18ING3     874 - 878
   RX19ING3     879 - 883
   RX20ING3     884 - 888
   RX21ING3     889 - 893
   RX22ING3     894 - 898
   RX23ING3     899 - 903
   RX24ING3     904 - 908
   RX25ING3     909 - 913
   RX1ING4      914 - 918
   RX2ING4      919 - 923
   RX3ING4      924 - 928
   RX4ING4      929 - 933
   RX5ING4      934 - 938
   RX6ING4      939 - 943
   RX7ING4      944 - 948
   RX8ING4      949 - 953
   RX9ING4      954 - 958
   RX10ING4     959 - 963
   RX11ING4     964 - 968
   RX12ING4     969 - 973
   RX13ING4     974 - 978
   RX14ING4     979 - 983
   RX15ING4     984 - 988
   RX16ING4     989 - 993
   RX17ING4     994 - 998
   RX18ING4     999 - 1003
   RX19ING4     1004 - 1008
   RX20ING4     1009 - 1013
   RX21ING4     1014 - 1018
   RX22ING4     1019 - 1023
   RX23ING4     1024 - 1028
   RX24ING4     1029 - 1033
   RX25ING4     1034 - 1038
   RX1ING5      1039 - 1043
   RX2ING5      1044 - 1048
   RX3ING5      1049 - 1053
   RX4ING5      1054 - 1058
   RX5ING5      1059 - 1063
   RX6ING5      1064 - 1068
   RX7ING5      1069 - 1073
   RX8ING5      1074 - 1078
   RX9ING5      1079 - 1083
   RX10ING5     1084 - 1088
   RX11ING5     1089 - 1093
   RX12ING5     1094 - 1098
   RX13ING5     1099 - 1103
   RX14ING5     1104 - 1108
   RX15ING5     1109 - 1113
   RX16ING5     1114 - 1118
   RX17ING5     1119 - 1123
   RX18ING5     1124 - 1128
   RX19ING5     1129 - 1133
   RX20ING5     1134 - 1138
   RX21ING5     1139 - 1143
   RX22ING5     1144 - 1148
   RX23ING5     1149 - 1153
   RX24ING5     1154 - 1158
   RX25ING5     1159 - 1163
   OX1ING1      1164 - 1168
   OX2ING1      1169 - 1173
   OX3ING1      1174 - 1178
   OX4ING1      1179 - 1183
   OX5ING1      1184 - 1188
   OX6ING1      1189 - 1193
   OX7ING1      1194 - 1198
   OX8ING1      1199 - 1203
   OX9ING1      1204 - 1208
   OX10ING1     1209 - 1213
   OX11ING1     1214 - 1218
   OX12ING1     1219 - 1223
   OX13ING1     1224 - 1228
   OX14ING1     1229 - 1233
   OX15ING1     1234 - 1238
   OX1ING2      1239 - 1243
   OX2ING2      1244 - 1248
   OX3ING2      1249 - 1253
   OX4ING2      1254 - 1258
   OX5ING2      1259 - 1263
   OX6ING2      1264 - 1268
   OX7ING2      1269 - 1273
   OX8ING2      1274 - 1278
   OX9ING2      1279 - 1283
   OX10ING2     1284 - 1288
   OX11ING2     1289 - 1293
   OX12ING2     1294 - 1298
   OX13ING2     1299 - 1303
   OX14ING2     1304 - 1308
   OX15ING2     1309 - 1313
   OX1ING3      1314 - 1318
   OX2ING3      1319 - 1323
   OX3ING3      1324 - 1328
   OX4ING3      1329 - 1333
   OX5ING3      1334 - 1338
   OX6ING3      1339 - 1343
   OX7ING3      1344 - 1348
   OX8ING3      1349 - 1353
   OX9ING3      1354 - 1358
   OX10ING3     1359 - 1363
   OX11ING3     1364 - 1368
   OX12ING3     1369 - 1373
   OX13ING3     1374 - 1378
   OX14ING3     1379 - 1383
   OX15ING3     1384 - 1388
   OX1ING4      1389 - 1393
   OX2ING4      1394 - 1398
   OX3ING4      1399 - 1403
   OX4ING4      1404 - 1408
   OX5ING4      1409 - 1413
   OX6ING4      1414 - 1418
   OX7ING4      1419 - 1423
   OX8ING4      1424 - 1428
   OX9ING4      1429 - 1433
   OX10ING4     1434 - 1438
   OX11ING4     1439 - 1443
   OX12ING4     1444 - 1448
   OX13ING4     1449 - 1453
   OX14ING4     1454 - 1458
   OX15ING4     1459 - 1463
   OX1ING5      1464 - 1468
   OX2ING5      1469 - 1473
   OX3ING5      1474 - 1478
   OX4ING5      1479 - 1483
   OX5ING5      1484 - 1488
   OX6ING5      1489 - 1493
   OX7ING5      1494 - 1498
   OX8ING5      1499 - 1503
   OX9ING5      1504 - 1508
   OX10ING5     1509 - 1513
   OX11ING5     1514 - 1518
   OX12ING5     1519 - 1523
   OX13ING5     1524 - 1528
   OX14ING5     1529 - 1533
   OX15ING5     1534 - 1538
   DRG1CL1      1539 - 1542
   DRG2CL1      1543 - 1546
   DRG3CL1      1547 - 1550
   DRG4CL1      1551 - 1554
   DRG5CL1      1555 - 1558
   DRG6CL1      1559 - 1562
   DRG7CL1      1563 - 1566
   DRG8CL1      1567 - 1570
   DRG9CL1      1571 - 1574
   DRG10CL1     1575 - 1578
   DRG11CL1     1579 - 1582
   DRG12CL1     1583 - 1586
   DRG13CL1     1587 - 1590
   DRG14CL1     1591 - 1594
   DRG15CL1     1595 - 1598
   DRG16CL1     1599 - 1602
   DRG17CL1     1603 - 1606
   DRG18CL1     1607 - 1610
   DRG19CL1     1611 - 1614
   DRG20CL1     1615 - 1618
   DRG21CL1     1619 - 1622
   DRG22CL1     1623 - 1626
   DRG23CL1     1627 - 1630
   DRG24CL1     1631 - 1634
   DRG25CL1     1635 - 1638
   DRG1CL2      1639 - 1642
   DRG2CL2      1643 - 1646
   DRG3CL2      1647 - 1650
   DRG4CL2      1651 - 1654
   DRG5CL2      1655 - 1658
   DRG6CL2      1659 - 1662
   DRG7CL2      1663 - 1666
   DRG8CL2      1667 - 1670
   DRG9CL2      1671 - 1674
   DRG10CL2     1675 - 1678
   DRG11CL2     1679 - 1682
   DRG12CL2     1683 - 1686
   DRG13CL2     1687 - 1690
   DRG14CL2     1691 - 1694
   DRG15CL2     1695 - 1698
   DRG16CL2     1699 - 1702
   DRG17CL2     1703 - 1706
   DRG18CL2     1707 - 1710
   DRG19CL2     1711 - 1714
   DRG20CL2     1715 - 1718
   DRG21CL2     1719 - 1722
   DRG22CL2     1723 - 1726
   DRG23CL2     1727 - 1730
   DRG24CL2     1731 - 1734
   DRG25CL2     1735 - 1738
   DRG1CL3      1739 - 1742
   DRG2CL3      1743 - 1746
   DRG3CL3      1747 - 1750
   DRG4CL3      1751 - 1754
   DRG5CL3      1755 - 1758
   DRG6CL3      1759 - 1762
   DRG7CL3      1763 - 1766
   DRG8CL3      1767 - 1770
   DRG9CL3      1771 - 1774
   DRG10CL3     1775 - 1778
   DRG11CL3     1779 - 1782
   DRG12CL3     1783 - 1786
   DRG13CL3     1787 - 1790
   DRG14CL3     1791 - 1794
   DRG15CL3     1795 - 1798
   DRG16CL3     1799 - 1802
   DRG17CL3     1803 - 1806
   DRG18CL3     1807 - 1810
   DRG19CL3     1811 - 1814
   DRG20CL3     1815 - 1818
   DRG21CL3     1819 - 1822
   DRG22CL3     1823 - 1826
   DRG23CL3     1827 - 1830
   DRG24CL3     1831 - 1834
   DRG25CL3     1835 - 1838
   ODR1CL1      1839 - 1842
   ODR2CL1      1843 - 1846
   ODR3CL1      1847 - 1850
   ODR4CL1      1851 - 1854
   ODR5CL1      1855 - 1858
   ODR6CL1      1859 - 1862
   ODR7CL1      1863 - 1866
   ODR8CL1      1867 - 1870
   ODR9CL1      1871 - 1874
   ODR10CL1     1875 - 1878
   ODR11CL1     1879 - 1882
   ODR12CL1     1883 - 1886
   ODR13CL1     1887 - 1890
   ODR14CL1     1891 - 1894
   ODR15CL1     1895 - 1898
   ODR1CL2      1899 - 1902
   ODR2CL2      1903 - 1906
   ODR3CL2      1907 - 1910
   ODR4CL2      1911 - 1914
   ODR5CL2      1915 - 1918
   ODR6CL2      1919 - 1922
   ODR7CL2      1923 - 1926
   ODR8CL2      1927 - 1930
   ODR9CL2      1931 - 1934
   ODR10CL2     1935 - 1938
   ODR11CL2     1939 - 1942
   ODR12CL2     1943 - 1946
   ODR13CL2     1947 - 1950
   ODR14CL2     1951 - 1954
   ODR15CL2     1955 - 1958
   ODR1CL3      1959 - 1962
   ODR2CL3      1963 - 1966
   ODR3CL3      1967 - 1970
   ODR4CL3      1971 - 1974
   ODR5CL3      1975 - 1978
   ODR6CL3      1979 - 1982
   ODR7CL3      1983 - 1986
   ODR8CL3      1987 - 1990
   ODR9CL3      1991 - 1994
   ODR10CL3     1995 - 1998
   ODR11CL3     1999 - 2002
   ODR12CL3     2003 - 2006
   ODR13CL3     2007 - 2010
   ODR14CL3     2011 - 2014
   ODR15CL3     2015 - 2018
   RSTRATA              2019 - 2021
   POPFAC               2022 - 2025
   NPOPRES              2026 - 2028
   SAMWT                2029 - 2031
.

 

VARIABLE LABELS
FACNUM  "Facility"
RESNUM  "Resident Record (Case) Number"
PMCODE01        "Medication 1 (LTCDDS code)"
PMCODE02        "Medication 2 (LTCDDS code)     "
PMCODE03        "Medication 3 (LTCDDS code)     "
PMCODE04        "Medication 4 (LTCDDS code)"
PMCODE05        "Medication 5 (LTCDDS code)"
PMCODE06        "Medication 6 (LTCDDS code)     "
PMCODE07        "Medication 7 (LTCDDS code)     "
PMCODE08        "Medication 8 (LTCDDS code)     "
PMCODE09        "Medication 9 (LTCDDS code)     "
PMCODE10        "Medication 10 (LTCDDS code)    "
PMCODE11        "Medication 11 (LTCDDS code)    "
PMCODE12        "Medication 12 (LTCDDS code)    "
PMCODE13        "Medication 13 (LTCDDS code)    "
PMCODE14        "Medication 14 (LTCDDS code)    "
PMCODE15        "Medication 15 (LTCDDS code)    "
PMCODE16        "Medication 16 (LTCDDS code)    "
PMCODE17        "Medication 17 (LTCDDS code)    "
PMCODE18        "Medication 18 (LTCDDS code)    "
PMCODE19        "Medication 19 (LTCDDS code)    "
PMCODE20        "Medication 20 (LTCDDS code)    "
PMCODE21        "Medication 21 (LTCDDS code)    "
PMCODE22        "Medication 22 (LTCDDS code)    "
PMCODE23        "Medication 23 (LTCDDS code)    "
PMCODE24        "Medication 24 (LTCDDS code)    "
PMCODE25        "Medication 25 (LTCDDS code)    "
OTHRPMED        "Medications received on a regular basis that were not given yesterday"
OTHPMC01        "Other medication 1 (LTCDDS code)       "
OTHPMC02        "Other medication 2 (LTCDDS code)       "
OTHPMC03        "Other medication 3 (LTCDDS code)       "
OTHPMC04        "Other medication 4 (LTCDDS code)       "
OTHPMC05        "Other medication 5 (LTCDDS code)       "
OTHPMC06        "Other medication 6 (LTCDDS code)       "
OTHPMC07        "Other medication 7 (LTCDDS code)       "
OTHPMC08        "Other medication 8 (LTCDDS code)       "
OTHPMC09        "Other medication 9 (LTCDDS code)       "
OTHPMC10        "Other medication 10 (LTCDDS code)      "
OTHPMC11        "Other medication 11 (LTCDDS code)      "
OTHPMC12        "Other medication 12 (LTCDDS code)      "
OTHPMC13        "Other medication 13 (LTCDDS code)      "
OTHPMC14        "Other medication 14 (LTCDDS code)      "
OTHPMC15        "Other medication 15 (LTCDDS code)      "
ANYMEDS "Resident took at least one medication  "
RXMED   "Number of medications taken the day before the facility interview"
RXOTH   "Number of medications taken regularly but not the day before the facility interview"
RXTOT   "Total number of medications taken by resident = RXMED +   RXOT"
GEN01           "Generic name code, Medication 1"      
GEN02           "Generic name code, Medication 2"      
GEN03           "Generic name code, Medication 3"      
GEN04           "Generic name code, Medication 4"      
GEN05           "Generic name code, Medication 5"      
GEN06           "Generic name code, Medication 6"      
GEN07           "Generic name code, Medication 7"      
GEN08           "Generic name code, Medication 8"      
GEN09           "Generic name code, Medication 9"      
GEN10           "Generic name code, Medication 10"
GEN11           "Generic name code, Medication 11"
GEN12           "Generic name code, Medication 12"
GEN13           "Generic name code, Medication 13"
GEN14           "Generic name code, Medication 14"
GEN15           "Generic name code, Medication 15"
GEN16           "Generic name code, Medication 16"      
GEN17           "Generic name code, Medication 17"      
GEN18           "Generic name code, Medication 18"      
GEN19           "Generic name code, Medication 19"      
GEN20           "Generic name code, Medication 20"      
GEN21           "Generic name code, Medication 21"      
GEN22           "Generic name code, Medication 22"      
GEN23           "Generic name code, Medication 23"      
GEN24           "Generic name code, Medication 24"      
GEN25           "Generic name code, Medication 25"      
OGEN01  "Generic name code, Other medication 1"
OGEN02  "Generic name code, Other medication 2"
OGEN03  "Generic name code, Other medication 3"
OGEN04  "Generic name code, Other medication 4"
OGEN05  "Generic name code, Other medication 5"
OGEN06  "Generic name code, Other medication 6"
OGEN07  "Generic name code,Other medication 7"  
OGEN08  "Generic name code, Other medication 8"
OGEN09  "Generic name code, Other medication 9"
OGEN10  "Generic name code, Other medication 10"        
OGEN11  "Generic name code, Other medication 11"        
OGEN12  "Generic name code, Other medication 12"        
OGEN13  "Generic name code, Other medication 13"        
OGEN14  "Generic name code, Other medication 14"        
OGEN15  "Generic name code, Other medication 15"        
COMST01 "Composition status code of Medication 1"      
COMST02 "Composition status code ofMedication 2"        
COMST03 "Composition status code of Medication 3"      
COMST04 "Composition status code of Medication 4"      
COMST05 "Composition status code of Medication 5"      
COMST06 "Composition status code of Medication 6"      
COMST07 "Composition status code of Medication 7"      
COMST08 "Composition status code of Medication 8"      
COMST09 "Composition status code of Medication 9"      
COMST10 "Composition status code of Medication 10"      
COMST11 "Composition status code of Medication 11"      
COMST12 "Composition status code of Medication 12"      
COMST13 "Composition status code of Medication 13"      
COMST14 "Composition status code of Medication 14"      
COMST15 "Composition status code of Medication 15"      
COMST16 "Composition status code of Medication 16"      
COMST17 "Composition status code of Medication 17"      
COMST18 "Composition status code of Medication 18"      
COMST19 "Composition status code of Medication 19"      
COMST20 "Composition status code of Medication 20"      
COMST21 "Composition status code of Medication 21"      
COMST22 "Composition status code of Medication 22"      
COMST23 "Composition status code of Medication 23"      
COMST24 "Composition status code of Medication 24"      
COMST25 "Composition status code of Medication 25"      
OCOMST01        "Composition status code of Other medication 1"
OCOMST02        "Composition status code of Other medication 2"
OCOMST03        "Composition status code of Other medication 3"
OCOMST04        "Composition status code of Other medication 4"
OCOMST05        "Composition status code of Other medication 5"
OCOMST06        "Composition status code of Other medication 6"
OCOMST07        "Composition status code of Other medication 7"
OCOMST08        "Composition status code of Other medication 8"
OCOMST09        "Composition status code of Other medication 9"
OCOMST10        "Composition status code of Other medication 10"        
OCOMST11        "Composition status code of Other medication 11"        
OCOMST12        "Composition status code of Other medication 12"        
OCOMST13        "Composition status code of Other medication 13"        
OCOMST14        "Composition status code of Other medication 14"        
OCOMST15        "Composition status code of Other medication 15"        
RXST01  "Prescription status code for Medication 1"    
RXST02  "Prescription status code for Medication 2"    
RXST03  "Prescription status code for Medication 3"    
RXST04  "Prescription status code for Medication 4"    
RXST05  "Prescription status code for Medication 5"    
RXST06  "Prescription status code for Medication 6"    
RXST07  "Prescription status code for Medication 7"    
RXST08  "Prescription status code for Medication 8"    
RXST09  "Prescription status code for Medication 9"    
RXST10  "Prescription status code for Medication 10"    
RXST11  "Prescription status code for Medication 11"    
RXST12  "Prescription status code for Medication 12"    
RXST13  "Prescription status code for Medication 13"    
RXST14  "Prescription status code for Medication 14"    
RXST15  "Prescription status code for Medication 15"    
RXST16  "Prescription status code for Medication 16"    
RXST17  "Prescription status code for Medication 17"    
RXST18  "Prescription status code for Medication 18"    
RXST19  "Prescription status code for Medication 19"    
RXST20  "Prescription status code for Medication 20"    
RXST21  "Prescription status code for Medication 21"    
RXST22  "Prescription status code for Medication 22"    
RXST23  "Prescription status code for Medication 23"    
RXST24  "Prescription status code for Medication 24"    
RXST25  "Prescription status code for Medication 25"    
ORXST01 "Prescription status code for Other medication 1"      
ORXST02 "Prescription status code for Other medication 2"      
ORXST03 "Prescription status code for Other medication 3"      
ORXST04 "Prescription status code for Other medication 4"      
ORXST05 "Prescription status code for Other medication 5"      
ORXST06 "Prescription status code for Other medication 6"      
ORXST07 "Prescription status code for Other medication 7"      
ORXST08 "Prescription status code for Other medication 8"      
ORXST09 "Prescription status code for Other medication 9"      
ORXST10 "Prescription status code for Other medication 10"      
ORXST11 "Prescription status code for Other medication 11"      
ORXST12 "Prescription status code for Other medication 12"      
ORXST13 "Prescription status code for Other medication 13"      
ORXST14 "Prescription status code for Other medication 14"      
ORXST15 "Prescription status code for Other medication 15"      
CONTR01 "DEA status of Medication 1"    
CONTR02 "DEA status of Medication 2"    
CONTR03 "DEA status of Medication 3"    
CONTR04 "DEA status of Medication 4"    
CONTR05 "DEA status of Medication 5"    
CONTR06 "DEA status of Medication 6"    
CONTR07 "DEA status of Medication 7"    
CONTR08 "DEA status of Medication 8"    
CONTR09 "DEA status of Medication 9"    
CONTR10 "DEA status of Medication 10"
CONTR11 "DEA status of Medication 11"
CONTR12 "DEA status of Medication 12"
CONTR13 "DEA status of Medication 13"
CONTR14 "DEA status of Medication 14"
CONTR15 "DEA status of Medication 15"
CONTR16 "DEA status of Medication 16"  
CONTR17 "DEA status of Medication 17"  
CONTR18 "DEA status of Medication 18"  
CONTR19 "DEA status of Medication 19"  
CONTR20 "DEA status of Medication 20"  
CONTR21 "DEA status of Medication 21"  
CONTR22 "DEA status of Medication 22"  
CONTR23 "DEA status of Medication 23"  
CONTR24 "DEA status of Medication 24"  
CONTR25 "DEA status of Medication 25"  
OCONTR01        "DEA status of Other medication 1"      
OCONTR02        "DEA status of Other medication 2"      
OCONTR03        "DEA status of Other medication 3"      
OCONTR04        "DEA status of Other medication 4"      
OCONTR05        "DEA status of Other medication 5"      
OCONTR06        "DEA status of Other medication 6"      
OCONTR07        "DEA status of Other medication 7"
OCONTR08        "DEA status of Other medication 8"      
OCONTR09        "DEA status of Other medication 9"      
OCONTR10        "DEA status of Other medication 10"    
OCONTR11        "DEA status of Other medication 11"    
OCONTR12        "DEA status of Other medication 12"    
OCONTR13        "DEA status of Other medication 13"    
OCONTR14        "DEA status of Other medication 14"    
OCONTR15        "DEA status of Other medication 15"    
RX1ING1 "Ingredient code 1, Medication 1"
RX2ING1 "Ingredient code 1, Medication 2"
RX3ING1 "Ingredient code 1, Medication 3"
RX4ING1 "Ingredient code 1, Medication 4"
RX5ING1 "Ingredient code 1, Medication 5"
RX6ING1 "Ingredient code 1, Medication 6"
RX7ING1 "Ingredient code 1, Medication 7"
RX8ING1 "Ingredient code 1, Medication 8"
RX9ING1 "Ingredient code 1, Medication 9"
RX10ING1        "Ingredient code 1, Medication 10"      
RX11ING1        "Ingredient code 1, Medication 11"      
RX12ING1        "Ingredient code 1, Medication 12"      
RX13ING1        "Ingredient code 1, Medication 13"      
RX14ING1        "Ingredient code 1, Medication 14"      
RX15ING1        "Ingredient code 1, Medication 15"      
RX16ING1        "Ingredient code 1, Medication 16"      
RX17ING1        "Ingredient code 1, Medication 17"      
RX18ING1        "Ingredient code 1, Medication 18"      
RX19ING1        "Ingredient code 1, Medication 19"      
RX20ING1        "Ingredient code 1, Medication 20"      
RX21ING1        "Ingredient code 1, Medication 21"      
RX22ING1        "Ingredient code 1, Medication 22"      
RX23ING1        "Ingredient code 1, Medication 23"      
RX24ING1        "Ingredient code 1, Medication 24"      
RX25ING1        "Ingredient code 1, Medication 25"      
RX1ING2 "Ingredient code 2, Medication 1"
RX2ING2 "Ingredient code 2, Medication 2"
RX3ING2 "Ingredient code 2, Medication 3"
RX4ING2 "Ingredient code 2, Medication 4"
RX5ING2 "Ingredient code 2, Medication 5"
RX6ING2 "Ingredient code 2, Medication 6"
RX7ING2 "Ingredient code 2, Medication 7"
RX8ING2 "Ingredient code 2, Medication 8"
RX9ING2 "Ingredient code 2, Medication 9"
RX10ING2        "Ingredient code 2, Medication 10"
RX11ING2        "Ingredient code 2, Medication 11"
RX12ING2        "Ingredient code 2, Medication 12"
RX13ING2        "Ingredient code 2, Medication 13"
RX14ING2        "Ingredient code 2, Medication 14"
RX15ING2        "Ingredient code 2, Medication 15"
RX16ING2        "Ingredient code 2, Medication 16"
RX17ING2        "Ingredient code 2, Medication 17"
RX18ING2        "Ingredient code 2, Medication 18"
RX19ING2        "Ingredient code 2, Medication 19"
RX20ING2        "Ingredient code2, Medication 20"
RX21ING2        "Ingredient code 2, Medication 21"
RX22ING2        "Ingredient code 2, Medication 22"
RX23ING2        "Ingredient code 2, Medication 23"
RX24ING2        "Ingredient code 2, Medication 24"
RX25ING2        "Ingredient code 2, Medication 25"
RX1ING3 "Ingredient code 3, Medication 1"
RX2ING3 "Ingredient code 3, Medication 2"
RX3ING3 "Ingredient code 3, Medication 3"
RX4ING3 "Ingredient code 3, Medication 4"
RX5ING3 "Ingredient code 3, Medication 5"
RX6ING3 "Ingredient code 3, Medication 6"
RX7ING3 "Ingredient code 3, Medication 7"
RX8ING3 "Ingredient code 3, Medication 8"
RX9ING3 "Ingredient code 3, Medication 9"
RX10ING3        "Ingredient code 3, Medication 10"
RX11ING3        "Ingredient code 3, Medication 11"
RX12ING3        "Ingredient code 3, Medication 12"
RX13ING3        "Ingredient code 3, Medication 13"
RX14ING3        "Ingredient code 3, Medication 14"
RX15ING3        "Ingredient code 3, Medication 15"
RX16ING3        "Ingredient code 3, Medication 16"
RX17ING3        "Ingredient code 3, Medication 17"
RX18ING3        "Ingredient code 3, Medication 18"
RX19ING3        "Ingredient code 3, Medication 19"
RX20ING3        "Ingredient code 3, Medication 20"
RX21ING3        "Ingredient code 3, Medication 21"
RX22ING3        "Ingredient code 3, Medication 22"
RX23ING3        "Ingredient code 3, Medication 23"
RX24ING3        "Ingredient code 3, Medication 24"
RX25ING3        "Ingredient code 3, Medication 25"
RX1ING4 "Ingredient code 4, Medication 1"
RX2ING4 "Ingredient code 4, Medication 2"
RX3ING4 "Ingredient code 4, Medication 3"
RX4ING4 "Ingredient code 4, Medication 4"
RX5ING4 "Ingredient code 4, Medication 5"
RX6ING4 "Ingredient code 4, Medication 6"
RX7ING4 "Ingredient code 4, Medication 7"
RX8ING4 "Ingredient code 4, Medication 8"
RX9ING4 "Ingredient code 4, Medication 9"
RX10ING4        "Ingredient code 4, Medication 10"      
RX11ING4        "Ingredient code 4, Medication 11"      
RX12ING4        "Ingredient code 4, Medication 12"      
RX13ING4        "Ingredient code 4, Medication 13"      
RX14ING4        "Ingredient code 4, Medication 14"      
RX15ING4        "Ingredient code 4, Medication 15"      
RX16ING4        "Ingredient code 4, Medication 16"      
RX17ING4        "Ingredient code 4, Medication 17"      
RX18ING4        "Ingredient code 4, Medication 18"      
RX19ING4        "Ingredient code 4, Medication 19"      
RX20ING4        "Ingredient code 4, Medication 20"      
RX21ING4        "Ingredient code 4, Medication 21"      
RX22ING4        "Ingredient code 4, Medication 22"      
RX23ING4        "Ingredient code 4, Medication 23"      
RX24ING4        "Ingredient code 4, Medication 24"      
RX25ING4        "Ingredient code 4, Medication 25"      
RX1ING5 "Ingredient code 5, Medication 1"        
RX2ING5 "Ingredient code 5, Medication 2"
RX3ING5 "Ingredient code 5, Medication 3"
RX4ING5 "Ingredient code 5, Medication 4"
RX5ING5 "Ingredient code 5, Medication 5"
RX6ING5 "Ingredient code 5, Medication 6"
RX7ING5 "Ingredient code 5, Medication 7"
RX8ING5 "Ingredient code 5, Medication 8"
RX9ING5 "Ingredient code 5, Medication 9"
RX10ING5        "Ingredient code 5, Medication 10"      
RX11ING5        "Ingredient code 5, Medication 11"      
RX12ING5        "Ingredient code 5, Medication 12"      
RX13ING5        "Ingredient code 5, Medication 13"      
RX14ING5        "Ingredient code 5, Medication 14"      
RX15ING5        "Ingredient code 5, Medication 15"      
RX16ING5        "Ingredient code 5, Medication 16"      
RX17ING5        "Ingredient code 5, Medication 17"      
RX18ING5        "Ingredient code 5, Medication 18"      
RX19ING5        "Ingredient code 5, Medication 19"      
RX20ING5        "Ingredient code 5, Medication 20"      
RX21ING5        "Ingredient code 5, Medication 21"      
RX22ING5        "Ingredient code 5, Medication 22"      
RX23ING5        "Ingredient code 5, Medication 23"      
RX24ING5        "Ingredient code 5, Medication 24"      
RX25ING5        "Ingredient code 5, Medication 25"      
OX1ING1 "Ingredient code 1, Other medication 1"
OX2ING1 "Ingredient code 1, Other medication 2"
OX3ING1 "Ingredient code 1, Other medication 3"
OX4ING1 "Ingredient code 1, Other medication 4"
OX5ING1 "Ingredient code 1, Other medication 5"
OX6ING1 "Ingredient code 1, Other medication 6"
OX7ING1 "Ingredient code 1, Other medication 7"
OX8ING1 "Ingredient code 1, Other medication 8"
OX9ING1 "Ingredient code 1, Other medication 9"
OX10ING1        "Ingredient code 1, Other medication 10"        
OX11ING1        "Ingredient code 1, Other medication 11"        
OX12ING1        "Ingredient code 1, Other medication 12"        
OX13ING1        "Ingredient code 1, Other medication 13"        
OX14ING1        "Ingredient code 1, Other medication 14"        
OX15ING1        "Ingredient code 1, Other medication 15"        
OX1ING2 "Ingredient code 2, Other medication 1"
OX2ING2 "Ingredient code 2, Other medication 2"
OX3ING2 "Ingredient code 2, Other medication 3"
OX4ING2 "Ingredient code 2, Other medication 4"
OX5ING2 "Ingredient code 2, Other medication 5"
OX6ING2 "Ingredient code 2, Other medication 6"
OX7ING2 "Ingredient code 2, Other medication 7"
OX8ING2 "Ingredient code 2, Other medication 8"
OX9ING2 "Ingredient code 2, Other medication 9"
OX10ING2        "Ingredient code 2, Other medication 10"        
OX11ING2        "Ingredient code 2, Other medication 11"        
OX12ING2        "Ingredient code 2, Other medication 12"        
OX13ING2        "Ingredient code 2, Other medication 13"        
OX14ING2        "Ingredient code 2, Other medication 14"        
OX15ING2        "Ingredient code 2, Other medication 15"        
OX1ING3 "Ingredient code 3, Other medication 1"
OX2ING3 "Ingredient code 3, Other medication 2"
OX3ING3 "Ingredient code 3, Other medication 3"
OX4ING3 "Ingredient code 3, Other medication 4"
OX5ING3 "Ingredient code 3, Other medication 5"
OX6ING3 "Ingredient code 3, Other medication 6"
OX7ING3 "Ingredient code 3, Other medication 7"
OX8ING3 "Ingredient code 3, Other medication 8"
OX9ING3 "Ingredient code 3, Other medication 9"
OX10ING3        "Ingredient code 3, Other medication 10"        
OX11ING3        "Ingredient code 3, Other medication 11"        
OX12ING3        "Ingredient code 3, Other medication 12"        
OX13ING3        "Ingredient code 3, Other medication 13"        
OX14ING3        "Ingredient code 3, Other medication 14"        
OX15ING3        "Ingredient code 3, Other medication 15"        
OX1ING4 "Ingredient code 4, Other medication 1"
OX2ING4 "Ingredient code 4, Other medication 2"
OX3ING4 "Ingredient code 4, Other medication 3"
OX4ING4 "Ingredient code 4, Other medication 4"
OX5ING4 "Ingredient code 4, Other medication 5"
OX6ING4 "Ingredient code 4, Other medication 6"
OX7ING4 "Ingredient code 4, Other medication 7"
OX8ING4 "Ingredient code 4, Other medication 8"
OX9ING4 "Ingredient code 4, Other medication 9"
OX10ING4        "Ingredient code 4, Other medication 10"        
OX11ING4        "Ingredient code 4, Other medication 11"        
OX12ING4        "Ingredient code 4, Other medication 12"        
OX13ING4        "Ingredient code 4, Other medication 13"        
OX14ING4        "Ingredient code 4, Other medication 14"        
OX15ING4        "Ingredient code 4, Other medication 15"        
OX1ING5 "Ingredient code 5, Other medication 1"
OX2ING5 "Ingredient code 5, Other medication 2"
OX3ING5 "Ingredient code 5, Other medication 3"
OX4ING5 "Ingredient code 5, Other medication 4"
OX5ING5 "Ingredient code 5, Other medication 5"
OX6ING5 "Ingredient code 5, Other medication 6"
OX7ING5 "Ingredient code 5, Other medication 7"
OX8ING5 "Ingredient code 5, Other medication 8"
OX9ING5 "Ingredient code 5, Other medication 9"
OX10ING5        "Ingredient code 5, Other medication 10"        
OX11ING5        "Ingredient code 5, Other medication 11"        
OX12ING5        "Ingredient code 5, Other medication 12"        
OX13ING5        "Ingredient code 5, Other medication 13"        
OX14ING5        "Ingredient code 5, Other medication 14"        
OX15ING5        "Ingredient code 5, Other medication 15"        
DRG1CL1 "NDC therapeutic class code 1, Medication 1"    
DRG2CL1 "NDC therapeutic class code 1, Medication 2"    
DRG3CL1 "NDC therapeutic class code 1, Medication 3"    
DRG4CL1 "NDC therapeutic class code 1, Medication 4"    
DRG5CL1 "NDC therapeutic class code 1, Medication 5"    
DRG6CL1 "NDC therapeutic class code 1, Medication 6"    
DRG7CL1 "NDC therapeutic class code 1, Medication 7"    
DRG8CL1 "NDC therapeutic class code 1, Medication 8"    
DRG9CL1 "NDC therapeutic class code 1, Medication 9"    
DRG10CL1        "NDC therapeutic class code 1, Medication 10"  
DRG11CL1        "NDC therapeutic class code 1, Medication 11"  
DRG12CL1        "NDC therapeutic class code 1, Medication 12"  
DRG13CL1        "NDC therapeutic class code 1, Medication 13"  
DRG14CL1        "NDC therapeutic class code 1, Medication 14"  
DRG15CL1        "NDC therapeutic class code 1, Medication 15"  
DRG16CL1        "NDC therapeutic class code 1, Medication 16"  
DRG17CL1        "NDC therapeutic class code 1, Medication 17"  
DRG18CL1        "NDC therapeutic class code 1, Medication 18"  
DRG19CL1        "NDC therapeutic class code 1, Medication 19"  
DRG20CL1        "NDC therapeutic class code 1, Medication 20"  
DRG21CL1        "NDC therapeutic class code 1, Medication 21"  
DRG22CL1        "NDC therapeutic class code 1, Medication 22"  
DRG23CL1        "NDC therapeutic class code 1, Medication 23"  
DRG24CL1        "NDC therapeutic class code 1, Medication 24"  
DRG25CL1        "NDC therapeutic class code 1, Medication 25"  
DRG1CL2 "NDC therapeutic class code 2, Medication 1"    
DRG2CL2 "NDC therapeutic class code 2, Medication 2"    
DRG3CL2 "NDC therapeutic class code 2, Medication 3"    
DRG4CL2 "NDC therapeutic class code 2, Medication 4"    
DRG5CL2 "NDC therapeutic class code 2, Medication 5"    
DRG6CL2 "NDC therapeutic class code 2, Medication 6"    
DRG7CL2 "NDC therapeutic class code 2, Medication 7"    
DRG8CL2 "NDC therapeutic class code 2, Medication 8"    
DRG9CL2 "NDC therapeutic class code 2, Medication 9"    
DRG10CL2        "NDC therapeutic class code 2, Medication 10"  
DRG11CL2        "NDC therapeutic class code 2, Medication 11"  
DRG12CL2        "NDC therapeutic class code 2, Medication 12"  
DRG13CL2        "NDC therapeutic class code 2, Medication 13"  
DRG14CL2        "NDC therapeutic class code 2, Medication 14"  
DRG15CL2        "NDC therapeutic class code 2, Medication 15"  
DRG16CL2        "NDC therapeutic class code 2, Medication 16"  
DRG17CL2        "NDC therapeutic class code 2, Medication 17"  
DRG18CL2        "NDC therapeutic class code 2, Medication 18"  
DRG19CL2        "NDC therapeutic class code 2, Medication 19"  
DRG20CL2        "NDC therapeutic class code 2, Medication 20"  
DRG21CL2        "NDC therapeutic class code 2, Medication 21"  
DRG22CL2        "NDC therapeutic class code 2, Medication 22"  
DRG23CL2        "NDC therapeutic class code 2, Medication 23"  
DRG24CL2        "NDC therapeutic class code 2, Medication 24"  
DRG25CL2        "NDC therapeutic class code 2, Medication 25"  
DRG1CL3 "NDC therapeutic class code 3, Medication 1"    
DRG2CL3 "NDC therapeutic class code 3, Medication 2"    
DRG3CL3 "NDC therapeutic class code 3, Medication 3"    
DRG4CL3 "NDC therapeutic class code 3, Medication 4"    
DRG5CL3 "NDC therapeutic class code 3, Medication 5"    
DRG6CL3 "NDC therapeutic class code 3, Medication 6"    
DRG7CL3 "NDC therapeutic class code 3, Medication 7"    
DRG8CL3 "NDC therapeutic class code 3, Medication 8"    
DRG9CL3 "NDC therapeutic class code 3, Medication 9"    
DRG10CL3        "NDC therapeutic class code 3, Medication 10"  
DRG11CL3        "NDC therapeutic class code 3, Medication 11"  
DRG12CL3        "NDC therapeutic class code 3, Medication 12"  
DRG13CL3        "NDC therapeutic class code 3, Medication 13"  
DRG14CL3        "NDC therapeutic class code 3, Medication 14"  
DRG15CL3        "NDC therapeutic class code 3, Medication 15"  
DRG16CL3        "NDC therapeutic class code 3, Medication 16"  
DRG17CL3        "NDC therapeutic class code 3, Medication 17"  
DRG18CL3        "NDC therapeutic class code 3, Medication 18"  
DRG19CL3        "NDC therapeutic class code 3, Medication 19"  
DRG20CL3        "NDC therapeutic class code 3, Medication 20"  
DRG21CL3        "NDC therapeutic class code 3, Medication 21"  
DRG22CL3        "NDC therapeutic class code 3, Medication 22"  
DRG23CL3        "NDC therapeutic class code 3, Medication 23"  
DRG24CL3        "NDC therapeutic class code 3, Medication 24"  
DRG25CL3        "NDC therapeutic class code 3, Medication 25"  
ODR1CL1 "NDC therapeutic class code 1, Other medication 1"      
ODR2CL1 "NDC therapeutic class code 1, Other medication 2"      
ODR3CL2 "NDC therapeutic class code 1, Other medication 3"      
ODR4CL1 "NDC therapeutic class code 1, Other medication 4"      
ODR5CL1 "NDC therapeutic class code 1, Other medication 5"      
ODR6CL1 "NDC therapeutic class code 1, Other medication 6"      
ODR7CL1 "NDC therapeutic class code 1, Other medication 7"      
ODR8CL1 "NDC therapeutic class code 1, Other medication 8"      
ODR9CL1 "NDC therapeutic class code 1, Other medication 9"      
ODR10CL1        "NDC therapeutic class code 1, Other medication 10"    
ODR11CL1        "NDC therapeutic class code 1, Other medication 11"    
ODR12CL1        "NDC therapeutic class code 1, Other medication 12"    
ODR13CL1        "NDC therapeutic class code 1, Other medication 13"    
ODR14CL1        "NDC therapeutic class code 1, Other medication 14"    
ODR15CL1        "NDC therapeutic class code 1, Other medication 15"    
ODR1CL2 "NDC therapeutic class code 2, Other medication 1"      
ODR2CL2 "NDC therapeutic class code 2, Other medication 2"      
ODR3CL2 "NDC therapeutic class code 2, Other medication 3"      
ODR4CL2 "NDC therapeutic class code 2, Other medication 4"      
ODR5CL2 "NDC therapeutic class code 2, Other medication 5"      
ODR6CL2 "NDC therapeutic class code 2, Other medication 6"      
ODR7CL2 "NDC therapeutic class code 2, Other medication 7"      
ODR8CL2 "NDC therapeutic class code 2, Other medication 8"      
ODR9CL2 "NDC therapeutic class code 2, Other medication 9"      
ODR10CL2        "NDC therapeutic class code 2, Other medication 10"    
ODR11CL2        "NDC therapeutic class code 2, Other medication 11"    
ODR12CL2        "NDC therapeutic class code 2, Other medication 12"    
ODR13CL2        "NDC therapeutic class code 2, Other medication 13"    
ODR14CL2        "NDC therapeutic class code 2, Other medication 14"    
ODR15CL2        "NDC therapeutic class code 2, Other medication 15"    
ODR1CL3 "NDC therapeutic class code 3, Other medication 1"      
ODR2CL3 "NDC therapeutic class code 3, Other medication 2"      
ODR3CL3 "NDC therapeutic class code 3, Other medication 3"      
ODR4CL3 "NDC therapeutic class code 3, Other medication 4"      
ODR5CL3 "NDC therapeutic class code 3, Other medication 5"      
ODR6CL3 "NDC therapeutic class code 3, Other medication 6"      
ODR7CL3 "NDC therapeutic class code 3, Other medication 7"      
ODR8CL3 "NDC therapeutic class code 3, Other medication 8"      
ODR9CL3 "NDC therapeutic class code 3, Other medication 9"      
ODR10CL3        "NDC therapeutic class code 3, Other medication 10"    
ODR11CL3        "NDC therapeutic class code 3, Other medication 11"    
ODR12CL3        "NDC therapeutic class code 3, Other medication 12"    
ODR13CL3        "NDC therapeutic class code 3, Other medication 13"    
ODR14CL3        "NDC therapeutic class code 3, Other medication 14"    
ODR15CL3        "NDC therapeutic class code 3, Other medication 15"    
RSTRATA "SUDAAN NEST variable"  
POPFAC  "SUDAAN TOTCNT variable "
NPOPRES "SUDAAN TOTCNT variable "
SAMWT           "weight for resident estimates".        

 

SAVE OUTFILE = 'k:\dhcs_stf\ltcsb\lld\arlene.SAV'.

*Use the SPSS data editor file save command to save the file as a permanent SPSS file.

 

 

 

[Beadle, ViAnn]

Look at the N format used on the FORMATS, PRINT FORMATS, and WRITE FORMATS command.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Albertorio, Juan (NIH/NICHD) [V]
Sent: Monday, March 12, 2007 8:23 AM
To: [hidden email]
Subject: Assistance- Juan Albertorio NCHS, CDC

Greetings! I need assistance with the following problem- read below. Any help is deeply appreciated.



Regards SPSS folks!



Juan :-)



_______________________________________



Juan R. Albertorio-Díaz

Statistician

_______________________________________



National Institute of Child and Human Development

[hidden email]

301.435-6984

[hidden email]

_______________________________________

NCHS

Office of Global Statistics, Office of Center Director

3311 Toledo Rd. Suite 2427

Hyattsville, MD, 20782

301.458.4634

[hidden email]





Hello!

At the Long-term Care Statistics Branch, they are testing an input statement for data users to create the medication public use file. The input statement successfully created the data file, but it also stripped the leading zeroes from the many codes in our data file. Is there a certain command or code we can insert into our input statement below to avoid the deletion of the leading zeroes?

Thanks in advance :-)



Juan

* 2004 NATIONAL NURSING HOME SURVEY
*PRESCRIBED MEDICATIONS PUBLIC USE DATA FILE
*SPSS INPUT STATEMENTS

FILE HANDLE DATA /NAME='K:\LTCSB2\PM\PUBLIC USE\MEDS_110906.TXT'  LRECL=2031.
DATA LIST FILE=DATA/
   FACNUM               1 - 4
   RESNUM               5 - 10
   PMCODE01     11 - 15
   PMCODE02     16 - 20
   PMCODE03     21 - 25
   PMCODE04     26 - 30
   PMCODE05     31 - 35
   PMCODE06     36 - 40
   PMCODE07     41 - 45
   PMCODE08     46 - 50
   PMCODE09     51 - 55
   PMCODE10     56 - 60
   PMCODE11     61 - 65
   PMCODE12     66 - 70
   PMCODE13     71 - 75
   PMCODE14     76 - 80
   PMCODE15     81 - 85
   PMCODE16     86 - 90
   PMCODE17     91 - 95
   PMCODE18     96 - 100
   PMCODE19     101 - 105
   PMCODE20     106 - 110
   PMCODE21     111 - 115
   PMCODE22     116 - 120
   PMCODE23     121 - 125
   PMCODE24     126 - 130
   PMCODE25     131 - 135
   OTHRPMED             136
   OTHPMC01     137 - 141
   OTHPMC02     142 - 146
   OTHPMC03     147 - 151
   OTHPMC04     152 - 156
   OTHPMC05     157 - 161
   OTHPMC06     162 - 166
   OTHPMC07     167 - 171
   OTHPMC08     172 - 176
   OTHPMC09     177 - 181
   OTHPMC10     182 - 186
   OTHPMC11     187 - 191
   OTHPMC12     192 - 196
   OTHPMC13     197 - 201
   OTHPMC14     202 - 206
   OTHPMC15     207 - 211
   ANYMEDS              212
   RXMED                213 - 214
   RXOTH                215 - 216
   RXTOT                217 - 218
   GEN01        219 - 223
   GEN02        224 - 228
   GEN03        229 - 233
   GEN04        234 - 238
   GEN05        239 - 243
   GEN06        244 - 248
   GEN07        249 - 253
   GEN08        254 - 258
   GEN09        259 - 263
   GEN10        264 - 268
   GEN11        269 - 273
   GEN12        274 - 278
   GEN13        279 - 283
   GEN14        284 - 288
   GEN15        289 - 293
   GEN16        294 - 298
   GEN17        299 - 303
   GEN18        304 - 308
   GEN19        309 - 313
   GEN20        314 - 318
   GEN21        319 - 323
   GEN22        324 - 328
   GEN23        329 - 333
   GEN24        334 - 338
   GEN25        339 - 343
   OGEN01       344 - 348
   OGEN02       349 - 353
   OGEN03       354 - 358
   OGEN04       359 - 363
   OGEN05       364 - 368
   OGEN06       369 - 373
   OGEN07       374 - 378
   OGEN08       379 - 383
   OGEN09       384 - 388
   OGEN10       389 - 393
   OGEN11       394 - 398
   OGEN12       399 - 403
   OGEN13       404 - 408
   OGEN14       409 - 413
   OGEN15       414 - 418
   COMST01      419
   COMST02      420
   COMST03      421
   COMST04      422
   COMST05      423
   COMST06      424
   COMST07      425
   COMST08      426
   COMST09      427
   COMST10      428
   COMST11      429
   COMST12      430
   COMST13      431
   COMST14      432
   COMST15      433
   COMST16      434
   COMST17      435
   COMST18      436
   COMST19      437
   COMST20      438
   COMST21      439
   COMST22      440
   COMST23      441
   COMST24      442
   COMST25      443
   OCOMST01     444
   OCOMST02     445
   OCOMST03     446
   OCOMST04     447
   OCOMST05     448
   OCOMST06     449
   OCOMST07     450
   OCOMST08     451
   OCOMST09     452
   OCOMST10     453
   OCOMST11     454
   OCOMST12     455
   OCOMST13     456
   OCOMST14     457
   OCOMST15     458
   RXST01       459
   RXST02       460
   RXST03       461
   RXST04       462
   RXST05       463
   RXST06       464
   RXST07       465
   RXST08       466
   RXST09       467
   RXST10       468
   RXST11       469
   RXST12       470
   RXST13       471
   RXST14       472
   RXST15       473
   RXST16       474
   RXST17       475
   RXST18       476
   RXST19       477
   RXST20       478
   RXST21       479
   RXST22       480
   RXST23       481
   RXST24       482
   RXST25       483
   ORXST01      484
   ORXST02      485
   ORXST03      486
   ORXST04      487
   ORXST05      488
   ORXST06      489
   ORXST07      490
   ORXST08      491
   ORXST09      492
   ORXST10      493
   ORXST11      494
   ORXST12      495
   ORXST13      496
   ORXST14      497
   ORXST15      498
   CONTR01      499
   CONTR02      500
   CONTR03      501
   CONTR04      502
   CONTR05      503
   CONTR06      504
   CONTR07      505
   CONTR08      506
   CONTR09      507
   CONTR10      508
   CONTR11      509
   CONTR12      510
   CONTR13      511
   CONTR14      512
   CONTR15      513
   CONTR16      514
   CONTR17      515
   CONTR18      516
   CONTR19      517
   CONTR20      518
   CONTR21      519
   CONTR22      520
   CONTR23      521
   CONTR24      522
   CONTR25      523
   OCONTR01     524
   OCONTR02     525
   OCONTR03     526
   OCONTR04     527
   OCONTR05     528
   OCONTR06     529
   OCONTR07     530
   OCONTR08     531
   OCONTR09     532
   OCONTR10     533
   OCONTR11     534
   OCONTR12     535
   OCONTR13     536
   OCONTR14     537
   OCONTR15     538
   RX1ING1      539 - 543
   RX2ING1      544 - 548
   RX3ING1      549 - 553
   RX4ING1      554 - 558
   RX5ING1      559 - 563
   RX6ING1      564 - 568
   RX7ING1      569 - 573
   RX8ING1      574 - 578
   RX9ING1      579 - 583
   RX10ING1     584 - 588
   RX11ING1     589 - 593
   RX12ING1     594 - 598
   RX13ING1     599 - 603
   RX14ING1     604 - 608
   RX15ING1     609 - 613
   RX16ING1     614 - 618
   RX17ING1     619 - 623
   RX18ING1     624 - 628
   RX19ING1     629 - 633
   RX20ING1     634 - 638
   RX21ING1     639 - 643
   RX22ING1     644 - 648
   RX23ING1     649 - 653
   RX24ING1     654 - 658
   RX25ING1     659 - 663
   RX1ING2      664 - 668
   RX2ING2      669 - 673
   RX3ING2      674 - 678
   RX4ING2      679 - 683
   RX5ING2      684 - 688
   RX6ING2      689 - 693
   RX7ING2      694 - 698
   RX8ING2      699 - 703
   RX9ING2      704 - 708
   RX10ING2     709 - 713
   RX11ING2     714 - 718
   RX12ING2     719 - 723
   RX13ING2     724 - 728
   RX14ING2     729 - 733
   RX15ING2     734 - 738
   RX16ING2     739 - 743
   RX17ING2     744 - 748
   RX18ING2     749 - 753
   RX19ING2     754 - 758
   RX20ING2     759 - 763
   RX21ING2     764 - 768
   RX22ING2     769 - 773
   RX23ING2     774 - 778
   RX24ING2     779 - 783
   RX25ING2     784 - 788
   RX1ING3      789 - 793
   RX2ING3      794 - 798
   RX3ING3      799 - 803
   RX4ING3      804 - 808
   RX5ING3      809 - 813
   RX6ING3      814 - 818
   RX7ING3      819 - 823
   RX8ING3      824 - 828
   RX9ING3      829 - 833
   RX10ING3     834 - 838
   RX11ING3     839 - 843
   RX12ING3     844 - 848
   RX13ING3     849 - 853
   RX14ING3     854 - 858
   RX15ING3     859 - 863
   RX16ING3     864 - 868
   RX17ING3     869 - 873
   RX18ING3     874 - 878
   RX19ING3     879 - 883
   RX20ING3     884 - 888
   RX21ING3     889 - 893
   RX22ING3     894 - 898
   RX23ING3     899 - 903
   RX24ING3     904 - 908
   RX25ING3     909 - 913
   RX1ING4      914 - 918
   RX2ING4      919 - 923
   RX3ING4      924 - 928
   RX4ING4      929 - 933
   RX5ING4      934 - 938
   RX6ING4      939 - 943
   RX7ING4      944 - 948
   RX8ING4      949 - 953
   RX9ING4      954 - 958
   RX10ING4     959 - 963
   RX11ING4     964 - 968
   RX12ING4     969 - 973
   RX13ING4     974 - 978
   RX14ING4     979 - 983
   RX15ING4     984 - 988
   RX16ING4     989 - 993
   RX17ING4     994 - 998
   RX18ING4     999 - 1003
   RX19ING4     1004 - 1008
   RX20ING4     1009 - 1013
   RX21ING4     1014 - 1018
   RX22ING4     1019 - 1023
   RX23ING4     1024 - 1028
   RX24ING4     1029 - 1033
   RX25ING4     1034 - 1038
   RX1ING5      1039 - 1043
   RX2ING5      1044 - 1048
   RX3ING5      1049 - 1053
   RX4ING5      1054 - 1058
   RX5ING5      1059 - 1063
   RX6ING5      1064 - 1068
   RX7ING5      1069 - 1073
   RX8ING5      1074 - 1078
   RX9ING5      1079 - 1083
   RX10ING5     1084 - 1088
   RX11ING5     1089 - 1093
   RX12ING5     1094 - 1098
   RX13ING5     1099 - 1103
   RX14ING5     1104 - 1108
   RX15ING5     1109 - 1113
   RX16ING5     1114 - 1118
   RX17ING5     1119 - 1123
   RX18ING5     1124 - 1128
   RX19ING5     1129 - 1133
   RX20ING5     1134 - 1138
   RX21ING5     1139 - 1143
   RX22ING5     1144 - 1148
   RX23ING5     1149 - 1153
   RX24ING5     1154 - 1158
   RX25ING5     1159 - 1163
   OX1ING1      1164 - 1168
   OX2ING1      1169 - 1173
   OX3ING1      1174 - 1178
   OX4ING1      1179 - 1183
   OX5ING1      1184 - 1188
   OX6ING1      1189 - 1193
   OX7ING1      1194 - 1198
   OX8ING1      1199 - 1203
   OX9ING1      1204 - 1208
   OX10ING1     1209 - 1213
   OX11ING1     1214 - 1218
   OX12ING1     1219 - 1223
   OX13ING1     1224 - 1228
   OX14ING1     1229 - 1233
   OX15ING1     1234 - 1238
   OX1ING2      1239 - 1243
   OX2ING2      1244 - 1248
   OX3ING2      1249 - 1253
   OX4ING2      1254 - 1258
   OX5ING2      1259 - 1263
   OX6ING2      1264 - 1268
   OX7ING2      1269 - 1273
   OX8ING2      1274 - 1278
   OX9ING2      1279 - 1283
   OX10ING2     1284 - 1288
   OX11ING2     1289 - 1293
   OX12ING2     1294 - 1298
   OX13ING2     1299 - 1303
   OX14ING2     1304 - 1308
   OX15ING2     1309 - 1313
   OX1ING3      1314 - 1318
   OX2ING3      1319 - 1323
   OX3ING3      1324 - 1328
   OX4ING3      1329 - 1333
   OX5ING3      1334 - 1338
   OX6ING3      1339 - 1343
   OX7ING3      1344 - 1348
   OX8ING3      1349 - 1353
   OX9ING3      1354 - 1358
   OX10ING3     1359 - 1363
   OX11ING3     1364 - 1368
   OX12ING3     1369 - 1373
   OX13ING3     1374 - 1378
   OX14ING3     1379 - 1383
   OX15ING3     1384 - 1388
   OX1ING4      1389 - 1393
   OX2ING4      1394 - 1398
   OX3ING4      1399 - 1403
   OX4ING4      1404 - 1408
   OX5ING4      1409 - 1413
   OX6ING4      1414 - 1418
   OX7ING4      1419 - 1423
   OX8ING4      1424 - 1428
   OX9ING4      1429 - 1433
   OX10ING4     1434 - 1438
   OX11ING4     1439 - 1443
   OX12ING4     1444 - 1448
   OX13ING4     1449 - 1453
   OX14ING4     1454 - 1458
   OX15ING4     1459 - 1463
   OX1ING5      1464 - 1468
   OX2ING5      1469 - 1473
   OX3ING5      1474 - 1478
   OX4ING5      1479 - 1483
   OX5ING5      1484 - 1488
   OX6ING5      1489 - 1493
   OX7ING5      1494 - 1498
   OX8ING5      1499 - 1503
   OX9ING5      1504 - 1508
   OX10ING5     1509 - 1513
   OX11ING5     1514 - 1518
   OX12ING5     1519 - 1523
   OX13ING5     1524 - 1528
   OX14ING5     1529 - 1533
   OX15ING5     1534 - 1538
   DRG1CL1      1539 - 1542
   DRG2CL1      1543 - 1546
   DRG3CL1      1547 - 1550
   DRG4CL1      1551 - 1554
   DRG5CL1      1555 - 1558
   DRG6CL1      1559 - 1562
   DRG7CL1      1563 - 1566
   DRG8CL1      1567 - 1570
   DRG9CL1      1571 - 1574
   DRG10CL1     1575 - 1578
   DRG11CL1     1579 - 1582
   DRG12CL1     1583 - 1586
   DRG13CL1     1587 - 1590
   DRG14CL1     1591 - 1594
   DRG15CL1     1595 - 1598
   DRG16CL1     1599 - 1602
   DRG17CL1     1603 - 1606
   DRG18CL1     1607 - 1610
   DRG19CL1     1611 - 1614
   DRG20CL1     1615 - 1618
   DRG21CL1     1619 - 1622
   DRG22CL1     1623 - 1626
   DRG23CL1     1627 - 1630
   DRG24CL1     1631 - 1634
   DRG25CL1     1635 - 1638
   DRG1CL2      1639 - 1642
   DRG2CL2      1643 - 1646
   DRG3CL2      1647 - 1650
   DRG4CL2      1651 - 1654
   DRG5CL2      1655 - 1658
   DRG6CL2      1659 - 1662
   DRG7CL2      1663 - 1666
   DRG8CL2      1667 - 1670
   DRG9CL2      1671 - 1674
   DRG10CL2     1675 - 1678
   DRG11CL2     1679 - 1682
   DRG12CL2     1683 - 1686
   DRG13CL2     1687 - 1690
   DRG14CL2     1691 - 1694
   DRG15CL2     1695 - 1698
   DRG16CL2     1699 - 1702
   DRG17CL2     1703 - 1706
   DRG18CL2     1707 - 1710
   DRG19CL2     1711 - 1714
   DRG20CL2     1715 - 1718
   DRG21CL2     1719 - 1722
   DRG22CL2     1723 - 1726
   DRG23CL2     1727 - 1730
   DRG24CL2     1731 - 1734
   DRG25CL2     1735 - 1738
   DRG1CL3      1739 - 1742
   DRG2CL3      1743 - 1746
   DRG3CL3      1747 - 1750
   DRG4CL3      1751 - 1754
   DRG5CL3      1755 - 1758
   DRG6CL3      1759 - 1762
   DRG7CL3      1763 - 1766
   DRG8CL3      1767 - 1770
   DRG9CL3      1771 - 1774
   DRG10CL3     1775 - 1778
   DRG11CL3     1779 - 1782
   DRG12CL3     1783 - 1786
   DRG13CL3     1787 - 1790
   DRG14CL3     1791 - 1794
   DRG15CL3     1795 - 1798
   DRG16CL3     1799 - 1802
   DRG17CL3     1803 - 1806
   DRG18CL3     1807 - 1810
   DRG19CL3     1811 - 1814
   DRG20CL3     1815 - 1818
   DRG21CL3     1819 - 1822
   DRG22CL3     1823 - 1826
   DRG23CL3     1827 - 1830
   DRG24CL3     1831 - 1834
   DRG25CL3     1835 - 1838
   ODR1CL1      1839 - 1842
   ODR2CL1      1843 - 1846
   ODR3CL1      1847 - 1850
   ODR4CL1      1851 - 1854
   ODR5CL1      1855 - 1858
   ODR6CL1      1859 - 1862
   ODR7CL1      1863 - 1866
   ODR8CL1      1867 - 1870
   ODR9CL1      1871 - 1874
   ODR10CL1     1875 - 1878
   ODR11CL1     1879 - 1882
   ODR12CL1     1883 - 1886
   ODR13CL1     1887 - 1890
   ODR14CL1     1891 - 1894
   ODR15CL1     1895 - 1898
   ODR1CL2      1899 - 1902
   ODR2CL2      1903 - 1906
   ODR3CL2      1907 - 1910
   ODR4CL2      1911 - 1914
   ODR5CL2      1915 - 1918
   ODR6CL2      1919 - 1922
   ODR7CL2      1923 - 1926
   ODR8CL2      1927 - 1930
   ODR9CL2      1931 - 1934
   ODR10CL2     1935 - 1938
   ODR11CL2     1939 - 1942
   ODR12CL2     1943 - 1946
   ODR13CL2     1947 - 1950
   ODR14CL2     1951 - 1954
   ODR15CL2     1955 - 1958
   ODR1CL3      1959 - 1962
   ODR2CL3      1963 - 1966
   ODR3CL3      1967 - 1970
   ODR4CL3      1971 - 1974
   ODR5CL3      1975 - 1978
   ODR6CL3      1979 - 1982
   ODR7CL3      1983 - 1986
   ODR8CL3      1987 - 1990
   ODR9CL3      1991 - 1994
   ODR10CL3     1995 - 1998
   ODR11CL3     1999 - 2002
   ODR12CL3     2003 - 2006
   ODR13CL3     2007 - 2010
   ODR14CL3     2011 - 2014
   ODR15CL3     2015 - 2018
   RSTRATA              2019 - 2021
   POPFAC               2022 - 2025
   NPOPRES              2026 - 2028
   SAMWT                2029 - 2031
.



VARIABLE LABELS
FACNUM  "Facility"
RESNUM  "Resident Record (Case) Number"
PMCODE01        "Medication 1 (LTCDDS code)"
PMCODE02        "Medication 2 (LTCDDS code)     "
PMCODE03        "Medication 3 (LTCDDS code)     "
PMCODE04        "Medication 4 (LTCDDS code)"
PMCODE05        "Medication 5 (LTCDDS code)"
PMCODE06        "Medication 6 (LTCDDS code)     "
PMCODE07        "Medication 7 (LTCDDS code)     "
PMCODE08        "Medication 8 (LTCDDS code)     "
PMCODE09        "Medication 9 (LTCDDS code)     "
PMCODE10        "Medication 10 (LTCDDS code)    "
PMCODE11        "Medication 11 (LTCDDS code)    "
PMCODE12        "Medication 12 (LTCDDS code)    "
PMCODE13        "Medication 13 (LTCDDS code)    "
PMCODE14        "Medication 14 (LTCDDS code)    "
PMCODE15        "Medication 15 (LTCDDS code)    "
PMCODE16        "Medication 16 (LTCDDS code)    "
PMCODE17        "Medication 17 (LTCDDS code)    "
PMCODE18        "Medication 18 (LTCDDS code)    "
PMCODE19        "Medication 19 (LTCDDS code)    "
PMCODE20        "Medication 20 (LTCDDS code)    "
PMCODE21        "Medication 21 (LTCDDS code)    "
PMCODE22        "Medication 22 (LTCDDS code)    "
PMCODE23        "Medication 23 (LTCDDS code)    "
PMCODE24        "Medication 24 (LTCDDS code)    "
PMCODE25        "Medication 25 (LTCDDS code)    "
OTHRPMED        "Medications received on a regular basis that were not given yesterday"
OTHPMC01        "Other medication 1 (LTCDDS code)       "
OTHPMC02        "Other medication 2 (LTCDDS code)       "
OTHPMC03        "Other medication 3 (LTCDDS code)       "
OTHPMC04        "Other medication 4 (LTCDDS code)       "
OTHPMC05        "Other medication 5 (LTCDDS code)       "
OTHPMC06        "Other medication 6 (LTCDDS code)       "
OTHPMC07        "Other medication 7 (LTCDDS code)       "
OTHPMC08        "Other medication 8 (LTCDDS code)       "
OTHPMC09        "Other medication 9 (LTCDDS code)       "
OTHPMC10        "Other medication 10 (LTCDDS code)      "
OTHPMC11        "Other medication 11 (LTCDDS code)      "
OTHPMC12        "Other medication 12 (LTCDDS code)      "
OTHPMC13        "Other medication 13 (LTCDDS code)      "
OTHPMC14        "Other medication 14 (LTCDDS code)      "
OTHPMC15        "Other medication 15 (LTCDDS code)      "
ANYMEDS "Resident took at least one medication  "
RXMED   "Number of medications taken the day before the facility interview"
RXOTH   "Number of medications taken regularly but not the day before the facility interview"
RXTOT   "Total number of medications taken by resident = RXMED +   RXOT"
GEN01           "Generic name code, Medication 1"
GEN02           "Generic name code, Medication 2"
GEN03           "Generic name code, Medication 3"
GEN04           "Generic name code, Medication 4"
GEN05           "Generic name code, Medication 5"
GEN06           "Generic name code, Medication 6"
GEN07           "Generic name code, Medication 7"
GEN08           "Generic name code, Medication 8"
GEN09           "Generic name code, Medication 9"
GEN10           "Generic name code, Medication 10"
GEN11           "Generic name code, Medication 11"
GEN12           "Generic name code, Medication 12"
GEN13           "Generic name code, Medication 13"
GEN14           "Generic name code, Medication 14"
GEN15           "Generic name code, Medication 15"
GEN16           "Generic name code, Medication 16"
GEN17           "Generic name code, Medication 17"
GEN18           "Generic name code, Medication 18"
GEN19           "Generic name code, Medication 19"
GEN20           "Generic name code, Medication 20"
GEN21           "Generic name code, Medication 21"
GEN22           "Generic name code, Medication 22"
GEN23           "Generic name code, Medication 23"
GEN24           "Generic name code, Medication 24"
GEN25           "Generic name code, Medication 25"
OGEN01  "Generic name code, Other medication 1"
OGEN02  "Generic name code, Other medication 2"
OGEN03  "Generic name code, Other medication 3"
OGEN04  "Generic name code, Other medication 4"
OGEN05  "Generic name code, Other medication 5"
OGEN06  "Generic name code, Other medication 6"
OGEN07  "Generic name code,Other medication 7"
OGEN08  "Generic name code, Other medication 8"
OGEN09  "Generic name code, Other medication 9"
OGEN10  "Generic name code, Other medication 10"
OGEN11  "Generic name code, Other medication 11"
OGEN12  "Generic name code, Other medication 12"
OGEN13  "Generic name code, Other medication 13"
OGEN14  "Generic name code, Other medication 14"
OGEN15  "Generic name code, Other medication 15"
COMST01 "Composition status code of Medication 1"
COMST02 "Composition status code ofMedication 2"
COMST03 "Composition status code of Medication 3"
COMST04 "Composition status code of Medication 4"
COMST05 "Composition status code of Medication 5"
COMST06 "Composition status code of Medication 6"
COMST07 "Composition status code of Medication 7"
COMST08 "Composition status code of Medication 8"
COMST09 "Composition status code of Medication 9"
COMST10 "Composition status code of Medication 10"
COMST11 "Composition status code of Medication 11"
COMST12 "Composition status code of Medication 12"
COMST13 "Composition status code of Medication 13"
COMST14 "Composition status code of Medication 14"
COMST15 "Composition status code of Medication 15"
COMST16 "Composition status code of Medication 16"
COMST17 "Composition status code of Medication 17"
COMST18 "Composition status code of Medication 18"
COMST19 "Composition status code of Medication 19"
COMST20 "Composition status code of Medication 20"
COMST21 "Composition status code of Medication 21"
COMST22 "Composition status code of Medication 22"
COMST23 "Composition status code of Medication 23"
COMST24 "Composition status code of Medication 24"
COMST25 "Composition status code of Medication 25"
OCOMST01        "Composition status code of Other medication 1"
OCOMST02        "Composition status code of Other medication 2"
OCOMST03        "Composition status code of Other medication 3"
OCOMST04        "Composition status code of Other medication 4"
OCOMST05        "Composition status code of Other medication 5"
OCOMST06        "Composition status code of Other medication 6"
OCOMST07        "Composition status code of Other medication 7"
OCOMST08        "Composition status code of Other medication 8"
OCOMST09        "Composition status code of Other medication 9"
OCOMST10        "Composition status code of Other medication 10"
OCOMST11        "Composition status code of Other medication 11"
OCOMST12        "Composition status code of Other medication 12"
OCOMST13        "Composition status code of Other medication 13"
OCOMST14        "Composition status code of Other medication 14"
OCOMST15        "Composition status code of Other medication 15"
RXST01  "Prescription status code for Medication 1"
RXST02  "Prescription status code for Medication 2"
RXST03  "Prescription status code for Medication 3"
RXST04  "Prescription status code for Medication 4"
RXST05  "Prescription status code for Medication 5"
RXST06  "Prescription status code for Medication 6"
RXST07  "Prescription status code for Medication 7"
RXST08  "Prescription status code for Medication 8"
RXST09  "Prescription status code for Medication 9"
RXST10  "Prescription status code for Medication 10"
RXST11  "Prescription status code for Medication 11"
RXST12  "Prescription status code for Medication 12"
RXST13  "Prescription status code for Medication 13"
RXST14  "Prescription status code for Medication 14"
RXST15  "Prescription status code for Medication 15"
RXST16  "Prescription status code for Medication 16"
RXST17  "Prescription status code for Medication 17"
RXST18  "Prescription status code for Medication 18"
RXST19  "Prescription status code for Medication 19"
RXST20  "Prescription status code for Medication 20"
RXST21  "Prescription status code for Medication 21"
RXST22  "Prescription status code for Medication 22"
RXST23  "Prescription status code for Medication 23"
RXST24  "Prescription status code for Medication 24"
RXST25  "Prescription status code for Medication 25"
ORXST01 "Prescription status code for Other medication 1"
ORXST02 "Prescription status code for Other medication 2"
ORXST03 "Prescription status code for Other medication 3"
ORXST04 "Prescription status code for Other medication 4"
ORXST05 "Prescription status code for Other medication 5"
ORXST06 "Prescription status code for Other medication 6"
ORXST07 "Prescription status code for Other medication 7"
ORXST08 "Prescription status code for Other medication 8"
ORXST09 "Prescription status code for Other medication 9"
ORXST10 "Prescription status code for Other medication 10"
ORXST11 "Prescription status code for Other medication 11"
ORXST12 "Prescription status code for Other medication 12"
ORXST13 "Prescription status code for Other medication 13"
ORXST14 "Prescription status code for Other medication 14"
ORXST15 "Prescription status code for Other medication 15"
CONTR01 "DEA status of Medication 1"
CONTR02 "DEA status of Medication 2"
CONTR03 "DEA status of Medication 3"
CONTR04 "DEA status of Medication 4"
CONTR05 "DEA status of Medication 5"
CONTR06 "DEA status of Medication 6"
CONTR07 "DEA status of Medication 7"
CONTR08 "DEA status of Medication 8"
CONTR09 "DEA status of Medication 9"
CONTR10 "DEA status of Medication 10"
CONTR11 "DEA status of Medication 11"
CONTR12 "DEA status of Medication 12"
CONTR13 "DEA status of Medication 13"
CONTR14 "DEA status of Medication 14"
CONTR15 "DEA status of Medication 15"
CONTR16 "DEA status of Medication 16"
CONTR17 "DEA status of Medication 17"
CONTR18 "DEA status of Medication 18"
CONTR19 "DEA status of Medication 19"
CONTR20 "DEA status of Medication 20"
CONTR21 "DEA status of Medication 21"
CONTR22 "DEA status of Medication 22"
CONTR23 "DEA status of Medication 23"
CONTR24 "DEA status of Medication 24"
CONTR25 "DEA status of Medication 25"
OCONTR01        "DEA status of Other medication 1"
OCONTR02        "DEA status of Other medication 2"
OCONTR03        "DEA status of Other medication 3"
OCONTR04        "DEA status of Other medication 4"
OCONTR05        "DEA status of Other medication 5"
OCONTR06        "DEA status of Other medication 6"
OCONTR07        "DEA status of Other medication 7"
OCONTR08        "DEA status of Other medication 8"
OCONTR09        "DEA status of Other medication 9"
OCONTR10        "DEA status of Other medication 10"
OCONTR11        "DEA status of Other medication 11"
OCONTR12        "DEA status of Other medication 12"
OCONTR13        "DEA status of Other medication 13"
OCONTR14        "DEA status of Other medication 14"
OCONTR15        "DEA status of Other medication 15"
RX1ING1 "Ingredient code 1, Medication 1"
RX2ING1 "Ingredient code 1, Medication 2"
RX3ING1 "Ingredient code 1, Medication 3"
RX4ING1 "Ingredient code 1, Medication 4"
RX5ING1 "Ingredient code 1, Medication 5"
RX6ING1 "Ingredient code 1, Medication 6"
RX7ING1 "Ingredient code 1, Medication 7"
RX8ING1 "Ingredient code 1, Medication 8"
RX9ING1 "Ingredient code 1, Medication 9"
RX10ING1        "Ingredient code 1, Medication 10"
RX11ING1        "Ingredient code 1, Medication 11"
RX12ING1        "Ingredient code 1, Medication 12"
RX13ING1        "Ingredient code 1, Medication 13"
RX14ING1        "Ingredient code 1, Medication 14"
RX15ING1        "Ingredient code 1, Medication 15"
RX16ING1        "Ingredient code 1, Medication 16"
RX17ING1        "Ingredient code 1, Medication 17"
RX18ING1        "Ingredient code 1, Medication 18"
RX19ING1        "Ingredient code 1, Medication 19"
RX20ING1        "Ingredient code 1, Medication 20"
RX21ING1        "Ingredient code 1, Medication 21"
RX22ING1        "Ingredient code 1, Medication 22"
RX23ING1        "Ingredient code 1, Medication 23"
RX24ING1        "Ingredient code 1, Medication 24"
RX25ING1        "Ingredient code 1, Medication 25"
RX1ING2 "Ingredient code 2, Medication 1"
RX2ING2 "Ingredient code 2, Medication 2"
RX3ING2 "Ingredient code 2, Medication 3"
RX4ING2 "Ingredient code 2, Medication 4"
RX5ING2 "Ingredient code 2, Medication 5"
RX6ING2 "Ingredient code 2, Medication 6"
RX7ING2 "Ingredient code 2, Medication 7"
RX8ING2 "Ingredient code 2, Medication 8"
RX9ING2 "Ingredient code 2, Medication 9"
RX10ING2        "Ingredient code 2, Medication 10"
RX11ING2        "Ingredient code 2, Medication 11"
RX12ING2        "Ingredient code 2, Medication 12"
RX13ING2        "Ingredient code 2, Medication 13"
RX14ING2        "Ingredient code 2, Medication 14"
RX15ING2        "Ingredient code 2, Medication 15"
RX16ING2        "Ingredient code 2, Medication 16"
RX17ING2        "Ingredient code 2, Medication 17"
RX18ING2        "Ingredient code 2, Medication 18"
RX19ING2        "Ingredient code 2, Medication 19"
RX20ING2        "Ingredient code2, Medication 20"
RX21ING2        "Ingredient code 2, Medication 21"
RX22ING2        "Ingredient code 2, Medication 22"
RX23ING2        "Ingredient code 2, Medication 23"
RX24ING2        "Ingredient code 2, Medication 24"
RX25ING2        "Ingredient code 2, Medication 25"
RX1ING3 "Ingredient code 3, Medication 1"
RX2ING3 "Ingredient code 3, Medication 2"
RX3ING3 "Ingredient code 3, Medication 3"
RX4ING3 "Ingredient code 3, Medication 4"
RX5ING3 "Ingredient code 3, Medication 5"
RX6ING3 "Ingredient code 3, Medication 6"
RX7ING3 "Ingredient code 3, Medication 7"
RX8ING3 "Ingredient code 3, Medication 8"
RX9ING3 "Ingredient code 3, Medication 9"
RX10ING3        "Ingredient code 3, Medication 10"
RX11ING3        "Ingredient code 3, Medication 11"
RX12ING3        "Ingredient code 3, Medication 12"
RX13ING3        "Ingredient code 3, Medication 13"
RX14ING3        "Ingredient code 3, Medication 14"
RX15ING3        "Ingredient code 3, Medication 15"
RX16ING3        "Ingredient code 3, Medication 16"
RX17ING3        "Ingredient code 3, Medication 17"
RX18ING3        "Ingredient code 3, Medication 18"
RX19ING3        "Ingredient code 3, Medication 19"
RX20ING3        "Ingredient code 3, Medication 20"
RX21ING3        "Ingredient code 3, Medication 21"
RX22ING3        "Ingredient code 3, Medication 22"
RX23ING3        "Ingredient code 3, Medication 23"
RX24ING3        "Ingredient code 3, Medication 24"
RX25ING3        "Ingredient code 3, Medication 25"
RX1ING4 "Ingredient code 4, Medication 1"
RX2ING4 "Ingredient code 4, Medication 2"
RX3ING4 "Ingredient code 4, Medication 3"
RX4ING4 "Ingredient code 4, Medication 4"
RX5ING4 "Ingredient code 4, Medication 5"
RX6ING4 "Ingredient code 4, Medication 6"
RX7ING4 "Ingredient code 4, Medication 7"
RX8ING4 "Ingredient code 4, Medication 8"
RX9ING4 "Ingredient code 4, Medication 9"
RX10ING4        "Ingredient code 4, Medication 10"
RX11ING4        "Ingredient code 4, Medication 11"
RX12ING4        "Ingredient code 4, Medication 12"
RX13ING4        "Ingredient code 4, Medication 13"
RX14ING4        "Ingredient code 4, Medication 14"
RX15ING4        "Ingredient code 4, Medication 15"
RX16ING4        "Ingredient code 4, Medication 16"
RX17ING4        "Ingredient code 4, Medication 17"
RX18ING4        "Ingredient code 4, Medication 18"
RX19ING4        "Ingredient code 4, Medication 19"
RX20ING4        "Ingredient code 4, Medication 20"
RX21ING4        "Ingredient code 4, Medication 21"
RX22ING4        "Ingredient code 4, Medication 22"
RX23ING4        "Ingredient code 4, Medication 23"
RX24ING4        "Ingredient code 4, Medication 24"
RX25ING4        "Ingredient code 4, Medication 25"
RX1ING5 "Ingredient code 5, Medication 1"
RX2ING5 "Ingredient code 5, Medication 2"
RX3ING5 "Ingredient code 5, Medication 3"
RX4ING5 "Ingredient code 5, Medication 4"
RX5ING5 "Ingredient code 5, Medication 5"
RX6ING5 "Ingredient code 5, Medication 6"
RX7ING5 "Ingredient code 5, Medication 7"
RX8ING5 "Ingredient code 5, Medication 8"
RX9ING5 "Ingredient code 5, Medication 9"
RX10ING5        "Ingredient code 5, Medication 10"
RX11ING5        "Ingredient code 5, Medication 11"
RX12ING5        "Ingredient code 5, Medication 12"
RX13ING5        "Ingredient code 5, Medication 13"
RX14ING5        "Ingredient code 5, Medication 14"
RX15ING5        "Ingredient code 5, Medication 15"
RX16ING5        "Ingredient code 5, Medication 16"
RX17ING5        "Ingredient code 5, Medication 17"
RX18ING5        "Ingredient code 5, Medication 18"
RX19ING5        "Ingredient code 5, Medication 19"
RX20ING5        "Ingredient code 5, Medication 20"
RX21ING5        "Ingredient code 5, Medication 21"
RX22ING5        "Ingredient code 5, Medication 22"
RX23ING5        "Ingredient code 5, Medication 23"
RX24ING5        "Ingredient code 5, Medication 24"
RX25ING5        "Ingredient code 5, Medication 25"
OX1ING1 "Ingredient code 1, Other medication 1"
OX2ING1 "Ingredient code 1, Other medication 2"
OX3ING1 "Ingredient code 1, Other medication 3"
OX4ING1 "Ingredient code 1, Other medication 4"
OX5ING1 "Ingredient code 1, Other medication 5"
OX6ING1 "Ingredient code 1, Other medication 6"
OX7ING1 "Ingredient code 1, Other medication 7"
OX8ING1 "Ingredient code 1, Other medication 8"
OX9ING1 "Ingredient code 1, Other medication 9"
OX10ING1        "Ingredient code 1, Other medication 10"
OX11ING1        "Ingredient code 1, Other medication 11"
OX12ING1        "Ingredient code 1, Other medication 12"
OX13ING1        "Ingredient code 1, Other medication 13"
OX14ING1        "Ingredient code 1, Other medication 14"
OX15ING1        "Ingredient code 1, Other medication 15"
OX1ING2 "Ingredient code 2, Other medication 1"
OX2ING2 "Ingredient code 2, Other medication 2"
OX3ING2 "Ingredient code 2, Other medication 3"
OX4ING2 "Ingredient code 2, Other medication 4"
OX5ING2 "Ingredient code 2, Other medication 5"
OX6ING2 "Ingredient code 2, Other medication 6"
OX7ING2 "Ingredient code 2, Other medication 7"
OX8ING2 "Ingredient code 2, Other medication 8"
OX9ING2 "Ingredient code 2, Other medication 9"
OX10ING2        "Ingredient code 2, Other medication 10"
OX11ING2        "Ingredient code 2, Other medication 11"
OX12ING2        "Ingredient code 2, Other medication 12"
OX13ING2        "Ingredient code 2, Other medication 13"
OX14ING2        "Ingredient code 2, Other medication 14"
OX15ING2        "Ingredient code 2, Other medication 15"
OX1ING3 "Ingredient code 3, Other medication 1"
OX2ING3 "Ingredient code 3, Other medication 2"
OX3ING3 "Ingredient code 3, Other medication 3"
OX4ING3 "Ingredient code 3, Other medication 4"
OX5ING3 "Ingredient code 3, Other medication 5"
OX6ING3 "Ingredient code 3, Other medication 6"
OX7ING3 "Ingredient code 3, Other medication 7"
OX8ING3 "Ingredient code 3, Other medication 8"
OX9ING3 "Ingredient code 3, Other medication 9"
OX10ING3        "Ingredient code 3, Other medication 10"
OX11ING3        "Ingredient code 3, Other medication 11"
OX12ING3        "Ingredient code 3, Other medication 12"
OX13ING3        "Ingredient code 3, Other medication 13"
OX14ING3        "Ingredient code 3, Other medication 14"
OX15ING3        "Ingredient code 3, Other medication 15"
OX1ING4 "Ingredient code 4, Other medication 1"
OX2ING4 "Ingredient code 4, Other medication 2"
OX3ING4 "Ingredient code 4, Other medication 3"
OX4ING4 "Ingredient code 4, Other medication 4"
OX5ING4 "Ingredient code 4, Other medication 5"
OX6ING4 "Ingredient code 4, Other medication 6"
OX7ING4 "Ingredient code 4, Other medication 7"
OX8ING4 "Ingredient code 4, Other medication 8"
OX9ING4 "Ingredient code 4, Other medication 9"
OX10ING4        "Ingredient code 4, Other medication 10"
OX11ING4        "Ingredient code 4, Other medication 11"
OX12ING4        "Ingredient code 4, Other medication 12"
OX13ING4        "Ingredient code 4, Other medication 13"
OX14ING4        "Ingredient code 4, Other medication 14"
OX15ING4        "Ingredient code 4, Other medication 15"
OX1ING5 "Ingredient code 5, Other medication 1"
OX2ING5 "Ingredient code 5, Other medication 2"
OX3ING5 "Ingredient code 5, Other medication 3"
OX4ING5 "Ingredient code 5, Other medication 4"
OX5ING5 "Ingredient code 5, Other medication 5"
OX6ING5 "Ingredient code 5, Other medication 6"
OX7ING5 "Ingredient code 5, Other medication 7"
OX8ING5 "Ingredient code 5, Other medication 8"
OX9ING5 "Ingredient code 5, Other medication 9"
OX10ING5        "Ingredient code 5, Other medication 10"
OX11ING5        "Ingredient code 5, Other medication 11"
OX12ING5        "Ingredient code 5, Other medication 12"
OX13ING5        "Ingredient code 5, Other medication 13"
OX14ING5        "Ingredient code 5, Other medication 14"
OX15ING5        "Ingredient code 5, Other medication 15"
DRG1CL1 "NDC therapeutic class code 1, Medication 1"
DRG2CL1 "NDC therapeutic class code 1, Medication 2"
DRG3CL1 "NDC therapeutic class code 1, Medication 3"
DRG4CL1 "NDC therapeutic class code 1, Medication 4"
DRG5CL1 "NDC therapeutic class code 1, Medication 5"
DRG6CL1 "NDC therapeutic class code 1, Medication 6"
DRG7CL1 "NDC therapeutic class code 1, Medication 7"
DRG8CL1 "NDC therapeutic class code 1, Medication 8"
DRG9CL1 "NDC therapeutic class code 1, Medication 9"
DRG10CL1        "NDC therapeutic class code 1, Medication 10"
DRG11CL1        "NDC therapeutic class code 1, Medication 11"
DRG12CL1        "NDC therapeutic class code 1, Medication 12"
DRG13CL1        "NDC therapeutic class code 1, Medication 13"
DRG14CL1        "NDC therapeutic class code 1, Medication 14"
DRG15CL1        "NDC therapeutic class code 1, Medication 15"
DRG16CL1        "NDC therapeutic class code 1, Medication 16"
DRG17CL1        "NDC therapeutic class code 1, Medication 17"
DRG18CL1        "NDC therapeutic class code 1, Medication 18"
DRG19CL1        "NDC therapeutic class code 1, Medication 19"
DRG20CL1        "NDC therapeutic class code 1, Medication 20"
DRG21CL1        "NDC therapeutic class code 1, Medication 21"
DRG22CL1        "NDC therapeutic class code 1, Medication 22"
DRG23CL1        "NDC therapeutic class code 1, Medication 23"
DRG24CL1        "NDC therapeutic class code 1, Medication 24"
DRG25CL1        "NDC therapeutic class code 1, Medication 25"
DRG1CL2 "NDC therapeutic class code 2, Medication 1"
DRG2CL2 "NDC therapeutic class code 2, Medication 2"
DRG3CL2 "NDC therapeutic class code 2, Medication 3"
DRG4CL2 "NDC therapeutic class code 2, Medication 4"
DRG5CL2 "NDC therapeutic class code 2, Medication 5"
DRG6CL2 "NDC therapeutic class code 2, Medication 6"
DRG7CL2 "NDC therapeutic class code 2, Medication 7"
DRG8CL2 "NDC therapeutic class code 2, Medication 8"
DRG9CL2 "NDC therapeutic class code 2, Medication 9"
DRG10CL2        "NDC therapeutic class code 2, Medication 10"
DRG11CL2        "NDC therapeutic class code 2, Medication 11"
DRG12CL2        "NDC therapeutic class code 2, Medication 12"
DRG13CL2        "NDC therapeutic class code 2, Medication 13"
DRG14CL2        "NDC therapeutic class code 2, Medication 14"
DRG15CL2        "NDC therapeutic class code 2, Medication 15"
DRG16CL2        "NDC therapeutic class code 2, Medication 16"
DRG17CL2        "NDC therapeutic class code 2, Medication 17"
DRG18CL2        "NDC therapeutic class code 2, Medication 18"
DRG19CL2        "NDC therapeutic class code 2, Medication 19"
DRG20CL2        "NDC therapeutic class code 2, Medication 20"
DRG21CL2        "NDC therapeutic class code 2, Medication 21"
DRG22CL2        "NDC therapeutic class code 2, Medication 22"
DRG23CL2        "NDC therapeutic class code 2, Medication 23"
DRG24CL2        "NDC therapeutic class code 2, Medication 24"
DRG25CL2        "NDC therapeutic class code 2, Medication 25"
DRG1CL3 "NDC therapeutic class code 3, Medication 1"
DRG2CL3 "NDC therapeutic class code 3, Medication 2"
DRG3CL3 "NDC therapeutic class code 3, Medication 3"
DRG4CL3 "NDC therapeutic class code 3, Medication 4"
DRG5CL3 "NDC therapeutic class code 3, Medication 5"
DRG6CL3 "NDC therapeutic class code 3, Medication 6"
DRG7CL3 "NDC therapeutic class code 3, Medication 7"
DRG8CL3 "NDC therapeutic class code 3, Medication 8"
DRG9CL3 "NDC therapeutic class code 3, Medication 9"
DRG10CL3        "NDC therapeutic class code 3, Medication 10"
DRG11CL3        "NDC therapeutic class code 3, Medication 11"
DRG12CL3        "NDC therapeutic class code 3, Medication 12"
DRG13CL3        "NDC therapeutic class code 3, Medication 13"
DRG14CL3        "NDC therapeutic class code 3, Medication 14"
DRG15CL3        "NDC therapeutic class code 3, Medication 15"
DRG16CL3        "NDC therapeutic class code 3, Medication 16"
DRG17CL3        "NDC therapeutic class code 3, Medication 17"
DRG18CL3        "NDC therapeutic class code 3, Medication 18"
DRG19CL3        "NDC therapeutic class code 3, Medication 19"
DRG20CL3        "NDC therapeutic class code 3, Medication 20"
DRG21CL3        "NDC therapeutic class code 3, Medication 21"
DRG22CL3        "NDC therapeutic class code 3, Medication 22"
DRG23CL3        "NDC therapeutic class code 3, Medication 23"
DRG24CL3        "NDC therapeutic class code 3, Medication 24"
DRG25CL3        "NDC therapeutic class code 3, Medication 25"
ODR1CL1 "NDC therapeutic class code 1, Other medication 1"
ODR2CL1 "NDC therapeutic class code 1, Other medication 2"
ODR3CL2 "NDC therapeutic class code 1, Other medication 3"
ODR4CL1 "NDC therapeutic class code 1, Other medication 4"
ODR5CL1 "NDC therapeutic class code 1, Other medication 5"
ODR6CL1 "NDC therapeutic class code 1, Other medication 6"
ODR7CL1 "NDC therapeutic class code 1, Other medication 7"
ODR8CL1 "NDC therapeutic class code 1, Other medication 8"
ODR9CL1 "NDC therapeutic class code 1, Other medication 9"
ODR10CL1        "NDC therapeutic class code 1, Other medication 10"
ODR11CL1        "NDC therapeutic class code 1, Other medication 11"
ODR12CL1        "NDC therapeutic class code 1, Other medication 12"
ODR13CL1        "NDC therapeutic class code 1, Other medication 13"
ODR14CL1        "NDC therapeutic class code 1, Other medication 14"
ODR15CL1        "NDC therapeutic class code 1, Other medication 15"
ODR1CL2 "NDC therapeutic class code 2, Other medication 1"
ODR2CL2 "NDC therapeutic class code 2, Other medication 2"
ODR3CL2 "NDC therapeutic class code 2, Other medication 3"
ODR4CL2 "NDC therapeutic class code 2, Other medication 4"
ODR5CL2 "NDC therapeutic class code 2, Other medication 5"
ODR6CL2 "NDC therapeutic class code 2, Other medication 6"
ODR7CL2 "NDC therapeutic class code 2, Other medication 7"
ODR8CL2 "NDC therapeutic class code 2, Other medication 8"
ODR9CL2 "NDC therapeutic class code 2, Other medication 9"
ODR10CL2        "NDC therapeutic class code 2, Other medication 10"
ODR11CL2        "NDC therapeutic class code 2, Other medication 11"
ODR12CL2        "NDC therapeutic class code 2, Other medication 12"
ODR13CL2        "NDC therapeutic class code 2, Other medication 13"
ODR14CL2        "NDC therapeutic class code 2, Other medication 14"
ODR15CL2        "NDC therapeutic class code 2, Other medication 15"
ODR1CL3 "NDC therapeutic class code 3, Other medication 1"
ODR2CL3 "NDC therapeutic class code 3, Other medication 2"
ODR3CL3 "NDC therapeutic class code 3, Other medication 3"
ODR4CL3 "NDC therapeutic class code 3, Other medication 4"
ODR5CL3 "NDC therapeutic class code 3, Other medication 5"
ODR6CL3 "NDC therapeutic class code 3, Other medication 6"
ODR7CL3 "NDC therapeutic class code 3, Other medication 7"
ODR8CL3 "NDC therapeutic class code 3, Other medication 8"
ODR9CL3 "NDC therapeutic class code 3, Other medication 9"
ODR10CL3        "NDC therapeutic class code 3, Other medication 10"
ODR11CL3        "NDC therapeutic class code 3, Other medication 11"
ODR12CL3        "NDC therapeutic class code 3, Other medication 12"
ODR13CL3        "NDC therapeutic class code 3, Other medication 13"
ODR14CL3        "NDC therapeutic class code 3, Other medication 14"
ODR15CL3        "NDC therapeutic class code 3, Other medication 15"
RSTRATA "SUDAAN NEST variable"
POPFAC  "SUDAAN TOTCNT variable "
NPOPRES "SUDAAN TOTCNT variable "
SAMWT           "weight for resident estimates".



SAVE OUTFILE = 'k:\dhcs_stf\ltcsb\lld\arlene.SAV'.

*Use the SPSS data editor file save command to save the file as a permanent SPSS file.

[Maguin, Eugene]

Juan,

I think that what may work for you is the N format. Look in the syntax
reference documentation. This has been asked about before I think that N is
what is recommended but read the documentation for yourself.

Gene Maguin

[Richard Ristow]

At 12:29 PM 3/12/2007, Albertorio, Juan (NIH/NICHD) [V] wrote:

>The [following] input statement successfully created the data file,
>but it also stripped the leading zeroes from the many codes in our
>data file. Is there a certain command or code we can insert into our
>input statement below to avoid the deletion of the leading zeroes?

As ViAnn Beadle and Gene Maguin both wrote (I'm quoting ViAnn),

>Look at the N format used on the FORMATS, PRINT FORMATS, and WRITE
>FORMATS command.

Assigning N formats to your variables will probably give you what you
want. However, it doesn't go about it the way you may be thinking; and
the reason is an important piece of how SPSS works.

You ask, "Is there a command or code we can insert into our input
statement to avoid the deletion of the leading zeroes?"

The real answer is, there's no such command. SPSS numbers, as they're
stored after they're read in, are in a binary format in which "leading
zeroes" is meaningless. Leading zeroes in the input have no effect on
the value that's stored.

A 'format' specifies the *presentation* of a number - how it's
represented as characters, for display. N formats specify the number be
presented with leading zeroes, as ViAnn and Gene said; and that is
probably all you need.

But those leading zeroes are added when the number's formatted, and
have nothing to do with whether there were leading zeroes in the input.
One quick way to see this is to specify an N format wider than the
input: then you'll get more leading zeroes than were there in the first
place.