Thanks Kurt   Yes my SAS runs on a remote server. The approach you referred to (create a file directly in code, you may need to download it to your desktop with the Copy Files task) worked.    For reference the steps to follow can be found here https://blogs.sas.com/content/sasdummy/2013/05/20/export-and-download-any-file-from-sas-enterprise-guide/ ... View more

SASKiwi,  Once it has been sent to Excel It is too late to convert it back to text. For example 4526241E1 becomes 4.53E+07 when it gets sent to Excel. 'Text to columns' changes it to 45262410, not 4526241E1.  ... View more

Thanks Kurt,   I agree that the automatic conversion is probably happening during the read into Excel. Is there a way of saving the textfile that is sent from SAS? If so I could manually read that textfile into Excel and specify that the field is text.   Just to be clear, I am creating a dataset from the Query Builder. Then from the 'Results' tab I select 'Send To', "Microsoft Excel'. There is no option that i can see to 'Send To' a textfile.    ... View more