I created functions, using PROC FCMP, and made these functions available to our users, who write SAS Code. We also have several users, working in SAS Enterprise Guide, using tasks like the Query Builder. I can use the user defined functions within the Query Builder, by typing the name of the function in the "Enter an expression" area in the 'Build an advanced expression' window .   Can I add the user defined functions to the list of functions pane, so the user can pick the function from the list, instead of having to type the syntax? If Yes, what set-up is required for this?   Note: we use SAS Enterprise Guide 7.15 on a Linux platform   Looking forward to any feedback   Best regards,   Henri ... View more

Hi,   We need to exploit Google Analytics data. We found several documents and blogs, but they're all quite 'old'. The SAS Support team indicated that a lot changed in the meantime and that these articles are outdated. They suggest to work with PYTHON. Does anybody have some examples of this? Note: the solution should run on Linux 9.3. 'Plan B'  is to run it on Windows.     Regards,   Henri ... View more

Hi, I want to use multiple prompts in a flow in SAS/Enterprsie Guide, where the user has to enter for instance a client number and a location. With the info provided by the user, I want to check whether this combination exists in a table. If the combination exists, I want to continue my processing otherwise the user should be prompted to provide other values for the prompt. Can one build this in Enterprise Guide? Regards, Henri ... View more

Hi, How can I use a prompt to run a Process Flow? For instance, if the result of a prompt is value ABC, then run Process Flow 1, if the result is value QPR then run Process Flow 2. Henri ... View more

Hi, Does anyone has a good example of creating and using a prompt with a numeric or character range Regards, Henri ... View more

Hi, I have an application generating 1 large PDF file. Let's say that I have to create output per Division. For each Division I have to create 3 pages, each page containing several tables and graphs. I need to add a table of contents and bookmarks showing - instead of PROC names, and labels like 'GCHART15' - meaningfull information: 1 item for each Division Example Assume an output with Page 1: Division One, with Table1 and Chart1 Page 2: Division One, with Chart2, Chart3 en Table 2 Page 3: Division One, with Table3 and Plot1 Page 4: Divsion Two, with Table 4 and Chart 4 etc.. I want to have a TOC and bookmarks showing only - Division One - Division Two Does anyone have an example on this? Henri ... View more

Hi, I need to create output in PDF format, combining several graphs and results of PROC TABULATE on the same page. What are the best ways to achieve this? Henri ... View more