About BrunoMueller

BrunoMueller · ‎09-01-2016

Just import the STP provided in the SAS Package file I added as an attachment. Then you have a STP that fits the code to test. With SAS9.4 (maybe SAS9.2) there is no longer a need to create a WebService from a Stored Process, you just need to use the right URL to call the STP as a WebService, as per the documentation I referenced. Bruno

BrunoMueller · ‎09-01-2016

The END = LAST sets a flag that tells you when the last oberservation has been read; The expression for M was doifferent in your DATA Step as compared to the one you are using in IML Below is the new code: data have; set test end=last; array temp_array(5,2) _temporary_; temp_array{_n_, 1} = temp; temp_array{_n_, 2} = speed; /* * if all the data has been read, do the caculation */ if last = 1 then do; m = (temp_array{2,2} - temp_array{1,2}) / (temp_array{2,1} - temp_array{1,1}); l = temp_array{1,1} * m - temp_array{1,2}; putlog m= l=; output; end; keep m l; run; Please note that DATA Step arrays are not a replacement for the functionality you have in IML. Bruno

BrunoMueller · ‎09-01-2016

You have to load the data into the array "manually", see example code below. data have; set test end=last; array temp_array(5,2) _temporary_; temp_array{_n_, 1} = temp; temp_array{_n_, 2} = speed; if last = 1 then do; m=(temp_array{1,1}-temp_array{2,2}/temp_array{2,1}-temp_array{3,2}); putlog m=; end; run; The example uses the _TEMPORARY_ keyword, so no variables are created in the Program Data Vector (PDV), also all the values are retained. Once the array is loaded, you can use the expression. Bruno

BrunoMueller · ‎09-01-2016

In order to reference new columns in SQL you can use the CALCULATED keyword See sample below: PROC SQL; CREATE TABLE ANA AS SELECT CUST ,MAX(A) as max_a ,MAX(B) as max_b ,MAX(C) as max_c , max(calculated max_a,calculated max_b,calculated max_c) as maxValue from test group by 1 ; quit; But one could run another query on the ANA table to create the max column Bruno

BrunoMueller · ‎09-01-2016

You have more than one ODS destination open, one of them is LISTING. Simply close the listing destination, like so: ods listing close; Bruno

BrunoMueller · ‎09-01-2016

hi Have a look at this documentation Invoking RESTful Web Services. If you have the corresponding web application (/SASBIWS), you are good to go. You create a Stored Process with the necessary parameters. Then use one of the endpoints to call the web service and pass parameters Here is a sample code to test a web service from SAS. The STP has four parameters that have the same name as you see in the XML with the code (tableName, columnName, statName, someDate) * * for Windows use port = 80 *; %let hostName = &systcpiphostname; %let port = 7980; %let SASBIWS_path = /SASBIWS/rest/storedProcesses; %let stpName = /yourfolder/yourSTP; * * build parm list for REST XML request *; filename htin temp; data _null_; infile cards; input; file htin; put _infile_; cards4; <any> <parameters> <tableName>sashelp.cars</tableName> <columnName>invoice</columnName> <statName>MEAN</statName> <someDate>2016-01-17</someDate> </parameters> </any> ;;;; * * call STP as REST WS *; filename htout temp; proc http method="POST" URL="http://&hostName:&port.&SASBIWS_path.&stpName" in=htin out=htout ct="application/xml" verbose ; run; * * display result *; data _null_; infile htout; input; putlog _infile_; run; filename htin clear; filename htout clear; As attachment, there is a SAS package file with the Stored Process, that fits the SAS code above. Take away the .ZIP extension, so that the file can be imported in the SAS Management Console. Bruno

BrunoMueller · ‎08-25-2016

Here is a version for the first work day in the month data want; do year = year(today())-1 to year(today()); do month = 1 to 12; firstDayMonth = mdy(month, 1, year); firstMonday = NWKDOM(1, 2, month, year); if day(firstMonday) <= 3 then do; firstWorkDay = firstMonday; end; else do; firstWorkDay = intnx('weekday17w',firstDayMonth,0); end; output; end; end; format first: weekdate.; run; Bruno

BrunoMueller · ‎08-25-2016

SAS has the NWKDOM function that can give you back the first monday in a month. See the sample below. Whether a date is a holiday that needs to come from somewhere else as it might be country and region dependant. data want; year = year(today()); do month = 1 to 12; firstDayMonth = mdy(month, 1, year); firstWorkDay = NWKDOM(1, 2, month, year); output; end; format first: weekdate.; run; Bruno

BrunoMueller · ‎08-24-2016

If you just want to create a new table that has the same structure as the old table, you can use create table newTable like oldTable; See also this sample code here: data newCars; seqNr = _n_; set sashelp.cars; run; proc sql; create index seqNr on newcars; describe table newCars; create table newCars2 like newCars; describe table newCars; quit; Bruno

BrunoMueller · ‎08-24-2016

Hi There is some definition involved, but it is possible to do, see this paper for more details. https://support.sas.com/resources/papers/proceedings11/246-2011.pdf Here is a sample program based on the paper mentioned. ods escapechar="^"; proc report nowd data=sashelp.class style(report)=[rules=none frame=void] style(header)=[borderbottomcolor=black borderbottomwidth=2 background=_undef_] ; column ('^{style[borderbottomcolor=white borderbottomwidth=2 bordertopcolor=black bordertopwidth=2]}' name) ('^{style[borderbottomcolor=black borderbottomwidth=2 bordertopcolor=black bordertopwidth=2]spanned header}' age sex weight height) ; compute after _page_ / style={bordertopcolor=black bordertopwidth=2}; line ' '; endcomp; run; There might be other ways as well Bruno

BrunoMueller · ‎08-22-2016

Hi If the format is already assignd to the variable, you can also use the VVALUE() function. Which version of the DATA Step did you choose for your program? Bruno

BrunoMueller · ‎08-22-2016

Hi As @Kurt_Bremser already mentioned the ODS PDF is a global statement, and can not be executed within a DATA Step loop. Since SAS9.3 there is a function DOSUBL, that allows you to execute global statements or complete steps while the DATA Step is running. So find below two DATA Steps, showing two approaches, the second one is most similar to what you want to do. ods pdf file="c:\temp\sample.pdf"; data _null_; set sashelp.class; length printLine $ 254; printLine = catx(" ", "the person named:", name, "is", age, "old"); file print ods=( GENERIC=ON variables=(printLine) ); put printLine ; run; data _null_; set sashelp.class; length printLine $ 254; printLine = catx(" ", "the person named:", name, "is", age, "old"); rc = dosubl(cats("ods pdf text=", quote(printLine), ";") ); run; ods pdf close;

BrunoMueller · ‎08-19-2016

This will be the max length for any char variable written to the file. You might need to adjust it. Bruno

BrunoMueller · ‎08-19-2016

Hi Have a look at the "Update Library Metadata" task under Tools. This task can report on the differences between the Metadata definition and the actual physical table. The task can also update the Metadata definition, provided you have the necessary permissions. Bruno

BrunoMueller · ‎08-19-2016

Hi I would use the DATA Step to do this. Maybe there are some macros out there, that do exactly this. Currently the text is written to the SAS Log, so change the "log" to the "c:\yourname.csv" name you need. The DLM= option will add the commas between the values. The FORMAT statement assign the $QUOTE. format to all character variable, this cause all character variables to written out with quotes. data _null_; set have; file log dlm=","; format _character_ $quote254.; put VAR1 student_number VAR3 first_name last_name VAR6 ; run; Bruno

Online Status	Offline
Date Last Visited	Monday