If the variables are actually "named" in Hebrew, then you will have to consider if SAS is able to handle DBCS at that level (syntax objects instead of just data) before renaming. I used the double quotes because in Excel these are not names, just data in the first row. You may be better off by - exporting excel content into csv - write a data step manually to import, starting in row 2. That way you discard the different names for identical columns BTW, did you try the double quotes? ... View more

Hi, thank you for help. but i put title after ods and then all titles change, also in the first page ... View more

You can make a shell/bat that starts only if the file is present, the shell/bat stert a SAS session and execute sas program that has for input the file. In other words: the customer load the file in the server, The proces start, do what have to do, send by mail the result, delete the input file ... View more

Here is someone you might want to contact: Michael T. Crotty (see: http://repository.lib.ncsu.edu/ir/bitstream/1840.16/3886/1/etd.pdf ) He is currently a SAS employee and that type of analysis was part of his doctoral dissertation. ... View more