About a_SAS_sin

a_SAS_sin

As you have suggested @gwootton I deleted the pod, it restarted automatically and the client was created. Thank you

a_SAS_sin

Hi @joeFurbee, Downloading and installing the certificate did not work but setting the environment variable did the job. Thank you very much

a_SAS_sin

Hi @joeFurbee The "this solution" link you sent points to an ESPN page (someone is a fan of American football 😉). Could you please update that? Thank you

a_SAS_sin

Hi I deleted the "dagentsrv-viya4" client from my SAS Viya installation when using the sas-admin CLI, I ran the command: sas-admin oauth deregister-client --id dagentsrv-viya4 how do I create the client again with the right settings? Thanks

a_SAS_sin

Hi @joeFurbee I am trying to connect VS Code to the SAS Viya at my organization (SAS Viya V.04.00 on AKS using Single sign-on). However, no matter what I try I always get the message "unable to verify the first certificate" once I insert the Authorization Code. For reference, I even managed to register a client app using the instructions you provided here (Authentication to SAS Viya: a couple of approaches - SAS Users) and it worked when I tested with the API but I cannot make it work with the VS Code. Thank you

a_SAS_sin · ‎02-12-2024

Hi @Keith I understood your solution but, in my real-world case, the report user can select/input 20 or 30 codes (simple IDs). Being these codes simple IDs with no meaning to the user, inserting them by hand on a text box is not feasible. As I said before and can be seen in the print screen I sent, it is just weird that we cannot use the link correctly generated in the text object. Is there a solution that does not involve manually inputting the values? Thanks

a_SAS_sin · ‎02-12-2024

Thanks for your reply @KeithM. Your solution can work, but my stored process might have many parameters, and asking the end user to type them by hand is unfeasable. With the solution I proposed using the text object, I can build the correct URL and even display it on a text object. Please have a look at the following image: If in view mode the user could simply copy the generated URL my problem would be solved. Is there a way of allowing the user to select text from the Text object? Another weird thing is, why can I add the parameter to the Text object and it displays exactly as I need it but why can't I be able to use it as a concatenated string in that exact format in any other object? Isn't there a way to convert the list object into a concatenated string as displayed in the image above?

a_SAS_sin · ‎02-09-2024

Hi everyone I am using VA 7.5 and the method described here (https://www.zencos.com/blog/sas-va-tip-download-source-data-stp) to generate a pdf based on the values selected on my VA report. The method in the hyperlink works perfectly when I want to send single values to the stored process url parameters from a parameter associated with objects with only 1 value. My problem occurs when the value I want to send to the URL parameter has multiple values. I.e., I have a list object and a parameter associated with it and I want to send this report parameter to the url link of the stored project as a parameter. Using the method described above does not work because I cannot create a calculated item that combines all the multiple values selected into a single string I then thought of adding a text object and build the complete stored process link with the parameters and ask the user to simply copy it and paste it on the browser. The url text shows just as it should however, when using the report in Viewer Mode we cannot copy any text from it. Did you ever face this issue? How did you solve it? (Please do not forget that I am using VA 7.5 ) Thanks in advance, Julio

a_SAS_sin · ‎01-11-2022

Just an update, we have not yet fixed the error but we found a workaround. In our organisation, we noticed that the issue was only happening when accessing MS access databases on network locations, hence the workaround was to copy the files to the server and updated the code to use this location. This solution is, nevertheless, temporary thus we are still investigating and because it is happening with many of you it is making us doubt if the issue is just related with our infrastructure or with some more generic SAS or Microsoft update?

a_SAS_sin · ‎01-05-2022

Hi In our SAS environment we also started getting the same error with code that worked perfectly fine before. The only SAS updates we have done recently was to apply the changes to fix the Log4j Vulnerabilities as recommended here: SAS Help Center: Introduction The weird thing is that other MS access databases still work. I am not sure if that is related with the fact that on our local machines we have Office 365 and on the SAS server we have Office 2016? We will contact IT Support and if we find a solution we will let you know. Best Regards

a_SAS_sin · ‎08-27-2021

You need the firstobs option to remove the header of the first file.

a_SAS_sin · ‎08-26-2021

You can use a filename statement with wildcards to select the files and on the infile statement you need to make use of the following properties: firstobs=2 (to start reading data from the second line) eov specifies a variable that SAS sets to 1 when the first record in a file in a series of concatenated files is read . The code below is a solution to your problem (it assumes you have 3 variables a,b,c and they are all numeric): %let csvFolder= <Path to the directory containing the csv files>; filename ttt "&csvFolder.\q*_all.csv" ; data CSVIN; infile ttt truncover firstobs=2 dlm=',' dsd eov=_eov ; input @ ;/*Start read line and hold*/ if _eov then do ; /*If if 1st row of file */ _eov = 0 ;/* EOV = 1 after first row of next file and needs to be reset to 0 */ delete ; /*delete the 1st row of each file because it is the header*/ end ; input a b c; run;

a_SAS_sin · ‎08-24-2021

To give the notion that the axiatable not "inside the data area" you just need to create some kind of separation; in the code I sent, if you just had a refline on the Y axis with a value of 140 will give you the idea that the axistable is separated from the chart. Using annotations to exactly place datalabels is quite complex since SGPANEL only allows the values GRAPHPERCENT, GRAPHPIXEL, LAYOUTPERCENT, and LAYOUTPIXEL. Using GTL and SGRender might be a solution, but you asked for sgpanel...

a_SAS_sin · ‎08-23-2021

Someting like this? proc sort data=sashelp.cars out=cars; by origin; run; data cars; set cars; Dummy=1; label dummy='N'; run; proc sgpanel data=cars ; where origin in ('Europe' 'USA'); panelby origin ; vbox length / category=type nomean nofill ; colaxistable type / class=type classdisplay=cluster valueattrs=(size=9pt weight=bold) nolabel; colaxistable Dummy / valueattrs=(size=9pt) pad=5; colaxis display=none; rowaxis display=none; rowaxis grid minorgrid; run;

Online Status	Online
Date Last Visited	4 hours ago

Re: I deleted the Client "dagentsrv" how do I create it again

Re: SAS Extension for Visual Studio Code

Re: SAS Extension for Visual Studio Code

I deleted the Client "dagentsrv" how do I create it again

Re: SAS Extension for Visual Studio Code

Re: Pass multiple values from VA List object to Stored process url par...

Re: Pass multiple values from VA List object to Stored process url par...

Pass multiple values from VA List object to Stored process url paramet...

Re: Receiving a file already in use where file resides

Re: Receiving a file already in use where file resides

The Rise of Megacities - Visualizing global population growth with SAS...

Re: Receiving a file already in use where file resides

Re: Receiving a file already in use where file resides

Re: How to annotate N counts below X axis in SGPANEL

Re: Receiving a file already in use where file resides

Re: Receiving a file already in use where file resides

Re: How to annotate N counts below X axis in SGPANEL

Re: How to annotate N counts below X axis in SGPANEL

Re: I deleted the Client "dagentsrv" how do I create it again

Re: SAS Extension for Visual Studio Code

Re: SAS Extension for Visual Studio Code

I deleted the Client "dagentsrv" how do I create it again

Re: SAS Extension for Visual Studio Code

Re: Pass multiple values from VA List object to Stored process url par...

Re: Pass multiple values from VA List object to Stored process url par...

Pass multiple values from VA List object to Stored process url paramet...

Re: Receiving a file already in use where file resides

Re: Receiving a file already in use where file resides

Re: Read and Merge multiple csv files with same first rows

Re: Read and Merge multiple csv files with same first rows

Re: How to annotate N counts below X axis in SGPANEL

Re: How to annotate N counts below X axis in SGPANEL

SAS Analytics Explorers