About BrunoMueller

BrunoMueller · ‎09-15-2016

Hi A few things to consider: Put everything into one directory ( .EGP file), you can have subdirectories (data, programs, macros etc.) In the properties of the Enterprise Guide Project, File - Project Properties, go to File References and check the "Use paths relative to the ...", this is for importing data like csv, references to external SAS code etc. For the SAS Library, have a look at the blog entry http://blogs.sas.com/content/sasdummy/2011/07/11/how-to-assign-a-library-to-the-same-path-as-your-sas-enterprise-guide-project/ by @ChrisHemedinger Considering all of this, you can simply copy a the base directory whereever you want and it will just work. Bruno

BrunoMueller · ‎09-15-2016

hi Change your FORMAT statement like so data want; set sashelp.class; format _numeric_ 9.3; run; Please note this does not round values, it just changes how the value ist displayed. Do you actually want to round the values? Bruno

BrunoMueller · ‎09-11-2016

Have a look at this paper Table Lookup Techniques : From the Basics to the Innovative by Art Carpenter it gives a good overview of different techniques. The type of method to choose is also dependant on the amount of data. Have a look at the first example using a hash object. Bruno

BrunoMueller · ‎09-09-2016

The "Enable at Startup" can only be specified when you create a new library from the SAS Explorer. This information is stored in the SAS Registry (stored in the SASUSER library). I recommend the approach using a SAS program, since this is portable. Bruno

BrunoMueller · ‎09-09-2016

Can just speak for the envionment I have at hand: Running an SQL pass through on a hadoop hive table, using Hue JobBrowser, I can see the job being created an run. Bruno

BrunoMueller · ‎09-09-2016

SAS Libraries are created using the LIBNAME statement. So all you need to do is, save all the LIBNAME statements to a SAS program and run it when you start SAS. Depending on your SAS Environment (SAS University Edition, SAS Installation on your PC, SAS Platform Installation) there might be other options. Bruno

BrunoMueller · ‎09-08-2016

SAS Studio uses two SAS process in the back. One services the code submission & one services the interface (file, folder, library operations, etc.) Bruno

BrunoMueller · ‎09-08-2016

Hi You have to set the ATTRPRIORITY= option with the ODS GRAPHICS statement, see example below ods graphics / attrpriority=none; proc sgplot data=sashelp.iris; title 'Fisher (1936) Iris Data'; styleattrs datasymbols=(circlefilled squarefilled starfilled) ; scatter x=petallength y=petalwidth / group=species markerattrs=(size=5px); run; Bruno

BrunoMueller · ‎09-06-2016

Hi Have a look here Using the SAS Information Maps LIBNAME Engine If you have SAS Enterprise Guide, it will create the code for you when you are opening data from an Information Map. See also this blog entry http://blogs.sas.com/content/sasdummy/2010/05/25/reporting-on-sas-information-maps/ by @ChrisHemedinger Bruno

BrunoMueller · ‎09-06-2016

They key has to be a match. You mentioned "for the code below", but there is no code.

BrunoMueller · ‎09-05-2016

Hi If the find method does not find an entry, you could find again this time, setting the color to search for to "*", see code sample below. The hash object always needs all the keys to be present. data report; set Products; length report_position $10 ; if _N_=1 then do; declare hash h(dataset:"Mapping"); h.definekey("product","color"); h.definedata("report_position"); h.definedone(); end; rc = h.find(); if rc ne 0 then do; rc = h.find(key: product, key: "*"); end; putlog _all_; run; Bruno

BrunoMueller · ‎09-05-2016

Hi Since the SAS Macro Language is text based you do not need to use quotes. Since some of your text contains characters which have a meaning in the macro language (comma separating arguments in functions) you need to use quoting functions. To understand quoting functions, I recommend to read the following blog http://blogs.sas.com/content/sgf/2014/08/15/macro-quoting-made-easy/ Below is the changed code: %let Filename_1 = FILE1, FILE2; %let SAS_DATASET = DATA1, DATA2; %macro file_process; %let word_cnt = %sysfunc(countW(%bquote(&Filename_1), %str(,))); %put NOTE: &=word_cnt; %do i=1 %to &word_cnt; %let file_name = %scan(%bquote(&Filename_1), &i, %str(,)); %let dataset = %scan(%bquote(&SAS_DATASET), &i, %str(,)); %put NOTE: &=i &=file_name &=dataset; %end; %mend file_process; %file_process Bruno

BrunoMueller · ‎09-05-2016

Hi To put all values of an array into one string, you can use the CAT... functions together with the OF keyword and an arrayname. See example below. data _NULL_; x1 = 1; x2 = 2; x3 = 3; array bonds{*} x1-x3; length array_string $20; array_string = catx(" ", of bonds{*}); call symputx('my_array', array_string); run; %put NOTE: &=my_array; Bruno

BrunoMueller · ‎09-05-2016

Hi You can use some options on the SET statement to achieve this, see example below. Please be aware when using the POINT= option, you also need a STOP statement, as otherwise the DATA Step will loop. Have a look in the doc at the description of the POINT= and NOBS= options. The variable name used in the POINT= option is not written to the output dataset, this is why I use two variables. data want; getObs = ceil( ranuni(0) * numObs); _getObs = getObs; set sashelp.cars point=_getObs nobs=numObs; output; stop; run; Also look at Proc SURVEYSELECT for more sophisticated ways to get a random sample from a SAS data set Bruno

BrunoMueller · ‎09-05-2016

For a non SAS user to call the Web Service you create the Stored Process with the appropriate parameters you give the caller the URL to call the STP as a web service, inclduding a description of the parameters expected and returned The Proc HTTP code, is a way to call a web service from a SAS program, so this can be used to test your web service, as well as calling non SAS web services. Bruno

Online Status	Offline
Date Last Visited	Monday