LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments: cc: Aldi Kraja <aldi@wustl.edu>, Rosa Lin <rosa@dsgmail.wustl.edu>
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./*


Back to: Top of message | Previous page | Main SAS-L page