Hello, all I have a table (which is on a db2 database) with several columns. One of the column is actually xml data type. I need to extract some value out of this xml data. I am trying to use proc sql to accomplish this job. However after I google online, it seems there is no such proc sql query for xml data. My question is: how to extract value from xml data? is proc sql capable of this? or is there any other tool in sas? Thanks. ... View more

Hello, I have a very long SAS macro (thousands of lines)to debug. For example ..... ..... ..... %let count =&sqlobs; ..... .... .... I would like to pause the program while it was running and see what is the value of count; I know  in other computer language there is usually such a debug facility to do this. Is there a similar tool in SAS? Or do I have to scroll down the log file (which could be tens of thousands of lines) to search for the value? Thanks. ... View more

hello, all I got following error message: ERROR: Freeing Memory Not Allocated  Pool [0000000009602A00] Value [000000000C71B3C0] WM Reb Pool:Kernel  . Traceback for Thread [00000000002651A0] WM Reb Pool:Kernel   0000000001E4AB00  000000000594F200  tkmk:tkBoot+0x9AE0 00000000034348FE  000000000594F230  sashost:Main+0x1B22E 000000000CA0B8B8  000000000594F2D0  sasioodb:tkvercn1+0x1A878 000000000A161096  000000000594F350  sasxdbi:tkvercn1+0x30056 000000000A141CA0  000000000594F3B0  sasxdbi:tkvercn1+0x10C60 0000000004ACB283  000000000594F3B8  sasyh:tkvercn1+0xA243 0000000004AC157D  000000000594F4D0  sasyh:tkvercn1+0x53D 00000000048A57C0  000000000594F4D8  sasxkern:tkvercn1+0x4780 000000000341E872  000000000594FAB0  sashost:Main+0x51A2 000000000341BBD3  000000000594FC50  sashost:Main+0x2503 000000000341C26B  000000000594FCB0  sashost:Main+0x2B9B 0000000003428B1B  000000000594FF20  sashost:Main+0xF44B 000000000342D13D  000000000594FF50  sashost:Main+0x13A6D 000000007741652D  000000000594FF80  kernel32:BaseThreadInitThunk+0xD 000000007764C541  000000000594FFD0  ntdll:RtlUserThreadStart+0x21 By the way, I got this error message NOT from sas log; rather the error message appear in a separate window. What is this error message about?  I googled and find following link ( support.sas.com/kb/31/007.html    ); but the instruction looks scary :--) Is there a simple way to fix such error? Thanks ... View more

Hello I use to define my own keys using method as described in here (SAS Key Definitions). It is actually pretty straightforward and works fine on my previous sas version. However, as I recently reinstall sas(9.3), I got following error message: ERROR: File I/O Error.  Unable to permanently save KEYS settings. ERROR: Cannot open entry DMKEYS.KEYS for write access - catalog SASUSER.PROFILE is opened for        read access. as a result, the defined keys will NOT be saved. I googled on the internet,;but there seems no related information. Can anyone help me to solve this problem? Thanks a lot. ... View more

Hello, All I have an empty dataset: data test; length var1 8 var2 $ 8 var3 8; label var1='label for variable 1'       var2='label for variable 2'       var3='label for variable 1'       ; stop; run; Now I want to export this empty dataset to excel, using the label as the first row in excel: proc export data=test                    outfile='c:\temp\test.xlsx'                   label                  dbms=excel replace; run; However I got following error message: ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: Field 'label for variable 1' already exists in table 'TEST'.. I actually found this post ;  but it does not seem to work for exporting an empty dataset. Is there a way to make such export possible? Thanks. ... View more

Dear All I am trying to open multiple SAS session at the same time; however I got following message each time when an additional SAS session is open: WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, WARNING: you will not see registry customizations during this session. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. NOTE: This SAS session is using a registry in WORK.  All changes will be lost at the end of this NOTE: session. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session In addition, the 'Getting Stated with SAS' dialog box also opens with each additional instance of SAS. I am trying to avoid the above warning message. I googled and found the following suggestion: Multiple SAS PC SAS Sessions on a Single Laptop? - comp.soft-sys.sas, which suggests add -rsasuser in SAS shortcut. I tried this method, but it does not seem to work. Can anyone suggest how to avoid those warning message? ... View more