The answer is already solved, just wanted to mention, that the date11 informat can read the dates that are shown.
See sample code below:
data have;
length dt $20;
dt="4-Aug-2016"; output;
dt="05-aug-2016"; output;
run;
data want;
set have;
d2 = input(dt, date11.);
format d2 date9.;
run;
... View more
As a start you could use the compress function, like below, this will remove all characters, except alphabetic, digits and punctuation anywhere in your email. Maybe one should also check what makes up a valid email address, see here https://en.wikipedia.org/wiki/Email_address
Maybe there are Regular expressions that check for valid email addresses as well. You could use those with the PRX... functions.
Also have a look at this discussion
https://communities.sas.com/t5/SAS-Procedures/validate-email-address/m-p/37459#U37459
data have;
length email newEmail $ 256;
email = cats("090a0d"x, "sugus-sugus_sugus.1234@sugus.com.edu", "01"x);
newEmail = compress(email, "" , "adpk");
putlog _all_;
run;
Bruno
... View more
You can make use of format that makes use of the nested format definition.
Here is a sample:
proc format;
value my_mmyys (default=7)
. = "99/9999"
other = [mmyys7.]
;
run;
data have;
do someDate = ., "01jan2016"d, "31aug2016"d;
someDate2 = someDate;
output;
end;
format
someDate mmyys7.
someDate2 my_mmyys.
;
run;
Bruno
... View more
One could use the same technique for hours as well, but I guess the formatting of the result will be difficult, since there is no numeric format that with ":" as separator
Bruno
... View more
Hi
yes a time value is a category value and therefor you can not do any aggregations.
I suggest to do the follwoing:
create a new calculated data item that represents the time as a numeric value using the TreatAs operator, something like:
TreatAs(_Number_, 'Time'n)
Then you create a new aggreated measure using this expression:
Floor(( Sum [_ByGroup_] ('timeSec'n) / 60 )) + ( ( Sum [_ByGroup_] ('timeSec'n) Mod 60 ) / 100 )
where 'timeSec'n is the calculated item from the first step
Essentialy you compute the minutes from you seconds and then use the Mod operator to add the remaining minutes (divided by 100) to the result. This will give you the proper result as mm.ss,, see also picture
Give it a try
Bruno
... View more
SAS will not make any syntax check on the groovy code. As mentioned earlier, I would check whether the class that is not found is in the jar file you mention
Bruno
... View more
SAS needs to find the jar file. So it has to be on the system where the SAS program runs. You need to specify the appropriate path.
You are talking about the "my folder", are you using the SAS University Edition?
Posting the log will help.
Bruno
... View more
Hi
Try with the complete pathname for the ADD CLASSPATH statement.
Something like:
add path="C:\Program Files\SASHome\SASVersionedJarRepository\eclipse\plugins\groovy_2.3.7.0_SAS_20151104171452\groovy-all.jar";
Bruno
... View more
Yes there is.
You will need to use GTL to do this.
For a start you can use your Proc SGPLOT code and add the TMPLOUT= option. This will write out the GTL code to a file.
proc sgplot data=sashelp.class tmplout="c:\temp\sgplot.sas";
waterfall category=age response=height ;
run;
Then adapt the code like below. Check the doc for the WATERFALLCHART statement it has the DISPLAY= option.
ods path
(prepend) work.mytemplates (update)
;
proc template;
define statgraph sgplot_waterfall;
begingraph / collation=binary;
layout overlay / yaxisopts=(labelFitPolicy=Split) y2axisopts=(labelFitPolicy=Split);
WaterfallChart Category=Age Response=Height /
primary=true LegendLabel="Height" NAME="WATERFALL"
display=(
FILL
/* FINALBAR displays the “final” bar */
OUTLINE
CONNECT
)
;
endlayout;
endgraph;
end;
run;
proc sgrender data=sashelp.class template=sgplot_waterfall;
run;
Bruno
... View more
Richard
VA will not pass any values automatically to the Stored Process, however you can assign the name of the report to one of the prompts of your STP.
Bruno
... View more
