topic import excel with three worksheets in SAS Procedures

import excel with three worksheets

shru — Sat, 17 Mar 2012 17:38:53 GMT

Hi,

I need to import the excel with three woroksheets and and in the inported worksheet i need to make one cell as dynamic so when i run the code daily automatically the cell for that day should be filled with data. and aslo,

I tried importing with proc import ,but i get a error telling file_imex_error.

so anyone help me in this please?

Thanks

import excel with three worksheets

PGStats — Sat, 17 Mar 2012 18:51:20 GMT

Do you wish to read cell values dynamically updated by Excel or to dynamically update Excel cells with SAS?

import excel with three worksheets

art297 — Sat, 17 Mar 2012 22:15:28 GMT

It would help if you had posted your log, but the error may simply be that you didn't specify the file and/or sheet names correctly. As for your other questions, like PGStats mentioned, the forum would need to know more about what you are trying to accomplish.

import excel with three worksheets

shru — Sun, 18 Mar 2012 12:55:59 GMT

I need to upadate excel cells by sas

import excel with three worksheets

shru — Sun, 18 Mar 2012 12:59:42 GMT

o, its like the excel format is different i guess,so when i try to import the excel with correct sheet name,its showing error as FILE_IMEX error.

I tried importing it using import wizard but still the same error exists,

I tried giving the rangein the proc import like

sheet="sheet1A1:A10$"n but its not working

It would be helpfull,if you guide me with some other way of giving sheet name.

Thanks

import excel with three worksheets

PGStats — Sun, 18 Mar 2012 15:41:30 GMT

Try this syntax:

libname xl excel "c:\yourpath\.yourFile.xlsx" getnames=no;

proc print data=xl."Sheet1$A1:A2"n; run;

libname xl clear;

import excel with three worksheets

shru — Mon, 19 Mar 2012 13:22:17 GMT

Hi,

I am able to import the excel sheet successfully.

But i need to read an one row number for example:-23 and assign it to one macro,so that when i run everyday it should update for the current day.

How can i achieve this?

Thanks

import excel with three worksheets

art297 — Mon, 19 Mar 2012 13:45:23 GMT

Back to the original questions: what do you have to read in (i.e., what field(s)/column(s)) and what do you have to update (i.e., a sas file or the spreadsheet)?

import excel with three worksheets

shru — Mon, 19 Mar 2012 16:55:20 GMT

I imported the excel file to sas and now i have a sas dataset.

example:

data today tom dayafter

d 1 2 3

e 4 7 9

Now i need to read the row 'd' and assign it to one macro so that when i run today it will upadate the row.

This updation i need to do in excel..

Thanks