09-08-2012 02:03 PM
hi..i want to update specific excel cells from sas using Proc sql..is it possible??
if yes, i need to update range of excel values using proc sql...i dont want to use SAS-DDE..means dont want to open excel file from sas..rather i just can connect to excel through proc sql...
finally am struggling to how to give range of excel cell in proc sql to so that i can put data in excel from sas..?ls
09-10-2012 01:11 AM
As above said.
Once you assign a libname to the excel file successfully, You can modify cell like a sas dataset.
libname x excel 'D:\x.xls' scantext=no;
where _col2='my condition';
09-10-2012 01:33 PM
Thanks a lot...
yes. its correct.
i got a way to write data to specific excel cells.But am getting variable names into the xl file those i dont want.
below is the code.
Here namedrng1 is the Named range in the excel file contains specific cells in a sheet.
Libname xl excel "Path";
here am getting columns names into xl file..is there any way to remove sas dataset's(work.emp) column names?
I can hide these columns in the excel file...BUT....still....????
09-10-2012 10:43 PM
If your excel file is in english, try to use XLS engine.
proc export data=sashelp.class outfile='c:\want.xls' replace dbms=xls;
09-11-2012 02:29 AM
Sorry Ksharp. if we use proc export we cant write data to required cell ranges in the excel...!! right??
is any further add-ons for my code which i mentioned above.i.e Libname and Proc SQL connect to excel, to eliminate column names while writing data into the cell ranges??
Thanks a lot.
09-11-2012 01:45 PM
But your code writes the data by checking condition with the excel cell values.
Actually, i want to write/export data which is coming from sas datasteps. so, i cant check the conditions with the values presented in the excel.
i.e its entirely new data for the new month which should be written to excel excel cell ranges.
The problem here is unwanted column ranges..But for time being i am hiding those columns in the template file.
Need further help from the community? Please ask a new question.