Hi, I have a stored process which works fine when I use ODS and output to a .xls file. But I also wanted to provide a preview of the data on the script so I just did a PROC PRINT like I do normally but I get the following error when I have to set the output properties in the STP. It works ok outputting to the web page or .xls but not both in the same STP? MPRINT(TEST): ods html file="e:\My.xls"; NOTE: Writing HTML Body file: e:\My.xls ERROR: A component of C:\DOCUME~1\sassrv\LOCALS~1\Temp\SAS Temporary Files\_TD3088\Prc70\45c2a8d7-4bb6-46ee-bb01-caef2047cc28\e:\My.xls is not a directory. WARNING: No body file. HTML output will not be created. MPRINT(TEST): proc print data = test.test_print; MPRINT(TEST): var F1 F2 F3 F4 F5 F6; MPRINT(TEST): run; WARNING: No output destinations active. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds Thanks Lee Message was edited by: Lee2010 ... View more

Hi, I am at a loss as to why my macro variable DATA_FOLDER does not work with my proc import. I have tried various combinations using a " and a ' defining the variable and in the proc import but any combination I seem to use does not work. Here I am using single quotes defining the macro variable and no quotes around the usage of the variable. 6721 %macro test; 6722 %let data_folder = 'c:\'; 6723 libname test &data_folder.; 6724 proc import 6725 datafile = &data_folder.'test.xls' 6726 out = test.test1 dbms=excel replace; 6727 run; 6728 %mend test; 6729 %test; MPRINT(TEST): libname test 'c:\'; NOTE: Libname TEST refers to the same physical library as ACR. NOTE: Libref TEST was successfully assigned as follows: Engine: V9 Physical Name: c:\ MPRINT(TEST): proc import datafile = 'c:\''test.xls' out = test.test1 dbms=excel replace; MPRINT(TEST): AEXC; MPRINT(TEST): run; ERROR: Unable to import, file c:\'test.xls does not exist. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.04 seconds cpu time 0.03 seconds ... View more

Hi, I don't mind if the solution is in PROC SQL or datastep but I am struggling with how to do this:- a=tablea b=tableb update tablea set a.col1 = b.col1 where a.col2 = b.col2 Regards Lee Message was edited by: Lee2010 ... View more

I am constructing a little dataset based on some variables using SQL but I am having a problem with inserting the data with the contents of a variable. This is what I have Test dataset created... %let testvar=XYZ; PROC SQL; insert into test; values ('test field text &testvar. '); quit; This .sas file is not a macro? Does it have to be to translate the contents of the variable as it does not at the moment? Thanks Lee Message was edited by: Lee2010 ... View more

I would like to create sub-totals in excel from my data set. In my original dataset my data is like this where col3 is a sum of col2 by col1 col1 col2 col3 AAA 1 4 AAA 1 4 AAA 2 4 BBB 1 5 BBB 3 5 BBB 1 5 I would like this data to appear in my excel spreadsheet like this AAA 1 AAA 1 AAA 2 -- 4 BBB 1 BBB 3 BBB 1 -- 5 ..but I am not sure if I need to do something with source dataset first or in excel after it has been imported? Thanks Lee Message was edited by: Lee2010 ... View more