Hello,   Here's the code I am using...   data class; set sashelp.class; if name="Jane" then do; name=" Jane"; age = .;end; run; libname trans xml "\\...\Documents\Test\XML\test.xml" xmltype=oracle ; data trans.class noprint; set class; run; libname trans clear;   A part of my xml file looks like that:   <?xml version="1.0" encoding="windows-1252" ?> <ROWSET> . . . <ROW>       <Name> Jane</Name>       <Sex>F</Sex>       <Age missing="." />       <Height>59.8</Height>       <Weight>84.5</Weight>    </ROW>   What I would like to get for missing value is:   <ROW>       <Name> Jane</Name>       <Sex>F</Sex>       <Age></Age>       <Height>59.8</Height>       <Weight>84.5</Weight>    </ROW>   I have look through the information on the web and I know that the use of tagset=tagset.sasxmiss could do the job.  Does some one know another tagset who will do the task.     This procedure below give me the tagset available on my system:   proc template; list tagsets; run;       Obviously, the tagset.sasxmiss is not present.  Is it possible to download this sasxmiss tagset or to update my tagsets?   Regards, Where and how can I update my tagsets for SAS Enterprise Guide 7.11   ... View more

Hello,   I using a pass through connection to connect to an oracle Table as follow:   %macro CXNOracle(user=, password=, path=, schema=);   proc sql ; CONNECT to oracle as oradb (user=&user. password=&password. path=&path. ); create table &GFileName. as   SELECT * FROM connection to oradb (SELECT * FROM &schema..&GFileName.) ;   DISCONNECT from oradb; quit; run; %Mend CXNOracle;   %CXNOracle(user=*****, password=****, path=*****, schema=****);   As you can see, I input my user name, password, the place where is the oracle table then a schema. The FileName is defined as a global variable as GFileName.   I have let's six date variable with the datetime20 format.   The challenge is to convert all date variables from a datetime20 format to YYYYMMDD without naming the variable. Is there a way to set all date variables to a default format ex: YYYYMMDD?   Date variable as the following format = 31JAN1966:00:00:00   Thanks in advance for your help.       ... View more

Hello, My colleagues here use a standardized way to name external files.   Name of the provider of the file, '-', Name of the file. file extension. Ex: Hydro_One-Billing_Services.xml So Hydro_One is the source Billing_Services is the filename and .xml is the filename extension.   The complete (desired name) is Hydro_One-Billing_Services.xml   I tried to explain to them that SAS do not take a hyphen but they want to keep their way of doing things. Can we rename the file programmatically according to their standard?     ... View more

Hello,   I am using the code bellow to copy a template (zero observation data set) from Work to a server.  This operation works well but when I click on my template located on the server, I have this error message:   The opening of the data has failed. The following error occurred. BOF or EOF is equal to true. The current record has been deleted. The requested operation requires a current record.   Data test; stop; set sashelp.class; run;   Libname Template '\\...\Documents\My SAS Files\Template'; proc sql; create table Template.Test_Templ like work.Test; quit;   Any idea how to correct this problem? regards,   ... View more

Hello,   It seems possible to generate the DDL from a SAS table as follow:   proc sql; describe table sashelp.class; quit;   Then we go in the log file and we get this:   create table SASHELP.CLASS( label='Student Data' bufsize=65536 ) ( Name char(8), Sex char(1), Age num, Height num, Weight num ); quit;   Can I import the DDL into  SAS to generate the data set and if so, how can we do that? Regards         ... View more