03-17-2012 01:38 PM
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?
03-17-2012 06:15 PM
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.
03-18-2012 08:59 AM
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.
03-19-2012 09:22 AM
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?
03-19-2012 09:45 AM
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)?
03-19-2012 12:55 PM
I imported the excel file to sas and now i have a sas dataset.
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..