About cociotho

cociotho · ‎12-05-2014

HI DavidPhillips2, I also forgot to ask, did you question get answered via my assistance? Thanks

cociotho · ‎12-05-2014

Hi DavidPhillips2, So did my code lead you to this? You are correct that if you want one row, going west to east of charts, the options(panelcolumns='3') works, however, if you want multiple rows and multiple columns, not always equal on both axis, then creating panels, columns and rows is the best way to go. I suppose you could have multiple %Let _ODSOPTIONS statements, if you need generic rows, it would work fine. Glad you found a resolution.. Regards Jonathan

cociotho · ‎12-04-2014

Hi, Have you tried creating a stored process that would export the detail data to an application like Excel? I provide my users the ability to "right-click" the OLAP cube measures and select a custom menu function that exports the underlying SAS dataset to excel, but you could export to an file type that you currently have support for. If interested, I could send you a code sample. let me know Thanks

cociotho · ‎12-04-2014

Hi David, In order to see the SGPlot Graph's side by side, you need to establish rows/columns within your tagsets.htmlpanel panel(start) event, here is an example I use almost everyday for generic dashboard users (very high level data), this is a simple layout for a url display port showing graphs, 1 panel, 2 rows with various columns on each row. I also wrap this so it can be used in a stored process. Hope this helps %inc "Your Assigned Drive Letter:\SAS\EBIEDIEG\Lev1\SASApp\htmlpanl.tpl"; %let _odsdest=tagsets.htmlpanel; *ProcessBody; filename odsout 'c:\temp'; ods tagsets.htmlpanel Path = odsout Body="HtmlPanel.html" style=styles.Sasweb options(embedded_titles='yes'); %STPBEGIN; ods tagsets.htmlpanel event=panel(start); ods tagsets.htmlpanel event=row_panel(start); ods tagsets.htmlpanel event=column_panel(start); ods tagsets.htmlpanel event=column_panel(finish); ods tagsets.htmlpanel event=row_panel(finish); ods tagsets.htmlpanel event=panel(finish); ods tagsets.htmlpanel event=panel(start); ods tagsets.htmlpanel event=row_panel(start); ods tagsets.htmlpanel event=column_panel(start); ods tagsets.htmlpanel event=column_panel(finish); ods tagsets.htmlpanel event=column_panel(start); ods tagsets.htmlpanel event=column_panel(finish); ods tagsets.htmlpanel event=row_panel(finish); ods tagsets.htmlpanel event=panel(finish); %STPEND; ods _all_ close;

cociotho · ‎05-23-2012

Hi Quentin, Have the user's export the MS Access tables to an excel spreadsheet or even a csv file format. Then create a simple upload form using a sas stored process that would allow you to grab the file off of a file share somewhere. When you click the open button to search for the file, it uses your local drive and lan drive mappings to search, then just upload the data into a data set on the sas server. I have attached an example below, /*Code for the download/upload portlet, built in Eneterprise Guide and loaded through a stored process on the Information Delivery Portal*/ *ProcessBody; ods html file='temp.htm' style=Styles.NormalPrinter; %STPBEGIN; Title Justify=Left "A title name for your simple upload portlet."; data one; file print; put '<html>'; put '<form action="http://your sas server name goes here/SASStoredProcess/do1" enctype="multipart/form-data" method="post">'; put '<Legend>Step 1. Please download the file linked below, this is the latest Forecasting Summary.</Legend>'; put '<a href="http://your sas server name goes here/SASPortal/Director?_directive=STPRun&_program=%2FShared+Data%2FSP+SWR+INFSYS+EO+Export"> Actuals & Forcasting Summary Download Link</a>'; put '<br>'; put '<Legend>Step 2. Please browse to your revised forecasting spreadsheet and select it for upload.</Legend>'; put '<input type="hidden" name="_program" value="sbip://METASERVER/Shared Data/SP_IRGUpdate">'; put '<table border="0" cellpadding="5">'; put '<tr>'; put '<th>Choose a file to upload:</th>'; put '<td><input type="file" name="myfile"></td>'; put '</tr>'; put '<tr>'; put '<td colspan="2" align="center"><input type="submit" value="OK"></td>'; put '</tr>'; put '</table>'; put '</form>'; put '</html>'; ; run; %STPEND; ods html close; /*--------------------------------------- End of Code -------------------*/ /* Code to execute the upload process*/ %let XLSFILE=%sysfunc(pathname(&_WEBIN_FILEREF)); *ProcessBody; proc import datafile="&XLSFILE" out=dashdata.mydata dbms=xls replace ; getnames=yes; run; quit; ods html file="temp.html" style=style.normalprinter %STPBEGIN; Title Justify=Left 'The first 10 Records of the xls IRG Forecasting Update Table'; proc print data=dashdata.mydata(obs=5) Style=NormalPrinter ; run; quit; %STPEND; ods html close; /*---------End of Code to Upload file----------------*/ In the first section of code, I bolded the code you would be most interested in. Hope it works for you..

cociotho · ‎04-27-2012

Hi FrankE, Not sure if you found a solution to your question above, since it's been 6 or so months. I have developed a stored process that exports a specific sas data-set to excel, opens the client application, all from a sas url path. You can also run this directly from EG as well. Please see the examples below; http://sas server url path goes here:server port# goes here/SASPortal/Director?_directive=STPRun&_program=%2FShared+Data%2FSP+SWR+QMSYSA+TLD+Export Or with the data filled in http://rdsasap.testserver.com:9999/SASPortal/Director?_directive=STPRun&_program=%2FShared+Data%2FSP+SWR+QMSYSA+TLD+Export I have also been able to export data directly to Excel from EG, see attached zip file...

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: ods tagsets.htmlpanel doesn’t work but no error message

Re: ods tagsets.htmlpanel doesn’t work but no error message

Re: Sas web report studio SP export detail data

Re: ods tagsets.htmlpanel doesn’t work but no error message

Re: Upload access file to Stored Process?

Re: Stored process and ExcelXP tagset error and odd results

Re: ods tagsets.htmlpanel doesn’t work but no error message

Re: ods tagsets.htmlpanel doesn’t work but no error message

Re: Sas web report studio SP export detail data

Re: ods tagsets.htmlpanel doesn’t work but no error message

Re: Upload access file to Stored Process?

Re: Stored process and ExcelXP tagset error and odd results