02-10-2023
ender111
Obsidian | Level 7
Member since
04-26-2019
- 15 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by ender111
Subject Views Posted 1096 02-07-2023 12:23 PM 1355 01-30-2023 01:20 PM 1475 01-27-2023 11:46 AM 1082 01-19-2023 06:59 PM 549 01-19-2023 06:53 PM 1141 01-19-2023 11:32 AM 1630 01-19-2023 10:58 AM 1764 01-10-2023 02:56 PM 1808 01-10-2023 12:23 PM 1827 01-10-2023 12:03 PM -
Activity Feed for ender111
- Posted Job Execution javascript files on Administration and Deployment. 02-07-2023 12:23 PM
- Posted Re: Passing Parameter values to job through SAS Visual Analytics on SAS Visual Analytics. 01-30-2023 01:20 PM
- Posted Passing Parameter values to job through SAS Visual Analytics on SAS Visual Analytics. 01-27-2023 11:46 AM
- Tagged Passing Parameter values to job through SAS Visual Analytics on SAS Visual Analytics. 01-27-2023 11:46 AM
- Tagged Passing Parameter values to job through SAS Visual Analytics on SAS Visual Analytics. 01-27-2023 11:46 AM
- Tagged Passing Parameter values to job through SAS Visual Analytics on SAS Visual Analytics. 01-27-2023 11:46 AM
- Posted Re: ODS Open destination file on ODS and Base Reporting. 01-19-2023 06:59 PM
- Tagged Open an output xlsx file on SAS Programming. 01-19-2023 06:54 PM
- Posted Open an output xlsx file on SAS Programming. 01-19-2023 06:53 PM
- Tagged ODS Open destination file on ODS and Base Reporting. 01-19-2023 11:33 AM
- Tagged ODS Open destination file on ODS and Base Reporting. 01-19-2023 11:33 AM
- Posted ODS Open destination file on ODS and Base Reporting. 01-19-2023 11:32 AM
- Posted Re: Activate a macro variable via button control? on SAS Visual Analytics. 01-19-2023 10:58 AM
- Posted Re: Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 02:56 PM
- Posted Re: Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 12:23 PM
- Posted Re: Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 12:03 PM
- Posted Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 01:14 AM
- Tagged Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 01:14 AM
- Tagged Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 01:14 AM
- Tagged Activate a macro variable via button control? on SAS Visual Analytics. 01-10-2023 01:14 AM
02-07-2023
12:23 PM
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!
... View more
01-30-2023
01:20 PM
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.
... View more
01-27-2023
11:46 AM
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.
... View more
01-19-2023
06:59 PM
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.
... View more
01-19-2023
06:53 PM
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.
... View more
01-19-2023
11:32 AM
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.
... View more
01-19-2023
10:58 AM
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!
... View more
01-10-2023
02:56 PM
This is amazing. How do you reference the parameter in your code coming from the URL?
... View more
01-10-2023
12:23 PM
SAS VA 8.5.1.
... View more
01-10-2023
12:03 PM
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?
... View more
01-10-2023
01:14 AM
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.
... View more
12-22-2022
03:52 PM
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.
... View more
12-22-2022
02:27 PM
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.
... View more
12-22-2022
02:18 PM
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.
... View more
12-15-2022
06:56 PM
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.
... View more