I need some help regarding writing a file in XLS format or converting it from txt to xls format uing natural or JCL.
I am converting a SAS program which generate some report and FTP it to PC. I am using natural instead of SASand using the same FTP details.
Problem here is SAS has something called ‘ODS HTML’ thing which is used to wtire the data into xls format. Which means after FTP report is in xls format. But when using natural i could only write it into CSV format.
Does natural provide some similar function?
File from SAS
See attachment - Capture
File from natural
I am using 8.2.4 version of natural