Cynthia, Thank you for the reply. It seems that we can not get the pathname for specific opened .sas file. As a instead, I list all .sas files using the statement at below: proc sql; select distinct xpath from dictionary.extfiles as a where substr(fileref,1,3)='#LN' and directory='no' and a.exists='yes'; quit; - Kevin ... View more

You can use PROC OLAP to build cube and PROC INFORMAPS to build information map. However, PROC INFORMAPS is specific for SAS 9.2. For more information, please read 9.2 online doc. Actually, I suggest you should use SAS OLAP Cube Studio and SAS Information Map Studio. Message was edited by: Kevin Qin ... View more

I suggest that you should use Perl Regular Expressions. ... View more

Thank you for the answers. -Kevin ... View more

It is due to .NET framework update. After I uninstalled all .NET framework and then reinstall system requirement wizard, SUV works. 🙂 It seems that SUV can not work with .NET 3.5 ... View more

Actually, I do not know exactly what is your error: Here are sample code: data a; input department $ year teacher$; datalines; econ 2002 Samon econ 2003 Samon manag 2003 Stephen manag 2003 Sissi Chem 2002 Sissi Chem 2003 Samon Math 2003 Stephen Math 2004 Laura Eng 2002 Laura Eng 2003 Stephen ; run; Proc freq data=a; table teacher / out=freqteacher; table teacher*department /out=freqteacher_bydepart; table teacher*year /out=freqteacher_byyear; table teacher*department*year /out=freqteacher_bydepart_byyear; run; ... View more

Cynthia, Thank you for the try. I will ask Tech Support for more details. -Kevin ... View more

Cynthia, Thank you for the reminder. I am just want to get SAS format XML file for SAS Universal Viewer. Any idea? -Kevin ... View more

Hi sbb, Thank you for your input. Let's get back to start point. I want to view SAS dataset using SAS Universal Viewer. However, this tool does not support raw SAS format catalog. It seems that I have to convert the SAS format catalog to an XML file. I failed to perform the conversion using XML engine. I am wondering someone can provide an sample code to convert SAS format catalog to XML file, which will be used in SAS Unversal Viewer. Any help will be appreciated. -Kevin ... View more

Thank you for the input. I have read the SAS 9.2 XML LIBNAME Engine: User's Guide and find only 3 relative options: FORMATACTIVE, FORMATLIBRARY and FORMATNOREPLACE. However, I tried many times but failed to store format catalog in library with XML engine. * one sample code; filename output 'c:\output.xml'; libname output xml xmltype=CDISCODM formatactive=yes; proc format lib=output; value test 1='A'; run; ERROR message in log: ERROR: OUTPUT.FORMATS.CATALOG cannot be opened because files of type CATALOG are not supported in the OUTPUT library. Do you have any sample code to convert format catalog into XML file? -Kevin ... View more

Cynthia, Yeah, it works. Thank you. -Kevin ... View more