Hi, As far as I am aware there is no "pivot table" file format, but it is normally part of an Excel file.  With this in mind, I don't see any way to directly create this from SAS using tagsets etc. so you would need to investigate the Open XML document format used by latest incarnations of Excel, Overview of the XML file formats in Office 2010 You can pretty much build any type of Excel file directly as text files and zip them up.  Its really not straightforward though, took a fair time to get just a few values into a new file doing it this way when I tried as there are several files/folder with the xlsx (which is a zip - rename the extension .zip and you can open it). One way could be to create the pivot table as you would in Excel.  Then rename the to zip and open and see what xml files are generated.  From there work back to your SAS program. ... View more

Use the COPY statement in PROC DATASETS: http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000247654.htm ... View more

Hi:   First, it's not a good idea to add your question to a 9 month old post. It's better to start a new post and put a link to the post you are referenceing. I am teaching this week and don't have time to run the code extensively. I do not have a GRID/Linux installation to test with. If you are saying that you ran the EXACT code above on a different operating system and you do NOT get the results shown in the screen shot, then that is a question for Tech Support. When I run the EXACT code in SAS 9.4 in Enterprise Guide and in SAS on Windows, I get the EXACT same results. cynthia ... View more