About BrunoMueller

BrunoMueller · ‎03-13-2014

Just in case the two lines eventDate = datetime(); format eventDate datetime22.3; are only for testing purposes, they are not needed in your code

BrunoMueller · ‎03-13-2014

This is a good case for the PRXMATCH function, see example below. You might also try the ANYDIGIT function data have; attrib x format=$200.; x='<skl>asffaafs 15178</skl>'; output; x='<skl>30653</skl>'; output; x='<skl>353</skl>'; output; x='353'; output; run; data want; set have; d5match = prxmatch("/\d{5}/", x); if d5match > 0 then do; d5 = substr(x, d5match, 5); end; run;

BrunoMueller · ‎03-13-2014

There are various ways, using DATEPART and YEAR function or DTYEAR format, see below data have; eventDate = datetime(); format eventDate datetime22.3; eventYear = year( datepart(eventDate) ); eventYear_c = put(eventDate, dtyear4.); run;

BrunoMueller · ‎03-13-2014

You can use Proc REPORT with the NOHEADER option or depending on the ODS desination make use of the ODS text="", see sample below. The TITLE statement will not produce output without some Proc printing something. data title; title = "This is my title Proc Report"; run; proc report data=title nowindows noheader nocenter style(column) = { background=yellow }; run; ods text="this is my title ods text=";

BrunoMueller · ‎03-11-2014

Try to use the dummy var only to color the complete line. Another approach would be the use of arrays in the compute block. Using this technique it is quite simple to compare a 100 value pairs, see example below. I guess part of the code will be created with a macro if you have a 100 value pairs to compare. data have; id_actual = 1; id_expected = 1; Var1_actual = 10; Var1_expected = 10; Var2_actual = 10; Var2_expected = 12; Var3_actual = 11; Var3_expected = 11; output; id_actual = 2; id_expected = 3; Var1_actual = 10; Var1_expected = 12; Var2_actual = 10; Var2_expected = 10; Var3_actual = 13; Var3_expected = 14; output; run; proc report data=have nowindows; column id_actual id_expected var1_actual var1_expected var2_actual var2_expected var3_actual var3_expected _dummy ; define id_actual / display; define id_expected / display; define var1_actual / display; define var1_expected / display; define var2_actual / display; define var2_expected / display; define var3_actual / display; define var3_expected / display; define _dummy / noprint; compute _dummy; array xAct{*} var1_actual var2_actual var2_actual; array xExp{*} var1_expected var2_expected var2_expected; if id_actual ne id_expected then do; call define(_row_, "style", "style={background=green}"); end; else do; do i = 1 to dim(xAct); if xAct{i} ne xExp{i} then do; call define(vname(xAct{i}), "STYLE", "Style={background=yellow}"); call define(vname(xExp{i}), "STYLE", "Style={background=yellow}"); end; end; end; endcomp; run;

BrunoMueller · ‎03-11-2014

Since all numeric variables are by default ANALYSIS variables, you can not use "age" to access the value but rather "age.sum". You can also define age to be a DISPLAY variable and then your code will work. See example below: proc report data=sashelp.class nowd; column name age sex weight; define age / display; compute age; if age in (13,15) then call define("age","style","Style={background=yellow}"); endcomp; compute sex; if sex='M' then call define(_row_,"style","style={background=green}"); endcomp; run; You can also add a dummy column and do all the processing in just one compute block, this will make it easier if the logic gets more complicated, see also an example below: proc report data=sashelp.class nowd; column name age sex weight _dummy; define _dummy / noprint; compute _dummy; if sex='M' then do; call define(_row_,"style","style={background=green}"); end; if age.sum in (13, 15) then do; call define("age.sum","STYLE","Style={background=yellow}"); end; endcomp; run;

BrunoMueller · ‎03-10-2014

Since you only change the SCL List contents the widget is not aware of any changes. You can you the _refresh, or _needRefresh method, so that the widget redraws it s content. Something like: rc = insertc(textPad.text, tempString, -1); textPad._needRefresh();

BrunoMueller · ‎03-06-2014

Have a look at the code below, you need to first convert from numeric to char and then use appropriate informat to make a SAS date from the char variable data want; infile cards dlm=","; input @1 date_n 8. ; * convert numeric to char left aligned ; date_c = put(date_n, 8. -L); * convert from char to SAS date ; date_s = input( date_c, ddmmyy8.); format date_s date9.; cards; 10413 31122013 ;

BrunoMueller · ‎03-06-2014

the Note NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 19:16 19:21 NOTE: Invalid numeric data, COL5=' 1* 6' , at line 19 column 21. Indicates that char values have been converted to numeric values, they are not coming from the CATX function

BrunoMueller · ‎03-06-2014

Hi as Amir mentioned you can make use of variable lists in the CATX function, see also sample below using an array: data want; length colString $ 120; array myVars{30} $ 4 col1 - col30; nChar = rank("A"); do i = 1 to dim(myVars); myVars{i} = byte(nChar); nChar + 1; end; colString = catx(",", OF myVars{*}); run;

BrunoMueller · ‎03-06-2014

Hi have a look at the excellent blog post Implement BY processing for your entire SAS program - The SAS Dummy by it will help you to do what you want

BrunoMueller · ‎02-27-2014

Since the outcome of the program is not exactly clear, I made one up myself, but it might give you a hint on the techniques to use. With the trailing @ sign in the INPUT statement you can read a line from the file and keep it in the input buffer, so the next INPUT statement will read from the same input buffer. I made up two record types, on that determines the beginning of a block of lines and one that ends the block of lines to read. Have a look, it might help you to get started with what you need. data want; infile cards truncover; * read record Type and keep input record ; input @1 recType $4. @ ; * check for beginning of lines to read ; if recType = "@I01" then do; retain readLine; readLine = 1; end; * check for end of lines to read ; if recType = "@A" then do; retain readLine; readLine = 0; end; * read lines and write to output ; if readLine = 1 then do; input @1 textLine $32. ; output; end; cards4; :R: John Smith, 999-7543,John.Smith@gmail.com :I: //Q XYZRTSWPQ NSPRQLQ //N L 01WOW13 @T !BRR 08;LIM 20 @01@?30@02 !BRR -100;LIM 0 !LIM 68;BRR 2 @03 @A Dear CompanyName Street Name Town Name County Post Code @I01100100100 @I02robqqgzr @I03100100100 @A Dear CompanyNAme Street Name Town Name County PostCode @I01200200200 @I02robfxmal @I03200200200 @A ;;;;

BrunoMueller · ‎02-27-2014

I am not aware of anything in SAS9.3 how about creating a PDF instead How is the HTML made available to the user?

BrunoMueller · ‎02-27-2014

With SAS9.4 you also have the possibility to have the images inline in the HTML source, so there is just the HTML output. You will use the HTML5 destination for this, see sample below. ods graphics / outputfmt=svg; ods html5 file="c:\temp\sample_svg.html" options(svg_mode='inline'); proc sgplot data=sashelp.cars; vbar origin; run; proc sgplot data=sashelp.cars; vbar type; run; ods html5 close; ods graphics / outputfmt=png; ods html5 file="c:\temp\sample_png.html" options(bitmap_mode='inline'); proc sgplot data=sashelp.cars; vbar origin; run; proc sgplot data=sashelp.cars; vbar type; run; ods html5 close;

BrunoMueller · ‎02-26-2014

Since you already use GTL and Proc SGRENDER you can combine your individual graphs into one statgraph defintion using nested layouts. Please be aware that all the data for the individual graphs must come from the same data set. See a sample below using SASHELP.CARS. Maybe SGPANEL might be another option. If you show us what it should look like will help. proc template; define statgraph lattice_layout_nested; begingraph / designwidth=1200 designheight=800; layout lattice / rows=2 rowgutter=5 rowweights=(0.3 0.7); layout lattice / columns=2 columngutter=5 columnweights=(0.7 0.3); layout overlay / walldisplay=(outline) xaxisopts=(display=(tickvalues ticks )) yaxisopts=(display=(tickvalues ticks )) ; entry "Graph 1" / valign=top location=outside; barchart x=type / group=type name='bar3' stat=freq; endlayout; layout overlay / walldisplay=(outline) xaxisopts=(display=(tickvalues ticks )) yaxisopts=(display=(tickvalues ticks )) ; entry "Graph 2" / valign=top location=outside; barchart x=ORIGIN / group=origin name='bar' stat=freq; endlayout; endlayout; layout overlay / walldisplay=(outline) xaxisopts=( display=(tickvalues ticks ) discreteopts=(tickvaluefitpolicy=rotate) ) yaxisopts=(display=(tickvalues ticks )) ; entry "Graph 3" / valign=top location=outside; barchart x=MAKE / name='bar2' stat=freq ; endlayout; endlayout; endgraph; end; run; ods graphics / reset; proc sgrender data=sashelp.cars template=lattice_layout_nested; run;

Online Status	Offline
Date Last Visited	‎09-10-2025 02:06 AM