01-16-2025
JRoman
Obsidian | Level 7
Member since
02-02-2017
- 23 Posts
- 76 Likes Given
- 0 Solutions
- 15 Likes Received
-
Latest posts by JRoman
Subject Views Posted 2877 05-11-2022 11:18 PM 2910 05-11-2022 05:23 PM 2021 04-01-2021 09:27 PM 2119 04-01-2021 01:23 AM 2156 03-31-2021 10:20 PM 2244 03-31-2021 01:19 PM 7669 06-27-2019 04:26 PM 1463 01-23-2019 03:17 PM 1623 01-11-2019 08:57 AM 1675 01-10-2019 07:05 PM -
Activity Feed for JRoman
- Liked Re: Make sasauth trigger PAM session handling to allow auto-creation of home directories by PAM modu for Jlochoa. 01-16-2025 06:33 PM
- Liked Re: Make sasauth trigger PAM session handling to allow auto-creation of home directories by PAM modu for MichelleHomes. 01-16-2025 06:33 PM
- Liked Re: Make sasauth trigger PAM session handling to allow auto-creation of home directories by PAM modu for DavidWard. 01-16-2025 06:33 PM
- Liked Re: Make sasauth trigger PAM session handling to allow auto-creation of home directories by PAM modu for Kurt_Bremser. 01-16-2025 06:33 PM
- Liked Re: Make sasauth trigger PAM session handling to allow auto-creation of home directories by PAM modu for ronan. 01-16-2025 06:33 PM
- Liked Make sasauth trigger PAM session handling to allow auto-creation of home directories by PAM modules for PaulHomes. 01-16-2025 06:33 PM
- Got a Like for Re: Add window functions in SAS SQL. 10-23-2024 08:47 AM
- Liked Re: How Can an Administrator Modify Schedule of Distributed Report for julienbaillet. 08-22-2024 10:23 AM
- Liked Increase variable name length from 32 to 128 characters for alecwh22. 08-08-2024 11:59 AM
- Liked Re: SAS Stored Process Usage Reporting for Quentin. 07-09-2024 09:46 AM
- Liked Re: JMS broker is not up for vrkgali. 11-29-2022 09:01 AM
- Liked Re: Proc import 'xlsx' doesn't work in 'guessingrows' ? for Patrick. 05-17-2022 10:08 AM
- Posted Re: What is the max length of the source/target file path in SAS Enterprise Guide Copy Task ? on SAS Enterprise Guide. 05-11-2022 11:18 PM
- Posted Re: What is the max length of the source/target file path in SAS Enterprise Guide Copy Task ? on SAS Enterprise Guide. 05-11-2022 05:23 PM
- Got a Like for Re: Enterprise Guide option to auto-scroll to bottom of log instead of top after code finishes runni. 04-19-2022 01:46 AM
- Got a Like for Enterprise Guide option to auto-scroll to bottom of log instead of top after code finishes running. 04-19-2022 01:45 AM
- Liked Re: Add window functions in SAS SQL for Quentin. 02-14-2022 08:41 AM
- Got a Like for Enterprise Guide option to auto-scroll to bottom of log instead of top after code finishes running. 09-30-2021 03:00 PM
- Got a Like for Enterprise Guide option to auto-scroll to bottom of log instead of top after code finishes running. 08-26-2021 10:09 AM
- Liked Re: Set &SYSRC from FILENAME PIPE for Kurt_Bremser. 08-05-2021 03:40 PM
-
Posts I Liked
Subject Likes Author Latest Post 6 6 6 2 5 -
My Liked Posts
Subject Likes Posted 1 04-01-2021 01:09 PM 1 05-13-2021 11:23 AM 3 04-23-2021 11:08 AM 6 03-31-2021 09:56 PM 1 01-23-2019 03:17 PM
02-12-2025
11:18 AM
Thank you for your quick answer!
... View more
05-11-2022
11:18 PM
Thanks, @ChrisHemedinger. I'll put in a ticket with tech support.
... View more
04-01-2021
09:27 PM
It's also present in that list window in EG 8.3 Update 2. I really should have looked there in the first place before assuming Ctrl+E was available... 😉
... View more
11-04-2019
04:24 PM
There is no method to run the code directly in the VBA.
However, if you have already defined the SAS Program, executed it in the SAS Add-in and you have results in the workbook, you could save the workbook, and use the Refresh method to refresh the workbook or a sheet in the workbook that contains the location of the code results.
However, the first suggestion of placing your code in a stored process and executing the store process from the VBA would be a good solution to this question.
... View more
06-27-2019
05:14 PM
@JRoman - fantastic! Glad it helped. It took weeks and weeks of diagnostics with SAS Tech Support to nail that fix. Great you could take advantage of it.
... View more
01-23-2019
03:17 PM
1 Like
Thanks for those concise examples, @Quentin. Tech Support confirmed there is indeed a defect leading to PROC ODSTEXT not properly handling certain string literals that contain URL-encoded text, and that the issue will hopefully be addressed in a future release. (No version details at this time.) In the meantime, three workarounds for the issue are: 1.) double the percent signs in the string literal, proc odstext;
p 'A%%201%%20B';
run; 2.) pass the non-encoded string literal to the URLENCODE function in the P statement, rather than calling %SYSFUNC(URLENCODE(...)) within the string literal, proc odstext;
p urlencode('A 1 B');
run; 3.) or store the encoded string in a data set variable and reference that variable in the P statement, rather than using a string literal. data foo;
s = urlencode('A 1 B');
run;
proc odstext data=foo;
p s;
run; All three of the above examples produce the same desired result: A%201%20B
... View more
02-19-2018
10:07 AM
Thanks, Gregor. We're still on 7.4 at my office, but it's good to know that option is available in 8.2.
... View more
07-11-2017
11:09 AM
2 Likes
I was coming across the same issue if I did not include the appSwitcherDisabled=true parameter in the url. Adding that parameter fixed the problem.
... View more
03-23-2017
08:52 AM
Thanks for the tips, Cynthia! Unfortunately, the actual data sets I'm working with in the report do not lend themselves well to combining into a single data set (different numbers of columns, different data types, different formats, etc. -- sorry, the demo example I gave was probably too trivial). I also cannot switch back to ODS TAGSETS.EXCELXP because the output needs to be an XLSX file instead of XML. I'll see if I can change the report requirements. Do you know if there are any plans to implement the SKIP_SPACE option in a future release of ODS EXCEL? I frequently found it to be a pretty useful feature in the tagset. Thanks, Jake
... View more