Hi, I used X statement to run a sh file in EG. This sh file uses for pulling data from datalake and save the data as several Excel files. When I use the putty to run the sh file, it takes around 15 mins to get all the Excel files. However, when I use the X statement, SAS only runs 1 second and stops when get one the Excel files. ( the one file only has file name, does not have any rows in it) . I want to get all the Excel files with complete data. How can I fix the issue?
... View more