Date: Thu, 19 Feb 2009 16:27:03 -0600
Reply-To: Jim Valentine <jimv@DSGMAIL.WUSTL.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jim Valentine <jimv@DSGMAIL.WUSTL.EDU>
Subject: Excel Output Junk
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Greetings,
I am submitting this ticket for a colleague.
She is using this function using SAS IntrNet to produce an csv/Excel
table. At the bottom of the table is junk code. How does she get rid of
that?
The code that generates the CSV file is
%ds2csv(data=metanalysis_chrom&number,runmode=s,csvfref=_webout);
Below are the lines appear at the bottom of the output CSV file.
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"> <html>
<head> <meta name="Generator" content="SAS Software Version 9.2
see www.sas.com">
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1"> <title>SAS Output Frame</title> </head>
<frameset cols="23% *">
<frame marginwidth="4" marginheight="0" frameborder="0"
src="/cgi-bin/broker?_service=default&_server=sasinet.dsg.wustl.edu&_port=5002&_sessionid=Y0kPCbp4L52&_program=replay&_entry=apswork.x0000011.C.HTML"
name="contents" scrolling="auto" title="The Table of Contents"> <frame
marginwidth="9" marginheight="0" frameborder="0"
src="/cgi-bin/broker?_service=default&_server=sasinet.dsg.wustl.edu&_port=5002&_sessionid=Y0kPCbp4L52&_program=replay&_entry=apswork.x0000011.B.HTML"
name="body" scrolling="auto" title="The SAS Output"> <noframes>
<body> <ul> <li><a
href="/cgi-bin/broker?_service=default&_server=sasinet.dsg.wustl.edu&_port=5002&_sessionid=Y0kPCbp4L52&_program=replay&_entry=apswork.x0000011.C.HTML">The
Table of Contents</a></li> <li><a
href="/cgi-bin/broker?_service=default&_server=sasinet.dsg.wustl.edu&_port=5002&_sessionid=Y0kPCbp4L52&_program=replay&_entry=apswork.x0000011.B.HTML">The
Contents</a></li> </ul> </body> </noframes> </frameset> </html>
Thanks,
Jim
Jim Valentine, Ph.D.
Senior Statistical Data Analyst
Division of Statistical Genomics
Washington University School of Medicine
4444 Forest Park Blvd., Campus Box 8506
St. Louis, Missouri 63110
Phone: 314.362.3688
Fax: 314.362.4227
http://dsgweb.wustl.edu/
https://dsgweb.wustl.edu/jimv/
*/The materials contained in this e-mail are private and confidential
and are the property of the sender. If you are not the intended
recipient, be advised that any unauthorized use, disclosure, copying,
distribution, or taking of any action in reliance on the contents of
this information is strictly prohibited. If you have received this
e-mail transmission in error, please immediately notify the sender./*