space
Previous Page | Next Page

Example Data

Creating SAS Data Sets for IMS


MYDATA.BIRTHDAY Data Set

The SAS data set MYDATA.BIRTHDAY is updated with data from the EMPLINF2 database.

data mydata.birthday;
  input @01 employee_id   6.
        @08 last_name     $10.
        @19 birthday      date7.;
  format employee_id   6.
         last_name     $10.
         birthday      date7.;
  datalines;
  1247 Garcia     04APR54
  1078 Gibson     23APR36
  1005 Knapp      06OCT38
  1024 Mueller    17JUN53
;

proc print data=mydata.birthday;
  title2 'SAS Data Set MYDATA.BIRTHDAY';
run;


MYDATA.CHECKS Data Set

The SAS data set MYDATA.CHECKS is used to update the ACCTDBD database.

data mydata.checks;
  length customer_name  $40.;
  input  customer_name  & $
         soc_sec_number  $11.
         check_account_number
         check_balance
         check_date  date7.;
  format check_account_number  12.
         check_balance  12.2
         check_date  date7.;
  datalines;
COWPER, KEITH  241-98-4542 183352795865 
862.31 25MAR95
OLSZEWSKI, STUART  309-22-4573 382654397566
486.00 02APR95
NAPOLITANO, BARBARA  250-36-8831 284522378774
104.20 10APR95
MCCALL, ROBERT  367-34-1543 644721295973
571.92 05APR95
;

proc print data=mydata.checks;
  title2 'SAS Data Set MYDATA.CHECKS';
run;


MYDATA.CHGDATA Data Set

The SAS data set MYDATA.CHGDATA is used to update the ACCTDBD database.

data mydata.chgdata;
  input account  12.
        charge;
  format account 14.
         charge  dollar7.;
  datalines;
345620135872 10
345620134522 7
345620123456 12
382957492811 3
345620134663 8
345620131455 6
345620104732 9
;

proc print data=mydata.chgdata;
  title2 'SAS Data Set MYDATA.CHGDATA';


MYDATA.CHKCRED Data Set

The SAS data set MYDATA.CHKCRED is used to add the checking credit path to the ACCTDBD database.

data mydata.chkcred;
        /****  CUSTOMER data    ***/
  input @1   soc_sec_number   $11.
        @13  customer_name    $40.  /
        @1   addr_line_1      $30.
        @32  addr_line_2      $30.  /
        @1   city             $28.
        @30  state            $2.
        @33  country          $20.
        @54  zip_code         $10.  /
        @1   home_phone       $12.
        @14  office_phone     $12.
        /****  CHCKACCT data    ***/
        @27  check_account_number 12.0
        @40  check_amount         12.2
        @53  check_date           date7. /
        @1   filler1              $2.
        @4   check_balance        12.2
        /****  CHCKCRDT data    ***/
        @17  check_credit_amount  12.2 
        @30  check_credit_date    date7.
        @38  filler3              $2.
        @41  check_credit_time    $8.   /
        @1   check_credit_desc    $59.;
    format check_credit_date    date7.;
  datalines;
667-73-8275 WALLS, HOOPER J.


                 345620145345
         1563.23 31MAR95    15:42:43
MAIN ST BRANCH DEPOSIT
667-73-8275 WALLS, HOOPER J.


              345620154633
       1563.23 31MAR95    15:42:43
BAD ACCT_NUM
434-62-1234 SUMMERS, MARY T.


              345620104732
       400.00 02APR95    10:23:46
ACH DEPOSIT
436-42-6394 BOOKER, APRIL M.


              345620135872
       50.00 02APR95    12:16:34
ACH DEPOSIT
434-62-1224 SMITH, JAMES MARTIN


              345620134564
       1342.42 22MAR95    23:23:52
ACH DEPOSIT
434-62-1224 SMITH, JAMES MARTIN


             345620134663
      120.00 28MAR95    10:26:45
ACH DEPOSIT
178-42-6534 PATTILLO, RODRIGUES


             745920057114
    1300.00 12JUN95    14:34:12
ACH DEPOSIT
156-45-5672 O'CONNOR, JOSEPH


            345620123456
    100.00 01APR95    12:24:34
ATM DEPOSIT
657-34-3245 BARNHARDT, PAMELA S.


           345620131455
    230.00 04APR95    14:24:11
ACH DEPOSIT
667-82-8275 COHEN, ABRAHAM


           382957492811
   100.00 16APR95    09:21:14
ACH DEPOSIT
456-45-3462 LITTLE, NANCY M.


          345620134522
  50.00 05APR95    12:14:52
ACH DEPOSIT
234-74-4612 WIKOWSKI, JONATHAN S.


          345620113263
         672.32 31MAR95
ATM DEPOSIT
;


MYDATA.CHKDEBD Data Set

The SAS data set MYDATA.CHKDEBD is used to add the checking debit path to the ACCTDBD database.

data mydata.chkdebd;
        /****  CUSTOMER data    ***/
  input @1   soc_sec_number    $11.
        @13  customer_name     $40.  /
        @1   addr_line_1       $30.
        @32  addr_line_2       $30.  /
        @1   city              $28.
        @30  state             $2.
        @33  country           $20.
        @54  zip_code          $10.  /
        @1   home_phone        $12.
        @14  office_phone      $12.
        /****  CHCKACCT data    ***/
        @27  check_account_number  12.0 
        @40  check_amount          12.2
        @53  check_date            date7. /
        @1   filler1               $2.
        @4   check_balance         12.2
        /****  CHCKDEBT data    ***/
        @17  check_debit_amount    12.2
        @30  check_debit_date      date7.
        @38  filler2               $2.
        @41  check_debit_time      $8.    /
        @1   check_debit_desc      $59.;
    format check_date    date7.;
    format check_debit_date   date7.;
  datalines;
667-73-8275 WALLS, HOOPER J.


               345620145345
   1266.34       820.00 23MAR95    23:54:53
CHECK 2958
667-73-8275 WALLS, HOOPER J.


               345620145345
   1266.34        52.00 23MAR95    23:54:53
CHECK 2948
667-73-8275 WALLS, HOOPER J.


               345620145345
   1266.34       193.00 28MAR95    22:51:43
CHECK 2951
667-73-8275 WALLS, HOOPER J.


               345620154633  1303.41 28MAR95
  1298.04          .   .

434-62-1234 SUMMERS, MARY T.
                    4322 LEON ST.
GORDONSVILLE       VA USA         26001-0670
803-657-1687    345620104732  826.05 27MAR95
  825.45          .   .

436-42-6394 BOOKER, APRIL M.
                    9712 WALLINGFORD PL.
GORDONSVILLE       VA USA          26001-0670
803-657-1346    345620135872   220.11 26MAR95
   234.89          .   30MAR94    22:34:45
CHECK 103
434-62-1224 SMITH, JAMES MARTIN
                    133 TOWNSEND ST.
GORDONSVILLE       VA USA          26001-0670
803-657-3437    345620134564   2392.93 16MAR95
   2645.34       432.87 18MAR95    22:13:48
CHECK 1826
434-62-1224 SMITH, JAMES MARTIN

               345620134564
   2645.34      19.23 18MAR95    22:13:48
CHECK 1821
434-62-1224 SMITH, JAMES MARTIN


               345620134564
  2645.34     723.23 22MAR95    21:48:12
CHECK 1828
434-62-1224 SMITH, JAMES MARTIN


               345620134564
  2645.34      82.32 22MAR95    21:48:12
CHECK 1829
434-62-1224 SMITH, JAMES MARTIN


               345620134564
  2645.34      73.62 26MAR95    21:22:24
CHECK 1830
434-62-1224 SMITH, JAMES MARTIN


               345620134564
  2645.34      31.23 26MAR95    21:22:24
CHECK 1831
434-62-1224 SMITH, JAMES MARTIN


               345620134564
   2645.34     162.87 29MAR94    22:51:12
CHECK 1835
434-62-1224 SMITH, JAMES MARTIN


               345620134564
   2645.34       7.12 29MAR95    22:51:12
CHECK 1836
434-62-1224 SMITH, JAMES MARTIN


               345620134564
   2645.34      62.34 31MAR95    23:02:12
CHECK 1833
434-62-1224 SMITH, JAMES MARTIN


               345620134663      0.00 24MAR95
      143.78      25.00 28MAR95    15:53:29
ATM MAIN ST.
178-42-6534 PATTILLO, RODRIGUES
                           9712 COOK RD.
ORANGE         VA USA           26042-1650
803-657-1346 803-657-1345 745920057114 1404.90
10JUN95     1502.78   25.89 10JUN95   11:45:25
CHECK 412
156-45-5672 O'CONNOR, JOSEPH
                           235 MAIN ST.
ORANGE         VA USA           26042-1650
803-657-5656 803-623-4257 345620123456  353.65
27MAR95    463.23     13.29 28MAR95   22:23:53
CHECK 934
156-45-5672 O'CONNOR, JOESPH


803-657-5656 803-623-4257 345620123456
         463.23   32.87 31MAR95    23:35:53
CHECK 931
156-45-5672 O'CONNOR, JOSEPH


                345620123456
    463.23      50.00 02APR95    10:23:41
ATM GREEN ST
156-45-5672 O'CONNOR, JOESPH


               345620123456
    463.23      13.42 31MAR95    23:35:53
CHECK 935
657-34-3245 BARNHARDT, PAMELA S.
                            RT 2 BOX 324
CHARLOTTESVILLE     VA USA      25804-0997
803-345-4346 803-355-2543 345620131455 
1243.25  29MAR95       1243.25       .   .

667-82-8275 COHEN, ABRAHAM
                            2345 DUKE ST.
CHARLOTTESVILLE     VA USA      25804-0997
803-657-7435 803-645-4234 382957492811 7462.51 
03APR95       7302.06       .   .

456-45-3462 LITTLE, NANCY M.
                            4543 ELGIN AVE.
RICHMOND          VA USA       26502-3317
803-657-3566   345620134522     608.24 25MAR95
     831.65      42.73 29MAR95    23:12:34
CHECK 296
456-45-3462 LITTLE, NANCY M.


               345620134522
    831.65     172.45 29MAR95    23:12:34
CHECK 301
456-45-3462 LITTLE, NANCY M.


              345620134522
    831.65      38.23 30MAR95    22:51:34
CHECK 297
456-45-3462 LITTLE, NANCY M.


               345620134522
    831.65      10.00 02APR95    21:51:34
CHECK 298
234-74-4612 WIKOWSKI, JONATHAN S.
                         4356 CAMPUS DRIVE
RICHMOND         VA USA          26502-5317
803-467-4587 803-654-7238 345620113263 672.32 
28MAR95       13.28       .   .

;


MYDATA.EMPLDATA Data Set

The SAS data set MYDATA.EMPLDATA is used to load the EMPLINF2 database.

data mydata.empldata;
  input @01 employee_id     6.
        @08 last_name       $10.
        @19 first_name      $20.
        @40 hire_date       yymmdd6.
        @47 birthday        yymmdd6.
        @54 ssn             $11. /
        @01 gender          $6.
        @08 status          $9.
        @18 phone_extension $9.
        @28 vacation        8.2
        @37 department      8.
        @46 zip_code        $5.
        @52 city_and_state  $15. /
        @01 street          $20.
        @21 security        5.
        @27 sick_leave      8.2;
  format hire_date   yymmdd6.
         birthday   yymmdd6.;
  datalines;
  1001 Waterhouse Clifton P.781231 480101 254-43-6089
Male  Full Time X5109  8.00   200 78752 Austin,TX
505 Cat Mountain Tr.  310     8.00
  1002 Bowman    Hugh E.   801230 310714 329-88-6729
Male  Full Time X5901  40.00 1000 78741 Austin,TX
47 Cypress Point Cir  310    80.00
  1003 Salazar    Yolanda   821230 401212 166-88-7516
Female Full Time X5169  80.00 200 78641 Leander,TX
6811 Picket Fence Dr  310    56.00
  1004 Knight     Althea    841229 500409 942-62-3354
Female Full Time X5218 300 78664 Round Rock,TX
8222 Whitewing Way    110    16.00
  1005 Knapp     Patrice R. 811230 371004 353-43-1272
Female Full Time X5012 8.00   100 78748 Austin,TX
19 Pack Saddle Pass   110    44.00
  1006 Garrett   Olan M.   781231 350123 776-94-3545
Male  Full Time X5208 80.00  300 78731 Austin,TX
67 Running Doe Ln.    110    60.00
  1007 Brown     Virgina P.801230 460524 675-29-9081
Female Full Time X5258 48.00  300 78610 Buda,TX
2713 Nutty Brown Mil  110    32.00
  1008 Hernandez Jesse L.   821230 330326 123-12-0987
Male  Full Time X5448 56.00  500 78664 Round Rock,TX
4319 Red Stone Lane     .     8.00
  1009 Jones     Michael Y. 850330 310521 543-87-1934
Male  Full Time X5713 80.00  800 78748 Austin,TX
23 Moonlight Bend La    .    80.00
  1010 Smith     Janet F.   811230 470807 105-32-9011
Female Full Time X5621 16.00  700 78737 Austin,TX
523 Rim Rock Road       .     8.00
  1011 Van Hotten Gwendolyn 790201 420913 766-30-9237
Female Full Time X5311  .     400 78641 Leander,TX
623 Fauntleroy Trail    .    32.00
  1012 Quintero   Pedro     810214 480221 339-94-2674
Male  Full Time X5348 32.00  400 78741 Austin,TX
77 Button Quail Cove    .    40.00
  1015 Scholl    Madison A. 830304 450319 765-43-0581
Male  Full Time X5419 40.00  500 78741 Austin,TX
3910 Covered Wagon      .    80.00
  1017 Waggonner Merrilee D.850330 360427 586-54-8967
Female Full Time X5914 56.00 1000 78722 Austin,TX
941 Bridgewater Dr.     .    40.00
  1020 Rudd      Fred       601230      . 145-67-6532
Male  Part Time        .     100
                        .      .
  1024 Mueller    Patsy     790403 520617 857-51-1838
Female Full Time X5822 40.00 900 78620 Dripping Spring
6935 Cherry Creek Rd  110    40.00
  1031 Chan       Tai       810502 460704 843-09-7123
Male  Full Time X5331 40.00  400 78755 Austin,TX
1412 Arapahoe Trail     .    80.00
  1049 Fernandez  Sophia    830516 440911 764-91-0193
Female Full Time X5847 96.00  900 78744 Austin,TX
4700 Old Stage Trail    .    40.00
  1050 Ameer      David     850530 511010 456-34-6543
Male  Full Time X5495 56.00  500 78735 Austin,TX
231 Little Hill Cir.    .      .
  1062 Littlejohn Fannie    850429 540517 978-63-3930
Female Full Time X5653 8.00  700 78660 Pflugerville,TX
813 Lime Rock Dr.     110    48.00
  1067 Cahill     Jacob     790105 401225 102-78-8765
Male  Full Time X5042 60.00  100 78748 Austin,TX
121 Hidden Hollow       .    36.00
  1071 Canady     Frank A.  810331 411119 345-91-4321
Male  Full Time X5406  8.00  500 78756 Austin,TX
741 Canyonwood Lane     .     8.00
  1074 Millsap    Joel B.   830831 360612 675-23-8027
Male  Full Time X5224 24.00  300 78755 Austin,TX
1201 Broken Bow Pass  110    48.00
  1077 Gibson     Teddy B.  850929 460423 567-89-2345
Male             X5703 80.00  800 78753 Austin,TX
4441 Hansford           .    80.00
  1078 Gibson    George J.  820930 460423 567-89-2346
Male  Full Time X5703 80.00  800 78753 Austin,TX
2311 Hansford           .    80.00
  1083 Savage    William D. 791001 530120 211-95-9608
Male  Full Time X5505 80.00  600 78737 Austin,TX
97 Cimarron Circle      .    48.00
  1086 Schmidt   Penny      811017 270219 901-45-4567
Female Full Time X5822 80.00  900 78735 Austin,TX
6419 Wild Rose Road     .    80.00
  1092 Polanski  Ivan L.    831130 471011 497-36-7845
Male  Full Time X5621 56.00 700 78620 Dripping Spring
2501 Timberline Tr.     .      .
  1101 Nathaniel  Darryl    860101 440321 584-86-6945
Male  Full Time X5544 40.00  600 78735 Austin,TX
1892 Red River Road   210     8.00
  1105 Faulkner  Carrie Ann 830102 510817 987-76-7469
Female Full Time X5417 48.00  500 78756 Austin,TX
5649 Foothill Park    110    16.00
  1112 Jones     Rita M.    790202 481224 890-98-6789
Female Full Time X5271 24.00  300 78735 Austin,TX
907 Hickory Stick       .     8.00
  1119 Goodson   Alan F.    820116 500621 234-67-8901
Male  Full Time X5512 48.00  600 78626 Georgetown,TX
11410 Smokey Hill Rd    .    16.00
  1120 Reid      David G.   830214 450815 442-04-0121
Male  Full Time X5369 80.00  400 78752 Austin,TX
1322 Lazy Lane        224    80.00
  1123 Freeman   Leopold    861030 350209 828-26-7282
Male  Part Time X5604   .    700 78757 Austin,TX
13 Timber Hills Tr.   106      .
  1133 Williamson Janice L. 831103 520519 131-41-9129
Female Full Time X5802 40.00  900 78610 Buda,TX
2706 Frontier Valley    .     8.00
  1139 Seaton     Gary     800403 561003 286-04-6279
Male  Full Time X5545 80.00  600 78757 Austin,TX
2111 Wind Ridge Road    .    80.00
  1145 Juarez    Armando   820501 470528 876-19-0378
Male  Full Time X5987 48.00 1000 78626 Georgetown,TX
1017 Woodstone Sq.      .    16.00
  1156 Reed      Kenneth D. 840830 550105 875-15-1388
Male  Full Time X5307 64.00  400 78641 Leander,TX
1349 Begonia Terrace    .    40.00
  1161 Richardson Travis Z. 860913 371130 654-54-8127
Male  Full Time X5325 88.00  400 78752 Austin,TX
2009 Mountain Lake    110    96.00
  1213 Johnson    Bradford  840131 540415 321-32-9446
Male  Full Time X5446 40.00  500 78724 Austin,TX
678 Buffalo Gap Road    .    40.00
  1217 Rodriguez Romualdo R. 810131 290209 493-77-4863
Male  Full Time X5874 32.00  900 78746 Austin,TX
804 Lazy Brook Lane     .    48.00
  1219 Kaatz      Freddie   830131 570621 181-49-4592
Male  Full Time X5387 80.00  400 78753 Austin,TX
4713 Cedar Tree Lane    .    80.00
  1234 Shropshire Leland G. 850415 490904 555-21-4173
Male  Full Time X5616 32.00  700 78752 Austin,TX
606 Bull Creek Trail    .    40.00
  1238 Throckmort Stewart Q.850516 310804 109-07-5098
Male  Full Time X5391 40.00  400 78756 Austin,TX
479 Roundup Circle      .    40.00
  1247 Garcia    Francisco  840730 550505 678-23-0123
Male  Full Time X5348 80.00  400 78756 Austin,TX
479 Whispering Wind     .    72.00
  1261 Collins    Lillian   810824 510501 302-59-2781
Female Full Time X5616 80.00  700 78664 Round Rock,TX
9117 Beaver Creek Rd    .    48.00
  1265 Slye      Leonard R. 840331 601218 434-21-1300
Male  Half Time X5123   .    200 78742 Austin,TX
4106 Main St.           .      .
  1266 Redfox    Richard B. 850902 440404 210-65-2786
Male  Full Time X5386 48.00  400 78660 Pflugerville,TX
9807 Three Oaks Tr.     .    48.00
  1272 Smith     Garland P. 850413 540405 397-80-8491
Male  Full Time X5415  8.00  500 78602 Bastrop,TX
7594 Red Cliff Rd.      .    48.00
  1313 Smith     Jerry Lee  850130 420913 823-10-0951
Male  Full Time X5169  .     200 78745 Austin,TX
8203 Friar Tuck Ln.     .    16.00
  1327 Brooks    Ruben R.   820430 520225 789-56-2109
Male  Full Time X5347 80.00  400 78744 Austin,TX
2509 Loganberry Dr.     .    80.00
  1900 Smith      John        .      .      .
                        .     100
                        .      .
;


MYDATA.INITSEG Data Set

The SAS data set MYDATA.INITSEG is used to initially load the ACCTDBD database.

data mydata.initseg;
        /****  CUSTOMER data    ***/
  input @1   soc_sec_number    $11.
        @13  customer_name     $40.  /
        @1   addr_line_1       $30.
        @32  addr_line_2       $30.  /
        @1   city              $28.
        @30  state             $2.
        @33  country           $20.
        @54  zip_code          $10.  /
        @1   home_phone        $12.
        @14  office_phone      $12.
        /****  CHCKACCT data    ***/
        @27  check_account_number  12.0 
        @40  check_amount          12.2 
        @53  check_date            date7. /
        @1   filler1               $2.
        @4   check_balance         12.2
        /****  CHCKDEBT data    ***/
        @17  check_debit_amount    12.2 
        @30  check_debit_date      date7.
        @38  filler2               $2.
        @41  check_debit_time      $8.    /
        @1   check_debit_desc      $59.;
    format check_date  date7.;
    format check_debit_date  date7.;
  datalines;
667-73-8275 WALLS, HOOPER J.
                     4525 CLARENDON RD
RAPIDAN          VA USA           22215-5600
803-657-3098 803-645-4418 345620145345 1702.19 15MAR95
        1266.34          .   19MAR94    21:22:53
CHECK 2947
;


MYDATA.PHONENUM Data Set

The SAS data set MYDATA.PHONENUM is used to update the ACCTDBD database.

data mydata.phonenum;
  soc_sec_number = '667-73-8275';
  home_phone = '703-657-3098';
  office_phone = '703-645-4418';
  output;
  soc_sec_number = '434-62-1234';
  home_phone = '703-645-441 ';
  office_phone = '            ';
  output;
  soc_sec_number = '178-42-6534';
  home_phone = '703-657-1346';
  office_phone = '703-657-1345';
  output;
  soc_sec_number = '156-45-5672';
  home_phone = '703-657-5656';
  office_phone = '703-623-4257';
  output;
  soc_sec_number = '657-34-3245';
  home_phone = '703-345-4346';
  office_phone = '703-355-5438';
  output;
  soc_sec_number = '456-45-3462';
  home_phone = '703-657-3566';
  office_phone = '703-645-1212';
  output;
  soc_sec_number = '416-41-3162';
  home_phone = '703-657-3166';
  office_phone = '703-615-1212';
  output;
run;
proc print data=mydata.phonenum;
  title2 'SAS Data Set MYDATA.PHONENUM';
run;


MYDATA.SAVCRED Data Set

The SAS data set MYDATA.SAVCRED is used to add the savings credit path to the ACCTDBD database.

data mydata.savcred;
        /****  CUSTOMER data    ***/
  input @1   soc_sec_number    $11.
        @13  customer_name     $40.  /
        @1   addr_line_1       $30.
        @32  addr_line_2       $30.  /
        @1   city              $28. 
        @30  state             $2. 
        @33  country           $20. 
        @54  zip_code          $10.  /
        @1   home_phone        $12.
        @14  office_phone      $12.
        /****  SAVEACCT data    ***/
        @27  savings_account_number 12.0 
        @40  savings_amount         12.2
        @53  savings_date           date7. /
        @1   filler4                $2.
        @4   savings_balance        12.2 
       /****  SAVECRDT data    ***/
        @17  savings_credit_amount  12.2
        @30  savings_credit_date    date7.
        @38  filler6                $2.
        @41  savings_credit_time    $8.   /
        @1   savings_credit_desc    $59.;
    format savings_credit_date  date7.;
  datalines;
667-73-8275 WALLS, HOOPER J.


             459923888253      784.29  28MAR95
   672.63         8.45 30MAR95    09:34:18
INTEREST
434-62-1234 SUMMERS, MARY T.
                               4322 LEON ST.
GORDONSVILLE        VA USA         26001-0670
             345689404732      8406.0  27MAR95
 8364.24        41.82 30MAR95    23:46:03
INTEREST
436-42-6394 BOOKER, APRIL M.
                          9712 WALLINGFORD PL.
GORDONSVILLE        VA USA         26001-0670
            144256844728       809.45 21MAR95
 1032.23        50.00 26MAR95    12:26:15
INTEREST
434-62-1224 SMITH, JAMES MARTIN
                               133 TOWNSEND ST.
GORDONSVILLE       VA USA         26001-0670
            345689473762       130.64 15MAR95
  261.64         1.31 30MAR95    23:45:53
INTEREST
434-62-1224 SMITH, JAMES MARTIN
                               133 TOWNSEND ST.
GORDONSVILLE       VA USA         26001-0670
            345689498217      9421.79 16MAR95
 9374.92        46.07 30MAR95    23:45:32
INTEREST
178-42-6534 PATTILLO, RODRIGUES
                               9712 COOK RD.
ORANGE             VA USA         26042-1650
           345689462413       950.96 15MAR95
  946.23         4.73 30MAR95    23:44:25
INTEREST
156-45-5672 O'CONNOR, JOESPH
                               235 MAIN ST.
ORANGE             VA USA         26042-1650
           345689435776       136.40 27MAR95
  284.97         1.43 30MAR95    23:48:56
INTEREST
657-34-3245 BARNHARDT, PAMELA S.
                               RT 2 BOX 324
CHARLOTTESVILLE    VA USA         25804-0997
           859993641223       845.35 18MAR95
 2553.45        71.44 26MAR95    08:41:28
INTEREST
667-82-8275 COHEN, ABRAHAM
                               2345 DUKE ST.
CHARLOTTESVILLE    VA USA         25804-0997
           884672297126       945.25 26MAR95
  793.25        52.33 28MAR95    11:45:26
INTEREST
456-45-3462 LITTLE, NANCY M.


          345689463822       929.24 25MAR95
  924.62         4.62 30MAR95    23:46:01
INTEREST
234-74-4612 WIKOWSKI, JONATHAN S.
                          4356 CAMPUS DRIVE
RICHMOND           VA USA         26502-3317
                .                     .   .
            .            .   .

;


MYDATA.SAVDEBD Data Set

The SAS data set MYDATA.SAVDEBD is used to add the savings debit path to the ACCTDBD database.

data mydata.savdebd;
        /****  CUSTOMER data    ***/
  input @1   soc_sec_number      $11.
        @13  customer_name       $40.  /
        @1   addr_line_1         $30.
        @32  addr_line_2         $30.  /
        @1   city                $28.
        @30  state               $2.
        @33  country             $20.
        @54  zip_code            $10.  /
        @1   home_phone          $12.
        @14  office_phone        $12.
        /****  SAVEACCT data    ***/
        @27  savings_account_number 12.0 
        @40  savings_amount         12.2 
        @53  savings_date           date7. /
        @1   filler4                $2.
        @4   savings_balance        12.2 
        /****  SAVEDEBT data    ***/
        @17  savings_debit_amount   12.2 
        @30  savings_debit_date     date7.
        @38  filler5                $2.
        @41  savings_debit_time     $8.    /
        @1   savings_debit_desc     $59.;
    format savings_date  date7.;
    format savings_debit_date  date7.;
  datalines;
667-73-8275 WALLS, HOOPER J.


           459923888253       784.29 28MAR95
         672.63        .   .

434-62-1234 SUMMERS, MARY T.
                               4322 LEON ST.
GORDONSVILLE       VA USA        26001-0670
          345689404732       8406.00 27MAR95
        8364.24        .   .

436-42-6394 BOOKER, APRIL M.
                         9712 WALLINGFORD PL.
GORDONSVILLE       VA USA        26001-0670
          144256844728       809.45 21MAR95
        1032.23        .   .

434-62-1224 SMITH, JAMES MARTIN
                              133 TOWNSEND ST.
GORDONSVILLE       VA USA        26001-0670
          345689473762       130.64 15MAR95
         261.64     132.31 03APR94    14:42:43
MAIN ST BRANCH WITHDRAWAL
434-62-1224 SMITH, JAMES MARTIN
                              133 TOWNSEND ST.
GORDONSVILLE       VA USA        26001-0670
          345689498217      9421.79 16MAR95
        9374.92        .   .

178-42-6534 PATTILLO, RODRIGUES
                               9712 COOK RD.
ORANGE             VA USA        26042-1650
          345689462413       950.96 15MAR95
         946.23        .   .

156-45-5672 O'CONNOR, JOESPH
                               235 MAIN ST.
ORANGE             VA USA        26042-1650
          345689435776       136.40 27MAR95
         284.97     150.00 31MAR94    12:23:42
ATM GREEN ST
657-34-3245 BARNHARDT, PAMELA S.
                               RT 2 BOX 324
CHARLOTTESVILLE    VA USA        25804-0997
          859993641223       845.35 18MAR95
        2553.45        .   .

667-82-8275 COHEN, ABRAHAM
                               2345 DUKE ST.
CHARLOTTESVILLE    VA USA        25804-0997
         884672297126       945.25 26MAR95
         793.25        .   .

456-45-3462 LITTLE, NANCY M.


         345689463822       929.24 25MAR95
         924.62        .   .

234-74-4612 WIKOWSKI, JONATHAN S.
                               4356 CAMPUS DRIVE
RICHMOND           VA USA        26502-3317
                  .                     .   .
            .          .   .

;


MYDATA.CUSTOMER Data Set

The SAS data set MYDATA.CUSTOMER is used to update the ACCTDBD database.

data mydata.customer;
        /****  CUSTOMER data    ***/
  input @1   soc_sec_number    $11.
        @13  customer_name     $40. /
        @1   addr_line_1       $30.
        @32  addr_line_2       $30. /
        @1   city              $28.
        @30  state             $2.
        @33  country           $20.
        @54  zip_code          $10. /
        @1   home_phone        $12.
        @14  office_phone      $12.; 
  datalines;
131-73-2785 HUTTLINGER, HORTENSE H.
                             2785 HILLARY PL
RAPIDAN          VA USA           22215-5600
803-657-4097 803-645-4419
232-62-2432 MANNERLY, MAYNARD M.
                             6525 MORGAN ST
RAPIDAN          VA USA           22215-5600
803-657-9066 803-645-4420
;


MYDATA.NEWADDR Data Set

The SAS data set MYDATA.NEWADDR is in Version 6 format and is used to update the ACCTDBD database.

data mydata.newaddr;
  /****  CUSTOMER data    ***/
  input @1   ssn         $11.
        /* social security number */
        @13  newaddr1    $30.
        /* first line of address */
        @44  newaddr2    $30. /
        /* second line of address */
        @1   newcity     $28.
        /* customer city */
        @30  newstate    $2.
        /* customer state */
        @33  newzip      $10.; 
        /* customer zip code */
  datalines;
178-42-6534              1111 PAUL PLACE
RAPIDAN       VA 22215-5600
156-45-5672              2222 OSCAR DR.
ORANGE        VA 26042-1650
;


VER6.SSNUMS Data Set

The SAS data set VER6.SSNUMS is in Version 6 format and is used to update the ACCTDBD database.

data ver6.ssnums;
  input @1  ssnumb $11.
        @13 name   $40.;
  datalines;
267-83-2241 GORDIEVSKY, OLEG
276-44-6885 MIFUNE, YUKIO
352-44-2151 SHIEKELESLAM, SHALA
436-46-1931 NISHIMATSU-LYNCH, CAROL
;

proc print data=mydata.ssnums;
  title2 'SAS Data Set VER6.SSNUMS';
run;

space
Previous Page | Next Page | Top of Page