最近在处理一份比较棘手的原始数据，数据类型如下：

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前后的“|”，得到规范的表格呀？多谢多谢啊！