10-12-2010 06:51 AM
10-12-2010 07:25 AM
10-12-2010 07:58 AM
10-13-2010 04:08 AM
02-21-2011 08:45 AM
09-26-2013 09:59 AM
your code looks great but í've got a small problem running it (since i am an absolute beginner in sas, i dont really fully understand your code as to say where my problem is). i have a file with 10 test data tables and there is only one table in each of them, containing the variables a b c d...n and each variable has 30 random values. I suppose RANGE gives the area where the data should be read, so i adjusted my code to 'RANGE="table1$A1:N30"' otherweise i didnt change any part of the code. and then i ran it and got the following warning message:
WARNING: Variable a was not found on BASE file. The variable will not be added to the BASE file.
and this for every variable a to n. As a result contains work.tt no columns.
why did this happen and how should i adjust my code so it works?
Many thanks again!
10-24-2013 10:09 AM
i used your code on another file. the excelsheets that i want to read into SAS have about 5000 variables and each of them have only 1 Observation. You code worked great but only 255 Variables were read into SAS, and each of them had then 8 observations (only the first one was originally in my excelsheets and the other 7 are just empty ones). why did this happen? how can i correct it so that all the variables could be correclty read into SAS?
thanks again for your super help!!
10-24-2013 10:21 AM
ok. found the problem. SAS can only import and export 255 variable when you access excel 2007 files. is it possible that i modify the code, so that SAS read 255 variables in once at a time and then merge them all together in the end?
Many thanks. BR Dingdang
10-24-2013 10:39 AM
10-12-2010 08:41 AM
02-17-2011 01:07 PM
02-17-2011 03:52 PM