Date: Wed, 7 Mar 2007 09:24:24 +1030
Reply-To: art297@NETSCAPE.NET
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Arthur Tabachneck <art297@NETSCAPE.NET>
Subject: Re: reading merged cells from EXCEL
Content-Type: multipart/mixed;
Don,
The list doesn't accept attachments, but it did come through in the cc you
sent.
For anyone else who didn't understand, Don's question was how to get SAS
to assign non-missing values to cells that had been merged in excel.
Thus, if col1,row1 and col1,row2 were merged in Excel to represent just
one cell (say, with the value 1), SAS import would read that as
col1,row1=1 and col1,row2=. . Don was asking, basically, how to get SAS
to make both of those values to equal 1.
I think the following does what you want:
PROC IMPORT OUT= WORK.have
DATAFILE= "s:\example.xls"
DBMS=EXCEL2000 REPLACE;
GETNAMES=NO;
RUN;
data want (drop=hold: i);
set have;
array have f1-f6;
array hold(6);
retain hold1-hold6;
do i=1 to 6;
if have(i) eq . then have(i)=hold(i);
else hold(i)=have(i);
end;
run;
Art
---------
On Tue, 6 Mar 2007 15:08:30 -0500, Kline, Donald
<Donald.Kline@COVANCE.COM> wrote:
>Art,
>
>Sorry, here is an example:
>
>Excel worksheet with merged cells (each empty cell is merged with and has
>the same value as the non-missing one above it):-
>
>a b c d e f
>1 1 1 1 1 1
>1 2 2
>1 3 2 3 2
>1 4 4 3
>1 5 5
>
>
>Desired SAS observations:
>
>a b c d e f
>1 1 1 1 1 1
>1 1 2 1 2 1
>1 1 3 2 3 2
>1 1 4 2 4 3
>1 1 5 2 5 3
>
>The attached spreadsheet may help.
>
>Thanks,
>
>Don
>
>__________________________
>Donald R. Kline, MSCS
>Principal Technical Programmer
>Periapproval Services
>
> Telephone #: 610-832-3926
> Address: Covance Inc.
> ATTN: Donald R. Kline
> 555 North Lane
> Suite 6000
> Conshohocken, PA 19428
>
>Signature CLIENTSERVICE
>Think service. Deliver excellence.
>
>
>-----Original Message-----
>From: Arthur Tabachneck [mailto:art297@NETSCAPE.NET]
>Sent: Tuesday, March 06, 2007 2:43 PM
>To: SAS-L@LISTSERV.UGA.EDU; Kline, Donald
>Subject: Re: reading merged cells from EXCEL
>
>
>Don,
>
>It may just be me, but I don't understand what you are asking. Possibly
>an example would help.
>
>Art
>--------
>On Tue, 6 Mar 2007 14:35:30 -0500, Don Kline <donald.kline@COVANCE.COM>
>wrote:
>
>>Hi,
>>
>>I would like to input merged cells such that the data appears in all of
>>the merged cells not just the first one. Am using WinXP and SAS 8.2 &
>>9.1.3 with ACCESS OLEDB and PC File Formats. Can this be done?
>>
>>Thanks,
>>
>>Don
>
>
>
>
>-----------------------------------------------------
>Confidentiality Notice: This e-mail transmission
>may contain confidential or legally privileged
>information that is intended only for the individual
>or entity named in the e-mail address. If you are not
>the intended recipient, you are hereby notified that
>any disclosure, copying, distribution, or reliance
>upon the contents of this e-mail is strictly prohibited.
>
>If you have received this e-mail transmission in error,
>please reply to the sender, so that we can arrange
>for proper delivery, and then please delete the message
>from your inbox. Thank you.
>
>begin 600 example.xls
>MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````!
>M````&@``````````$```'`````$```#^____`````!L```#_____________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M______________________\)"!````8%`-X>S0?!@```!@(``.$``@"P!,$`
>M`@```.(```!<`'``"0``1&]N($ML:6YE("`@("`@("`@("`@("`@("`@("`@
>M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
>M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@($(``@"P!&$!`@``
>M`,`!```]`0(``0"<``(`#@`9``(````2``(````3``(```"O`0(```"\`0(`
>M```]`!(```!X`%M*]"DX```````!`%@"0``"````C0`"````(@`"````#@`"
>M``$`MP$"````V@`"````,0`:`,@```#_?Y`!````````!0%!`'(`:0!A`&P`
>M,0`:`,@```#_?Y`!````````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y`!````
>M````!0%!`'(`:0!A`&P`,0`:`,@```#_?Y`!````````!0%!`'(`:0!A`&P`
>M,0`:`*````#_?Y`!````````!0%!`'(`:0!A`&P`'@0<``4`%P``(B0B(RPC
>M(S!?*3M<*"(D(B,L(R,P7"D>!"$`!@`<```B)"(C+",C,%\I.UM2961=7"@B
>M)"(C+",C,%PI'@0B``<`'0``(B0B(RPC(S`N,#!?*3M<*"(D(B,L(R,P+C`P
>M7"D>!"<`"``B```B)"(C+",C,"XP,%\I.UM2961=7"@B)"(C+",C,"XP,%PI
>M'@0W`"H`,@``7R@B)"(J(",L(R,P7RD[7R@B)"(J(%PH(RPC(S!<*3M?*"(D
>M(BH@(BTB7RD[7RA`7RD>!"X`*0`I``!?*"H@(RPC(S!?*3M?*"H@7"@C+",C
>M,%PI.U\H*B`B+2)?*3M?*$!?*1X$/P`L`#H``%\H(B0B*B`C+",C,"XP,%\I
>M.U\H(B0B*B!<*",L(R,P+C`P7"D[7R@B)"(J("(M(C\_7RD[7RA`7RD>!#8`
>M*P`Q``!?*"H@(RPC(S`N,#!?*3M?*"H@7"@C+",C,"XP,%PI.U\H*B`B+2(_
>M/U\I.U\H0%\IX``4``````#U_R```````````````,`@X``4``$```#U_R``
>M`/0``````````,`@X``4``$```#U_R```/0``````````,`@X``4``(```#U
>M_R```/0``````````,`@X``4``(```#U_R```/0``````````,`@X``4````
>M``#U_R```/0``````````,`@X``4``````#U_R```/0``````````,`@X``4
>M``````#U_R```/0``````````,`@X``4``````#U_R```/0``````````,`@
>MX``4``````#U_R```/0``````````,`@X``4``````#U_R```/0`````````
>M`,`@X``4``````#U_R```/0``````````,`@X``4``````#U_R```/0`````
>M`````,`@X``4``````#U_R```/0``````````,`@X``4``````#U_R```/0`
>M`````````,`@X``4```````!`"```````````````,`@X``4``$`*P#U_R``
>M`/@``````````,`@X``4``$`*0#U_R```/@``````````,`@X``4``$`+`#U
>M_R```/@``````````,`@X``4``$`*@#U_R```/@``````````,`@X``4``$`
>M"0#U_R```/@``````````,`@X``4```````!`"(``!```````````,`@X``4
>M```````!`!(``!```````````,`@DP($`!"``_^3`@0`$8`&_Y,"!``2@`3_
>MDP($`!.`!_^3`@0``(``_Y,"!``4@`7_8`$"````A0`.`+P%``````8`4VAE
>M970QC``$``$``0#!`0@`P0$``%2-`0#\``@```````````#_``(`"``*````
>M"0@0```&$`#>'LT'P8````8"```+`A0````````````%````>`8``$((```-
>M``(``0`,``(`9``/``(``0`1``(````0``@`_*GQTDUB4#]?``(``0`J``(`
>M```K``(```""``(``0"```@````````````E`@0```#_`($``@#!!!0````5
>M````@P`"````A``"````H0`B````_P`!``$``0`$``````````````#@/P``
>M`````.`_``!5``(`"`!]``P``````20)%0````0```(.```````%```````&
>M````"`(0```````&`/\````````!#P`(`A```0````8`_P````````$/``@"
>M$``"````!@#_`````````0\`"`(0``,````&`/\````````!#P`(`A``!```
>M``8`_P````````$/`+T`*@``````%0```/`_%@```/`_%0```/`_%@```/`_
>M%0```/`_%@```/`_!0!^`@H``0```!4```#P/P$"!@`!``$`%@!^`@H``0`"
>M`!4`````0`$"!@`!``,`%@!^`@H``0`$`!4`````0`$"!@`!``4`%@!^`@H`
>M`@```!4```#P/P$"!@`"``$`%@"]`!X``@`"`!4````(0!8`````0!4````(
>M0!4`````0`4`?@(*``,````5````\#\!`@8``P`!`!8`?@(*``,``@`5````
>M$$`!`@8``P`#`!8`O0`2``,`!``5````$$`6````"$`%`'X""@`$````%0``
>M`/`_`0(&``0``0`6`'X""@`$``(`%0```!1``0(&``0``P`6`'X""@`$``0`
>M%0```!1``0(&``0`!0`6`-<`#@"B`0``4``N`$@`.@!&`#X"$@"V!@````!`
>M```````````````=``\``PX`!0````$`#@`.``4%Y0`J``4````$``$``0``
>M``$``P`#``(`!``#``,````!``4`!0`#``0`!0`%`.\`!@`%`#<````*````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````_O\```4!`@```````````````````````0``
>M`."%G_+Y3V@0JY$(`"LGL]DP````J`````<````!````0`````0```!(````
>M"````%P````2````<`````P```"(````#0```)0````3````H`````(```#D
>M!```'@````H```!$;VX@2VQI;F4`(``>````"@```$1O;B!+;&EN90`@`!X`
>M```0````36EC<F]S;V9T($5X8V5L`$````"`ZY;4)V#'`4````"`8:%'*F#'
>M`0,`````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M`````````````````````````/[_```%`0(```````````````````````$`
>M```"U<W5G"X;$).7"``K+/FN,````-`````)`````0```%`````/````6```
>M`!<```!P````"P```'@````0````@````!,```"(````%@```)`````-````
>MF`````P```"K`````@```.0$```>````#0```$-O=F%N8V4@26YC+@``5V\#
>M````>Q`*``L`````````"P`````````+``````````L`````````'A````$`
>M```'````4VAE970Q``P0```"````'@````L```!7;W)K<VAE971S``,````!
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M```````````````````````````!`````@````,````$````!0````8````'
>M````_O___PD````*````"P````P````-````#@````\```#^____$0```!(`
>M```3````%````!4````6````%P```/[____]_____O__________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M_________________________________________________U(`;P!O`'0`
>M(`!%`&X`=`!R`'D`````````````````````````````````````````````
>M```````````````6``4!__________\"````(`@"``````#`````````1@``
>M````````````````````````_O___P``````````5P!O`'(`:P!B`&\`;P!K
>M````````````````````````````````````````````````````````````
>M`````!(``@'_______________\`````````````````````````````````
>M`````````````````````!`````````%`%,`=0!M`&T`80!R`'D`20!N`&8`
>M;P!R`&T`80!T`&D`;P!N````````````````````````````````````*``"
>M`0$````#````_____P``````````````````````````````````````````
>M``````@`````$`````````4`1`!O`&,`=0!M`&4`;@!T`%,`=0!M`&T`80!R
>M`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N```````````````X``(!________
>M________````````````````````````````````````````````````$```
>M```0````````4@!O`&\`=``@`$4`;@!T`'(`>0``````````````````````
>M`````````````````````````````````````!8`!0'__________P(````@
>M"`(``````,````````!&````````````````<$J@'BM@QP$=``````,`````
>M``!7`&\`<@!K`&(`;P!O`&L`````````````````````````````````````
>M````````````````````````````$@`"`?_______________P``````````
>M````````````````````````````````````````````$`````````4`4P!U
>M`&T`;0!A`'(`>0!)`&X`9@!O`'(`;0!A`'0`:0!O`&X`````````````````
>M```````````````````H``(!`0````,```#_____````````````````````
>M````````````````````````````"``````0````````!0!$`&\`8P!U`&T`
>M90!N`'0`4P!U`&T`;0!A`'(`>0!)`&X`9@!O`'(`;0!A`'0`:0!O`&X`````
>M`````````#@``@'_______________\`````````````````````````````
>M````````````````````````R`(````````!`````@````,````$````!0``
>M``8````'````_O___PD````*````"P````P````-````#@````\```#^____
>M______________________________________________________[____]
>M_____O___QX```#^____________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M_________________________________________________________P$`
>M```"`````P````0````%````!@````<````(````"0````H````+````_O__
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M____________________________________________________________
>M_____________________O\```4!`@```````````````````````@````+5
>MS=6<+AL0DY<(`"LL^:Y$````!=7-U9PN&Q"3EP@`*RSYKA0!``#0````"0``
>M``$```!0````#P```%@````7````<`````L```!X````$````(`````3````
>MB````!8```"0````#0```)@````,````JP````(```#D!```'@````T```!#
>M;W9A;F-E($EN8RX``%=O`P```'L0"@`+``````````L`````````"P``````
>M```+`````````!X0```!````!P```%-H965T,0`,$````@```!X````+````
>M5V]R:W-H965T<P`#`````0``````M`$```<`````````0`````$```#T````
>M````@/P````"````!`$```,````,`0``!````%0!```%````D`$```0````"
>M````%````%\`00!D`$@`;P!C`%(`90!V`&D`90!W`$,`>0!C`&P`90!)`$0`
>M```#````#@```%\`10!M`&$`:0!L`%,`=0!B`&H`90!C`'0````$````#0``
>M`%\`00!U`'0`:`!O`'(`10!M`&$`:0!L```````%````&````%\`00!U`'0`
>M:`!O`'(`10!M`&$`:0!L`$0`:0!S`'``;`!A`'D`3@!A`&T`90````(```"P
>M!```$P````D$```#````^SD/FA\````@````<@!E`&$`9`!I`&X`9P`@`&T`
>M90!R`&<`90!D`"``8P!E`&P`;`!S`"``9@!R`&\`;0`@`$4`6`!#`$4`3```
>M`!\````9````1`!O`&X`80!L`&0`+@!+`&P`:0!N`&4`0`!#`&\`=@!A`&X`
>M8P!E`"X`8P!O`&T``````!\````.````2P!L`&D`;@!E`"P`(`!$`&\`;@!A
>M`&P`9```````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>M````````````````````````````````````````````````````````````
>$``````==
>`
>end
AdmID:B318E72471DDD14BEA764C87DDD330BC
| 
