About niko_gallo

niko_gallo · ‎03-19-2020

Ciao, my problem is to align only the repository foundation keeping the link with the second repository. I was already headed in the direction you proposed! Thanks again

niko_gallo · ‎03-02-2020

Hello, I have an environment with 2 repositories: Foundation: User \ Group (same as LDAP users) [Repository 2]: access group and ACT Normally the 2 repositories are linked. an example: I create in Foundation [USER1], [GROUP1] and the association [USER1] in [GROUP1] I create in [Repository 2] [GROUP2], [ACT1] and associate the [GROUP2] in [ACT1] In the properties of [metadata Folder1] I assign the [GROUP2] and the [ACT1] In the process of extracting the star-schema (developed through the SAS standard) I cannot find the association of point 2 illustrated above, whether you download the data from the Foundation or from the [second repository]. How can I find this data? and once found can this information be updated through the SAS procedure? thanks in advance and sorry for my english! Niko

niko_gallo · ‎02-03-2020

my autoexec has the option EMAILACKWAIT = 300. my job does the following: 1. data step 2. send mail 3. data step 4. send mail 11:34:29 AM: my job went wrong in step 2 with the error "ERROR: Email server did not respond" 11:35:00 AM: performed step 3 question: shouldn't step 2 wait at least 300 seconds? thanks in advance Niko

niko_gallo · ‎04-30-2019

I solved the problem of execution. i run the vbs via CMD. but now i have a new question: I have 2 servers: development and production. If on the development my EG has "production" active connection it executes the project on this connection, i don't want this to happen. i want if I run vbs on development the EG project must be run on the same server and not on the active connection. thanks in advance. Niko

niko_gallo · ‎04-29-2019

Hi everyone, thanks in advance. how bypass the user/password request? Niko

niko_gallo · ‎07-23-2018

hi, i have a problem with ouptut xlsx with a stored process server. any suggestion? thanks in advance SAS-CODE ods excel options(sheet_name="&_report_name.") file=_webout style=plateau; data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header("Content-disposition","attachment; filename=&_report_name._&_dt_report_ymd..XLSX"); run; proc print data =&_report_name. noobs label ;run; ods excel close; LOG STORED PROCESS ERROR: The SAS System stopped processing this step because of insufficient memory. NOTE: There were 283923 observations read from the data set WORK.CENTRISC. NOTE: The PROCEDURE PRINT printed pages 1-977. NOTE: PROCEDURE PRINT used (Total process time): real time 1:54.75 cpu time 1:48.84 ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information:

niko_gallo · ‎06-26-2018

Ooook

niko_gallo · ‎06-26-2018

hi Cynthia, i submit my STP from SAS portal (Windows IE) and this is the code: *ProcessBody; ods excel file=_webout style=plateau; data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header("Content-disposition","attachment; filename=report.XLS"); run; proc print data =report (drop = dtreport) noobs label ;run; ods excel close; I do not have any problem with this sas-code...so...i want to insert the waiting message between when i submit the STP and when i save the output in xls format. regards Niko

niko_gallo · ‎06-26-2018

hi chintia, the following solution it's wrong! because print the xls on the webpage... data _null_; file _webout; put '<html>'; put '<body>'; put '<div id="pleasewait">'; put '<h2>Please Wait. Your request is being processed.</h2>'; put '</div>'; do i = 1 to 10; put " "; end; run; data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header('Content-disposition','attachment; filename=try3.xlsx'); run; ods excel file = _webout style=Plateau; proc print data=sashelp.cars; run; ods excel close; this is the result:

niko_gallo · ‎06-26-2018

hi Morten, my SAS code is similar...is: ods excel file=_webout style=plateau; data _null_; rc = stpsrv_header('Content-type','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); rc = stpsrv_header("Content-disposition","attachment; filename=&_name_report._&_dt_report_ymd..XLS"); run; proc print data =&_flnm. noobs label ;run; ods excel close;

niko_gallo · ‎06-26-2018

...waiting message... how to post a waiting message in STP? Displaying the "Please Wait" message for a long-running stored process

niko_gallo · ‎06-20-2018

hi, how can I print a title on the web page after export? thanks Niko

Online Status	Offline
Date Last Visited	‎09-22-2020 08:39 AM

Re: sas metadata user synchronization with more repository

sas metadata user synchronization with more repository

ERROR: Email server did not respond with EMAILACKWAIT option

Re: Auto Purge Project Log in EG

Re: Auto Purge Project Log in EG

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: sas metadata user synchronization with more repository

Re: Stored Process - output to XLSX

Re: sas metadata user synchronization with more repository

sas metadata user synchronization with more repository

ERROR: Email server did not respond with EMAILACKWAIT option

Re: Auto Purge Project Log in EG

Re: Auto Purge Project Log in EG

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: Stored Process - output to XLSX

Re: ODS EXCEL in Web StoredProcess