Thought I should update this to point out that the AUTOMAP option has indeed been added to the SAS XML Libname engine. See SAS(R) 9.4 XML LIBNAME Engine: User's Guide While automapping make  pretty decent "best guess" at how the data should be structured, it may not always bring in data structured the way you like. ... View more

You can certainly bring Unix gzip'd file to the PC; both WinZip and 7Zip were designed to read them. You can also use command line processing in winzip and 7zip to read encrypted files on the PC. However, what I read from your initial post was an interest in using Unix-based SAS and scripts to read a file that had been compressed and encrypted on a PC; that is what I was expressing doubts about. ... View more

Thanks Tim, ... View more

Thanks Scott, you idea works. ... View more

Thanks much, This is what I am lookin for. ... View more

Thanks for all your sample codes. The issue solved. Regards David ... View more

Hi: What version of SAS are you running???? I haven't seen that "experimental" message for a while! To find our your version of SAS, put this at the end of your program: [pre] %put SAS Version is: sysvlong4; [/pre] I think that you really may need to work with Tech Support on this issue. TAGSETS.TABLEEDITOR works by a different method than ODS TAGSETS.EXCELXP. TABLEEDITOR creates an HTML file with embedded JavaScript that will load your HTML file in Excel once the HTML file loads into the browser. Sometimes you have to click a button to initiate the load, sometimes, depending on your options, the load into Excel is automatic. The way Excel treats long numbers is a known issue -- even if you send Excel a number as a character string, Excel uses the "general" format for the string -- which results in scientific notation. I believe that since TAGSETS.TABLEEDITOR uses HTML, that you cannot use TAGATTR to send a Microsoft format to Excel, but instead must use the HTMLSTYLE method with an mso-format, as described here: http://www2.sas.com/proceedings/forum2008/258-2008.pdf on page 29 cynthia ... View more

the reason for infinite looping was exactly as other people pointed out. if I understand you correctly, what you wanted is that, for any name (A) if the B value is 'Y' then output only once, otherwise output all records (i.e. B='N'). my approach is as follows and see if this works: proc sort data=test out=temp; by A descending B; run; data out1; set temp; by A descending B; if not first.B and B='Y' then delete; run; ... View more

Thanks very much for your recommendation. It works ! ... View more

Since saszipam is undocumented and unsupported, that may be hard. Using the documented approach with winzip, http://support.sas.com/kb/26/011.html you could specify the wzunzip option to list the contents rather than to transmit the contents of one specific file. ... View more

Hi: The appendix on reading MVS files -- in this paper about dealing with files on different operating systems -- may help: http://www2.sas.com/proceedings/sugi28/001-28.pdf Also, the SAS companion for MVS (z/OS) might help.Especially this section on reading the VTOC: VTOC Options for the INFILE Statement under z/OS http://support.sas.com/documentation/cdl/en/hosto390/59577/HTML/default/chifoptfmain.htm#mvs-stmt-vtoc cynthia ... View more

Hi Olivier, Thanks for your explanation. You code even resolved the issue as post 22 where some column headings has on numeric and SAS imposes the 'F' in front. I also want to THANKS everyone for their input to this thread that help me to resolve my problem. Regards Kwok ... View more

Thank you for your explanation. It works ! ... View more