About ender111

ender111 · ‎02-07-2023

Where can this file: <script src="/SASJobExecution/resources/dynamic.min.js"></script> be downloaded? It's not on my machine and I can't find it for download anywhere. Thanks!

ender111 · ‎01-30-2023

I've also tried to make this value a "calculated item" that I can put in the table to pass it to the job as one string, but the calculated item won't take the character list and won't parse it.

ender111 · ‎01-27-2023

I have a parameter (named "MBP") generated by a list checkbox. The list correctly generates a series of comma separated values and I can see it in the "Roles window when I mouse over the parameter. However, when I try and pass it into a URL action from an action on a list table ("&Store_ID=MBP") it comes out printed as "MBP" instead of the composite values the Parameter is supposed to represent. What am I missing here? I would use the drop down in the action creation menu, but doesn't list my parameter (maybe because it's not on the list table, but on the same page in a list checkbox). Just about all the documentation on URL building is for sending static variables, not ones generated by a list like this. Any help would be appreciated.

ender111 · ‎01-19-2023

Unfortunately, no. It has to open it right there while the user is logged in. If ODS can't do it, any idea what can? Thanks.

ender111 · ‎01-19-2023

I need some code that will open a file produced by a SAS job. X-command will not work due to permissions issues (I guess). A lot of functions will "open" a file's data in SAS memory, but I need it to open the excel application in it. Any help would be appreciated.

ender111 · ‎01-19-2023

I have a job running in Job Execution that produces a formatted excel file. To avoid the user needing to open file explorer, how do I open or activate that newly produced file? X command won't work because the SAS job runs off the server. I read that there is a way in ODS, but can't find the proper command or line. Any help would be appreciated.

ender111 · ‎01-19-2023

Thanks, Keith. This was perfect. I had some trouble with assigning the variable on the URL end, but it was just necessary to input the optional target fields, then everything worked great. Job Execution was new for me so that took some getting used to, but is a very nice complement to report generating. Thanks again!

ender111 · ‎01-10-2023

This is amazing. How do you reference the parameter in your code coming from the URL?

ender111 · ‎01-10-2023

SAS VA 8.5.1.

ender111 · ‎01-10-2023

Stored Process is supposed to be available in the object menu under "Other", but is not present in my installation. Is there some other way to access a stored process via button or drop down object or assign a macro execution through a control on a visual or other object?

ender111 · ‎01-10-2023

What I am trying to do is use a control on a visual to manually assign a variable that a SAS program can reference before a different report is opened. is that possible? Can a button or drop down be used to store a macro variable somewhere that can be used by either a SAS program or a data plan? I do not mean using a button or drop down to assign a parameter to be used by a visual. It needs to be used by a program or data plan.

ender111 · ‎12-22-2022

I see how that can be helpful, but I need a full pivot, so categories would have to be as rows as well as measures. I can't seem to get that to work.

ender111 · ‎12-22-2022

In a list table, the categories / measures are arranged horizontally and the individual records listed vertically, much like a typical database table. Is there a way to flip that, so the categories are listed out along the y-axis with the individual records stacking along the X-axis? I tried this with crosstabs and couldn't manage it either. Thanks in advance.

ender111 · ‎12-22-2022

Thanks Stu! I didn't realize FEDSQL was the only option in CASL, which is unfortunate. As for the sorting, I performed the same in data step, but included the deduping in the same step. So, although it's not sorted the correct entries are removed and I resort it on the visualization side.

ender111 · ‎12-15-2022

I am trying to process a generic data set from SAS using a data plan in Visual Analytics to avoid excess data sets in our libraries. I know there is a data step code option in the data plan builder, and I can get a data step to work, but whenever I use a proc sql or proc sort statement it fails. I can't imagine they would build the functionality of a data step into this interface without also allowing sorts and proc sql blocks... only using data steps will not get me far. So am I incorrect? Can you use PROC SORT and PROC SQL with a certain syntax that I am just missing the trick? I have used brackets, no brackets, and only the documented dataset aliases.

Online Status	Offline
Date Last Visited	‎02-10-2023 03:15 AM

Job Execution javascript files

Re: Passing Parameter values to job through SAS Visual Analytics

Passing Parameter values to job through SAS Visual Analytics

Re: ODS Open destination file

Open an output xlsx file

ODS Open destination file

Re: Activate a macro variable via button control?

Re: Activate a macro variable via button control?

Re: Activate a macro variable via button control?

Re: Activate a macro variable via button control?

Job Execution javascript files

Re: Passing Parameter values to job through SAS Visual Analytics

Passing Parameter values to job through SAS Visual Analytics

Re: ODS Open destination file

Open an output xlsx file

ODS Open destination file

Re: Activate a macro variable via button control?

Re: Activate a macro variable via button control?

Re: Activate a macro variable via button control?

Re: Activate a macro variable via button control?

Activate a macro variable via button control?

Re: List/Crosstab table options: horizontal vs vertical categories

List/Crosstab table options: horizontal vs vertical categories

Re: Visual Analytics: dataset processing code

Visual Analytics: dataset processing code