home *** CD-ROM | disk | FTP | other *** search
- Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
- Path: sparky!uunet!paladin.american.edu!auvm!TWNMOE10.BITNET!DAISY
- Message-ID: <SAS-L%92072403083031@UGA.CC.UGA.EDU>
- Newsgroups: bit.listserv.sas-l
- Date: Fri, 24 Jul 1992 14:23:00 EST
- Reply-To: Daisy Hsu <DAISY@TWNMOE10.BITNET>
- Sender: "SAS(r) Discussion" <SAS-L@UGA.BITNET>
- From: Daisy Hsu <DAISY@TWNMOE10.BITNET>
- Subject: about varity datasets merge
- Lines: 43
-
- Hi folks:
- There is a question bothered me for a while. The following is the
- problem:
- There are three datasets with different type.
- First: Lrecl = 40
- date (4.) fid ($7.) dummy (16.) itm (5.) qty (8.)
- 0101 a100001 123986.... 45422 34400
- 0101 a100001 . 45666 23455
- . . . . .
- . . . . .
- 0131 a100001 . 00123 123234
- 0101 a100002 . 12993 123300
- . . . . .
- . . . . .
-
- Second: Lrecl = 110
- date fid itm1 qty1 itm2 qty2 ... itm8 qty8 check
- *
-
- * the check # is the symbol of how many records belongs to
- the same fid on the same date.
-
- Third: Lrecl = 341
- fid date dummy (19.) account (2.) qty1 itm1 ... qty24 itm24
- * * *
- * account is the symbol of the qty# and itm#.
- eg: account = 12 implied from qty1 itm1 to qty12 itm12
-
- finally I want to manage the dataset as:
- Lrecl = 80
- fid date blank (67) cd (2)
- fid date itm1 (5) qty1 (8) ... itm5 qty5 blank (2) cd (2)
- *
- * take the card # appart.
- eg: cd = 1 is the card included fid date
- cd = 2 or 3 or ... is the sequence # of the contant
- fid itm qty
- if the qty# & itm# over 5 on the same date in the same fid
- then cd will be add 1.
-
- Any advice is appreciated. Welcome your anser.
- Daisy Hsu
- Bitnet : Daisy@twnmoe10
-