dianalves Tracker

Re: How to export from SAS to Excel?

dianalves — Fri, 06 Sep 2013 09:45:43 GMT

I have ran this code but nothing, neither give error!I'm not ADMIN and perhaps I have troubles because of that. I'll try all option you gave me. Thank you a lot, I'll share all steps

Re: How to export from SAS to Excel?

dianalves — Thu, 05 Sep 2013 17:46:19 GMT

Hi Chris,

I have EG 1.4 and SAS 9.132.0.0

I tried this:

ODS TAGSETS.EXCELXP

file='D:\Documents and Settings\p057132\Desktop\regression.xls'

STYLE=minimal;

proc reg data = WORK.QUERY145;

model log_yt = log_yt_m1 log_yt_m2;

run;

quit;

ods tagsets.excelxp close;

quit;

ods tagsets.excelxp close;

It creates a file in SAS ( I just see it in Project Explorer), with "/SASSoft/MinerGuide/Lev1/SASMain/D:\Documents and Settings\p057132\Desktop\test.xml" extension. I can not open it.

ods csv body="D:\Documents and Settings\p057132\Desktop\regression.csv";

proc print data=WORK.QUERY145;

run;

ods csv close;

It creates a csv file in SAS like above and not works with xlm.

In reality I would like to export the database to specifique folder in SAS server but is has to be in xls or csv (rather).

How to export from SAS to Excel?

dianalves — Wed, 04 Sep 2013 13:30:03 GMT

Hello

I'm a new user of SAS Guide and need a little help.

My problem: I want to export a table from SAS to Excel with code. I have tried differente forms but nothing works. I read something about this in forum and someone said that is need a license to export, this is true?

I tried this forms:

proc export

data=work.impw

dbms=xls

outfile="D:\Documents and Settings\p057132\Desktop\back.xls"

replace;

run;

Here, nothing happens!

_____________//______________

ods Tagsets.ExcelXP file='D:\Documents and Settings\p057132\Desktop\test.xls';

title 'Listing of Class data';

proc print data=work.back;

run;

ods Tagsets.ExcelXP close;

Gives a strange output, I can't open it

_________________________-//___________________

I have tried other ones. I have a Enterprise Guide 4 version.

I hope you can help me.

Thank you,

Diana