Since SAS9.3 there is an AUTOMAP= option for the XMLV2 libname engine. This will create the map file automatically for you. See more details here SAS(R) 9.3 XML LIBNAME Engine: User's Guide, Second Edition the below sample code was taken from the doc: filename myxml 'C:\temp\xmlexample.xml'; filename mymap 'C:\temp\xmlexample_generate.map'; libname myxml xmlv2 automap=replace xmlmap=mymap; proc contents data=myxml._all_; run; Please be aware that this might create quite a number of datasets depending on the nesting levels of you XML, yours has quite some nesting. These data sets then need to be joined together. Since the XMLMAP= file is only a text file, in can be easily created using a DATA Step like the one below: filename mymap temp; data _null_;   infile cards;   input;   file mymap;   put _infile_; cards4; <?xml version="1.0" encoding="UTF-8"?> <SXLEMAP version="2.1">     <!-- ############################################################ -->     <TABLE description="CLASS" name="CLASS">         <TABLE-PATH syntax="XPath">/TABLE/CLASS</TABLE-PATH>         <COLUMN name="Name">             <PATH syntax="XPath">/TABLE/CLASS/Name</PATH>             <TYPE>character</TYPE>             <DATATYPE>string</DATATYPE>             <LENGTH>7</LENGTH>         </COLUMN>         <COLUMN name="Sex">             <PATH syntax="XPath">/TABLE/CLASS/Sex</PATH>             <TYPE>character</TYPE>             <DATATYPE>string</DATATYPE>             <LENGTH>1</LENGTH>         </COLUMN>     </TABLE> </SXLEMAP> ;;;; libname myxml xmlv2 "c:\temp\myclass.xml" xmlmap=mymap; proc copy in=myxml out=work; run; libname myxml clear; ... View more

SAS Enterprise Guide displays the log of a SAS program. However maybe somewhere within the code the echoing of the source code has been switched off. Have a look at the following sample code, it shows how to switch off the echoing of the source code to the log. All you will get is the message about converting numeric to character but no source code. options   nosource ; data test;   set sashelp.class;   length newVar $ 24;   if sex = "M" then do;     newVar = name !! age !! sex;   end;   else do;     newVar = name !! sex;   end; run; ... View more

What do you want to achieve with calling a STP from another STP? This is not a common use case for a STP What should the called STP return? If you want to encapsulate functionality one often uses macro programs to do this. A STP can be called as a web service. You can use Proc SOAP to call a web service. But I guess there is a simpler way to do what you want ... View more

Please show what your text column looks like. A test using EG6.1 (I know not your version) shows the following: This data set Is exported as: newColumn,Name,Age "Alfred,M,14",Alfred,14 "Alice,F,13",Alice,13 "Barbara,F,13",Barbara,13 "Carol,F,14",Carol,14 "Henry,M,14",Henry,14 Since the first column has the delimiter as part of the data, it is enclosed in double quotes, but the other columns that do not have delimiters are not put into quotes. Now I do not have EG4.3 available to test, please check your data for the delimiter (the comma) in your data ... View more

Hi tammy Since the annotate together with SGPANEL does not support a drawspace that supports "data", this is from the doc: Restriction For the SGPANEL and SGSCATTER procedures, only GRAPHPERCENT, GRAPHPIXEL, LAYOUTPERCENT, and LAYOUTPIXEL values are valid. You have to go another way, in a recent blog entry by outlined a technique with HIGHLOW and SCATTER plot to do something similar to what you want.Building on that, here is a code sample for the graph you want to do, it does some data preparation so that the HIGHLOW and SCATTER plots can be used. I guess there are other solutions as well data work.tam;   infile datalines dlm=',';   input Risk $ Numerator Service RptDate $;   key = catx("_", service, RptDate, risk );   datalines; A,5,1,Begin A,8,1,End B,3,1,Begin B,9,1,End C,1,1,Begin C,4,1,End A,2,2,Begin A,6,2,End B,4,2,Begin B,1,2,End C,6,2,Begin C,3,2,End ; proc sort data=work.tam;   by key; run; data tam2;   set tam;   by service  rptdate  NOTSORTED;   length numLow numHigh 8;   retain  numHigh;   if first.service = 1 or first.rptdate = 1 then do;     numlow = 0;     numHigh = numerator;   end;   else do;     numlow = numHigh;     numHigh = numLow + numerator;   end;   labelpos = numLow + (range(numLow, numHigh) / 2);   labelValue = range(numLow, numHigh); run; proc sgpanel data=work.tam2;   panelby service /     layout=columnlattice onepanel noborder colheaderpos=bottom novarname   ;   highlow x=RptDate low=numlow high=numhigh /     group=Risk type=bar name="hl"   ;   scatter x=rptDate y=labelpos /     datalabel=labelValue     datalabelpos=center     markerattrs=(size=0)     labelStrip     name="sc"   ;   keylegend "hl" / position=right; run; ... View more

With SAS9,4 there is a BASECHAR function. Although it does not help much it is good to know that with SAS9.4 this gets a lot easier ... View more

Check out this code, for me it seems to work with no problem, I use SAS9.4. I also added an example using SGPLOT data have;   length midpoints $ 32;   do midpoints = 'Placebo', '50 µg', '100 µg', '250 µg';     value = ceil( ranuni(0) * 10);     output;   end; run; Legend1 value=(color=blue height=1 /*'Placebo' '50 µg' '100 µg' '250 µg'*/ ); proc gchart data=have;   vbar midpoints / subgroup=midpoints sumvar=value legend=legend1; run; quit; proc sgplot data=have;   vbar midpoints / group=midpoints response=value; run; ... View more

It has to do whether you have "collect runtime statistics" set to on or off. Also be aware, that by default the code for deployed jobs does not have the code to collect runtime statistics. Check Tools > Options -> General there is a checkbox "Override and disable performance statistics when a job is deployed" Bruno ... View more

With both GPLOT and SGPLOT you can group your data, see sample below: proc gplot data=sashelp.class;   plot age*height = sex ; run; quit; proc sgplot data=sashelp.class;   series x=age y=height / group=sex ; run; ... View more