最近在处理一份比较棘手的原始数据,数据类型如下:
Variable | Length |
UPC | 14 |
RVDESC | 40 |
AGGLONG1 | 40 |
AGGLONG2 | 40 |
AGGLONG3 | 40 |
AGGLONG4 | 40 |
AGGLONG5 | 40 |
DEPARTMENT | 1 |
VOLCON | 6.4 |
UNIT_MEASURE | 8 |
数据格式和内容如下(仅截取一部分):
10000280102| +PRV * ASST CPCK PSCLM 12OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | PRIVATE LABEL | PRIVATE LABEL | PRIVATE LABEL |1|0.7500|POUNDS |
10000282445| +PRV * CHOC BRNI PCR 6OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | PRIVATE LABEL | PRIVATE LABEL | PRIVATE LABEL |1|0.3750|POUNDS |
10004300835| +PRV * JLY SKC PW INDVL 2.7OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | PRIVATE LABEL | PRIVATE LABEL | PRIVATE LABEL |1|0.1688|POUNDS |
10243008379| +LTDEB PLN SKC PCR 2OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | MCKEE FOODS CORPORATION | MCKEE FOODS CORPORATION | LITTLE DEBBIE |1|0.1250|POUNDS |
10720300097| +ENTMN REG PNDCK PW 2.75OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | GRUPO BIMBO | BIMBO BAKERIES USA INC | ENTENMANNS |1|0.1719|POUNDS |
11011300101| +JMAIC REG CPCK TPLBG 10OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | J. M. CRUZ INC | J. M. CRUZ INC | JAMAICA |1|0.6250|POUNDS |
11011300175| +JMAIC REG MNTCD PW MINI 12OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | J. M. CRUZ INC | J. M. CRUZ INC | JAMAICA |1|0.7500|POUNDS |
11034899999| +BRDGH CRMB CPCK PCR 14OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | BATTERS & DOUGHS INC | BATTERS & DOUGHS INC | BATTERS & DOUGHS |1|0.8750|POUNDS |
11037436117| +TFTTB CHOC CKRLL PCR 3.6OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | THE FATHERS TABLE | THE FATHERS TABLE | THE FATHERS TABLE |1|0.2250|POUNDS |
11037436118| +TFTTB RDVLT CKRLL PCR 3.6OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | THE FATHERS TABLE | THE FATHERS TABLE | THE FATHERS TABLE |1|0.2250|POUNDS |
11099500125| +FREEB PLN CPCK PCR MINI 10OZ|CATEGORY - BAKERY SNACKS | CUPCAKES/BROWNIES | GEORGE WESTON LTD | MAPLEHURST BAKERIES LLC | FREEDS BAKERY |1|0.6250|POUNDS |
想请问坛子里的大牛:怎么写sas的语句才能去掉Rvdesc前的“+”和Agglong1,Agglong2,Agglong3, Agglong4, Agglong5前后的“|”,得到规范的表格呀?多谢多谢啊!