cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
alepage
2 weeks ago
  • 796 Posts
  • 177 Likes Given
  • 17 Solutions
  • 22 Likes Received

Re: how to create a table with proc sql and setting a variable to a de...

by Barite | Level 11 in SAS Enterprise Guide
‎08-09-2018 03:27 PM
‎08-09-2018 03:27 PM
Could you please provide me an example how set default value using SQL pass through facility? Thanks ... View more

how to create a table with proc sql and setting a variable to a defaul...

by Barite | Level 11 in SAS Enterprise Guide
‎08-09-2018 02:54 PM
‎08-09-2018 02:54 PM
Hello,   I am using SAS EG 7.11 and I would like to create a table  and setting some variables to a default value as below Except this code is not working.   Does someone has already work on that issue. Regards,     proc sql; create table table1 (field1 num, field2 num default 5557, field3 num default 1337,       field4 date default today()); quit;   ... View more

How to avoid the root element <ROWSET> in an xml file to be replace by...

by Barite | Level 11 in SAS Enterprise Guide
‎08-09-2018 10:03 AM
‎08-09-2018 10:03 AM
Hello,   I am converting a dataset into an XML file using EG 7.11.  I have noticed that even if I use xmltype=oracle, when I add a tagset conditions, it replace <ROWSET> for <TABLE>.   Here's my code.  In the first example, I don't use any tagset condition so the root element <ROWSET> remains in the xml file. However, when I add any tagset condition, the root element is replaced for <TABLE>.   How can we avoid that? Regards,     %let Path=\\...; libname trans xml "&Path.\Documents\Test\XML\class.xml" xmltype=oracle; data trans.class noprint;    set sashelp.class; run; libname trans xml "&Path.\Documents\Test\XML\class.xml" xmltype=oracle tagset=tagsets.sasxmnsp; data trans.class noprint;    set sashelp.class; run; ... View more

How to establish a SAS Metadata Bridge between SAS EG 7.1 and Sybase ...

by Barite | Level 11 in SAS Enterprise Guide
‎08-02-2018 02:38 PM
‎08-02-2018 02:38 PM
Hello,   Does someone has already establish a bridge between SAS EG 7..1 and Sybase Power design and if so could you provide a sample code.   Thanks   ... View more

Re: How to convert an XML file into a flat file using SAS EG 7.11 ?

by Barite | Level 11 in SAS Enterprise Guide
‎08-02-2018 09:46 AM
‎08-02-2018 09:46 AM
Hello Kurt,   I have completed my test and with your help, I was able to convert an XML file into a Delimiter Separator Value file (*.dsv) with the expected format.   Thanks for your help which is very appreciated.       ... View more

How to create a macro variable into a macro function containing specia...

by Barite | Level 11 in SAS Enterprise Guide
‎08-01-2018 07:59 PM
‎08-01-2018 07:59 PM
Hello,   I have tried the following code and it works. But when I put it in a macro function, it failed. The idea is to replace the " sign in the prolog from an xml file by %bquote(") to make sure that the macro variable has an acceptable structure.   %let prolog1=<?xml version="1.0" encoding="windows-1252" ?>; %let target='"'; %let replacement=%bquote("); %let prolog1=%sysfunc(tranwrd(%quote(&prolog1.),&target.,&replacement.)); %put &prolog1;         I would like to do the same thing but in a macro function such as:   %macro test; %global gtarget greplacment gprolog;   %let prolog1=<?xml version="1.0" encoding="windows-1252" ?>; %let target='"'; %let gtarget = &target.; %let replacement=%bquote("); %let greplacment= &replacement.; %let prolog1=%sysfunc(tranwrd(%quote(&prolog1.),&target.,&replacement.)); %let gprolog=&prolog1.;   %mend test; %test; %put &gprolog.; %put &greplacement.; %put &gtarget.; ... View more

Re: How to convert an XML file into a flat file using SAS EG 7.11 ?

by Barite | Level 11 in SAS Enterprise Guide
‎08-01-2018 02:18 PM
‎08-01-2018 02:18 PM
Hello Kurt,   I would like to catch the xml prolog into a macro variable (ex:<?xml version="1.0" encoding="WINDOWS-1252"?>).  There after, I need to modify the special characters in the macro variable then copy the prolog (macro variable) at each line (that the format require by the customer). It is why I am asking how to put the code into a macro function.   %let prolog1=<?xml version="1.0" encoding="windows-1252" ?>; %let target='"'; %let replacement=%bquote("); %let prolog1=%sysfunc(tranwrd(%quote(&prolog1.),&target.,&replacement.)); %put &prolog1;       ... View more

Re: How to convert an XML file into a flat file using SAS EG 7.11 ?

by Barite | Level 11 in SAS Enterprise Guide
‎08-01-2018 01:46 PM
‎08-01-2018 01:46 PM
Hello Kurtz,   I have test and modify your code to adjust it to my needs.  It works well.  Now if I want to use your code into a macro function to pass the File location path and the file name as well.  It doesn't seems to works.   I have put % sign to if then do else and index but I think I have difficulties with the expression: if not flag... How do we modify that for a macro function.   Thanks in advance for your help.   ... View more

Re: How to convert an XML file into a flat file using SAS EG 7.11 ?

by Barite | Level 11 in SAS Enterprise Guide
‎07-31-2018 09:56 AM
‎07-31-2018 09:56 AM
Hello Kurtz, Thanks a lot for your help.     ... View more

Re: How to convert an XML file into a flat file using SAS EG 7.11 ?

by Barite | Level 11 in SAS Enterprise Guide
‎07-30-2018 01:15 PM
‎07-30-2018 01:15 PM
Hello Kurt,   May be my question is not clear.  I apologize for that. If I look at the XML FILE and if I open it with notepad++, What I will see is:   <?xml version="1.0" encoding="windows-1252" ?> <ROWSET>  <ROW>   <Name> Alfred </Name>   <Sex> M </Sex>   <Age> 14 </Age>   <Height> 69 </Height>   <Weight> 112.5 </Weight>  </ROW>...   And what I would like to do is to put all the information for an observation on the same row like below:   <ROWSET><ROW><Name> Alfred </Name>...<Height> 69 </Height><Weight> 112.5 </Weight></ROW></ROWSET> ...next observations   ... View more

How to convert an XML file into a flat file using SAS EG 7.11 ?

by Barite | Level 11 in SAS Enterprise Guide
‎07-30-2018 11:29 AM
‎07-30-2018 11:29 AM
Hello,   The conversion a data set into an xml file is made using the following code (ex: sashelp.class).  But how do we convert this xml file into a flat file like the one after the sas code.   libname newfile xml "C:\Test\XML\testtoday.xml" xmltype=oracle; data newfile.testtoday; set sashelp.class; run;     "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Alfred </Name><Sex> M </Sex><Age> 14 </Age><Height> 69 </Height><Weight> 112.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Alice </Name><Sex> F </Sex><Age> 13 </Age><Height> 56.5 </Height><Weight> 84 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Barbara </Name><Sex> F </Sex><Age> 13 </Age><Height> 65.3 </Height><Weight> 98 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Carol </Name><Sex> F </Sex><Age> 14 </Age><Height> 62.8 </Height><Weight> 102.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Henry </Name><Sex> M </Sex><Age> 14 </Age><Height> 63.5 </Height><Weight> 102.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> James </Name><Sex> M </Sex><Age> 12 </Age><Height> 57.3 </Height><Weight> 83 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Jane </Name><Sex> F </Sex><Age> 12 </Age><Height> 59.8 </Height><Weight> 84.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Janet </Name><Sex> F </Sex><Age> 15 </Age><Height> 62.5 </Height><Weight> 112.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Jeffrey </Name><Sex> M </Sex><Age> 13 </Age><Height> 62.5 </Height><Weight> 84 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> John </Name><Sex> M </Sex><Age> 12 </Age><Height> 59 </Height><Weight> 99.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Joyce </Name><Sex> F </Sex><Age> 11 </Age><Height> 51.3 </Height><Weight> 50.5 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Judy </Name><Sex> F </Sex><Age> 14 </Age><Height> 64.3 </Height><Weight> 90 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Louise </Name><Sex> F </Sex><Age> 12 </Age><Height> 56.3 </Height><Weight> 77 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Mary </Name><Sex> F </Sex><Age> 15 </Age><Height> 66.5 </Height><Weight> 112 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Philip </Name><Sex> M </Sex><Age> 16 </Age><Height> 72 </Height><Weight> 150 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Robert </Name><Sex> M </Sex><Age> 12 </Age><Height> 64.8 </Height><Weight> 128 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Ronald </Name><Sex> M </Sex><Age> 15 </Age><Height> 67 </Height><Weight> 133 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> Thomas </Name><Sex> M </Sex><Age> 11 </Age><Height> 57.5 </Height><Weight> 85 </Weight></ROW>|</ROWSET> "<?xml version=""1.0"" encoding=""WINDOWS-1252""?><ROWSET>"|<ROW><Name> William </Name><Sex> M </Sex><Age> 15 </Age><Height> 66.5 </Height><Weight> 112 </Weight></ROW>|</ROWSET>     ... View more

Re: converting an Oracle table into a SAS data set while keeping the I...

by Barite | Level 11 in SAS Enterprise Guide
‎07-27-2018 11:29 AM
‎07-27-2018 11:29 AM
Hello everyone, after many tries I finally found a way to do it. Thank you for your comments. ... View more

Re: converting an Oracle table into a SAS data set while keeping the I...

by Barite | Level 11 in SAS Enterprise Guide
‎07-26-2018 10:01 AM
‎07-26-2018 10:01 AM
I understand perfectly what you mean.  However, I looking at all the available options to carry out my duties. regards, Alain ... View more

converting an Oracle table into a SAS data set while keeping the Integ...

by Barite | Level 11 in SAS Enterprise Guide
‎07-26-2018 09:19 AM
‎07-26-2018 09:19 AM
Hello,   I have developed with the help of peoples from the community, a SAS code to produce an Oracle table with all the comments and the integrity constraints as well.  When I use oracle and goes on the server, I can check that my Oracle table has the proper structure in terms of type of data, comments on columns and integrity constraints.   However, when the time comes to convert the Oracle table into a SAS Data set, the comments on columns are converted into variables labels which is fine but I am loosing the integrity constraints.   Has anyone ever managed to convert an Oracle table into a SAS data set while maintaining the integrity constraints?   I have tested those two methods and the integrity constraints are kept.     libname oralib oracle user=*** password=*** path=u.data; /*Listing of the table available in oralib*/ proc datasets lib=oralib; quit; /*Using SAS/ACCESS engine *********/ data work.test1; set oralib.D9_CADAS_CITYN_SRC; run; PROC CONTENTS DATA=TEST1; RUN; /*The PROC SQL Pass-Through Facility */ proc sql; connect to oracle ( user=*** orapw=*** path=u.data); create table Test2 as select * from connection to oracle ( select * from D9_CADAS_CITYN_SRC ); disconnect from oracle; quit; PROC CONTENTS DATA=TEST2; RUN; ... View more
Contact Me
Online Status
Offline
Date Last Visited
2 weeks ago
Likes given to
Likes from
Quick links