About Billybob73

Billybob73 · ‎03-14-2022

Hi, When double clicking on a visual, SAS has got the possibility to link the one page to the other page enabling down drilling to detail data, which is nice. Obviously you don't want report users to see the detail tabs in the report, especially when there are many. The thing is when you hide those 'detail pages', the detail window appears as a very small pop up window by default when double clicking on the visual. Is there a way to get this maximalized by default keeping the detail tab hidden ? It's quite bothersome to enlarge these pop up windows by hand. Thanks ! Rgds William

Billybob73 · ‎02-14-2022

Hi, I have a vertical bar chart and on the horizontal axis there are months (1-12). What I would like to do is create a functionality for users that if they double click on the bar for month 9 for instance that it leads them to a table in a different report section with details of month 9 in it. I know things can be done with parameters, but I can't see how I can use one in this case. Thanks for help or suggestions Rgds BB

Billybob73 · ‎11-09-2021

Hi Madelyn, Thanks for your answer. I'd like it to appear as a pop op menu just like at the top of a web site. I've found a solution with list tables in a prompt container which dynamically interact because of the parameters filtered. However it's not really what I want. I'm not sure if I understand your solution well. Do I get the desired result with this. Do you have an instruction on how to do this ? Thanks ! Rgds B

Billybob73 · ‎11-08-2021

Hi, I've got a report filter consisting of 1 category. However I would like to display 2 categories in the filter. So when you click on the filter, you can also see the sub category in the filter. I enclosed a (non SAS VA) screenshot to point out what I mean. I've seen somebody do this in the past but I don't know how he did it. Thanks !! RGDS William

Billybob73 · ‎05-18-2021

Hi, I' m trying to run below code but it gives me this error. What can I do to circumvent this ? : Error: Integration technologies failed to submit the code. [Error] Failed to transcode data from U_UTF8_CE to U_LATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process. A portion of the source string, in hex representation is: data names; length first_name $15 last_name $30 ; input first_name $ last_name $; infile datalines delimiter='|' encoding='wlatin1'; datalines; Bjørnsen | MØLLER Marius | Malazinskas' čárkou | íois měkké | čárkou ; run;

Billybob73 · ‎05-17-2021

Hi, Does anyone know how you can make a listing of jobs and tables used in those jobs ? I've come across code to list all libraries and tables, but what I would like to find out is how I can get metadata for a SAS DI Studio job along with the tables used inside that job. Thanks ! Rgds BB

Billybob73 · ‎12-15-2020

Hi I've been looking for sample code to understand a SAS stored process that enables users to enter data whereas this data is written to an underlying table. I cannot find this. Has anybody experience with this ? How does this work ? Thanks!BB

Billybob73 · ‎10-27-2020

Hi 7Zip is installed on my SAS BI server, which is great because we have to zip with encryption. I've read somewhere on this platform how to zip a single file and this works : data _null_; zipexe='"<path to 7zip executable>\7z.exe" a -tzip -pPASSWORD'; zipfile="<zip target path>\<zipfile>.zip"; file="<zip source path>\<file to be zipped>.<extension>"; cmd = zipexe ||' "'|| zipfile ||'" "'|| file ||'"' ; call system(cmd); run; I've been trying to zip a whole folder by googling for command lines for 7zip but was not successful. Anybody knows how to do this ? Thanks! RGDS B

Billybob73 · ‎10-23-2020

Hi, Has SAS developed a method in the meantime to zip files from the SAS server with encryption ? (password). I'm not looking for methods such as intalling winzip command line on the SAS server. I mean a home grown SAS method. Thanks ! Rgds B

Billybob73 · ‎08-25-2020

Hi, My impression was that when you a a file with a lot of macros in a particular location you could call these macros with a options sasautos=(sasautos "<path>")); In my case this does not work. It says "Apparent invocation of macro <macroname>" not resolved. Do I need something extra ? Path is existing (checked). I'm working in a Windows environment. Thanks ! Rgds William

Billybob73 · ‎03-17-2020

Hi, I would like the proc print to work in the code below through a stored process, but it won't. I'm lost.. How do I get this to work ? Thanks!! Rgds BB data _null_; format infile $char256.; input; infile = resolve(_infile_); file _webout; put infile; cards; <html><body BGCOLOR="silver"> <H3>Customer Submission Form</H3> <form action="&_URL"> <input type="hidden" name="age" value="&age"> Select the age of the students to be listed: <select name="age" > <option value="11"> 11 <option value="12"> 12 <option value="13"> 13 <option value="14"> 14 <option value="15"> 15 <option value="16"> 16 </select> <br><br> <input type=checkbox name="_debug" value="log"> Show SAS log? <br><br> <input type=submit value="Execute Stored Process"> </body></html> ; run; proc print data=sashelp.class; where age = &age; title1 "&age-Year-Old Students"; run;

Billybob73 · ‎02-11-2020

Hi, I've been experimenting uploading files from SAS EG to our sharepoint site. This works for SAS datasets using the following code (&doelpad is the sharepoint URL + folder) : option set=SHAREPOINT_COMP_MODE 1; filename sometest webdav "&doelpad./cars.csv"; proc export data=sashelp.cars file=sometest dbms=csv replace ; run; Let's say I want to upload pdf or xlsx files from SAS, how would I proceed ? Thanks BB

Billybob73 · ‎01-17-2020

Kurt It has indirectly. I need the conversion in a broader perspective. It's part of a huge query. Explicit is always faster than implicit. There's a lot of transformations and conversions in the original implicit code. I want the SQL server database to process. Therefore I'm transforming all of the SAS functions to SQL server functions. Thanks Rgds BB

Billybob73 · ‎01-17-2020

Hi Kurt, Thanks for your answer. I cannot do this implicitely. The thing is that i'm writing code to improve performance so I just have to find the solution on the SQL server side. Would you know the SQL server function to do this ? I've been googling a lot but cannot find this solution. Thanks BB

Billybob73 · ‎01-17-2020

Hi, I'm query-ing an MS SQL server tabel from SAS. In SQL Server there is a datetime field which has only got date vaules in 1960, for instance : 1960-01-01 05:40:53.000 1960-01-01 05:45:27.000 I want to convert these to date values When I run implicit code this works : put(<datetime field sql server>, ddmmyy10.) This way 01JAN1960:05:52:03.000 is converted to 31/10/2017, which is correct. But I would not know how to convert this in explicit code . Which SQL server function should I use ? The datetype SQL Server uses is DATETIME. Thanks !! Rgds BB

Online Status	Offline
Date Last Visited	‎02-26-2023 07:47 AM

default maximalized pop up window SAS VA

drill down from visual SAS Visual analytics

Re: SAS VA hierarchy in report filter

SAS VA hierarchy in report filter

Error: Integration technologies failed to submit the code. Character s...

Get metadata info of a SAS DI Studio Job (jobs & tables)

iSAS stored proces web input form

How to zip a complete folder from SAS with 7Zip

zip with password from SAS

options sasautos does not work

Re: Proc Metadata to get Dependent Objects

Re: Local host in SAS Enterprise Guide standalone

Re: file properties of zip file members SAS