When SAS Add-In for Microsoft Office was first created over a decade ago, SAS programmers were told to check their skills at the door. This new product was for non-programmers only. SAS programmers were invited to contribute to the experience by packaging their code in SAS stored processes, which end
Geht es Ihnen nicht auch so? Ich liebe Excel! Von „Mal schnell was ausrechnen…“ bis zur Gewinn- und Verlustrechnung für die Steuererklärung ein rundum gelungenes Programm, bei dem man komplexe Formeln direkt da hin schreiben kann, wo sie berechnet werden und man sogar noch genügend Formatierungsmöglichkeiten hat, um nachher was
A few of the SAS AMO users in my facility (including me) have run into problems around SAS's interation with the normal.dot file. SAS Add-in to Microsoft Office uses the normal.dot as a performance improvement mechanism. SAS stores toolbar and menu information into normal.dot to keep from loading every time
Well, setting up a SAS Installation Depot is one thing, but how then do you get users to install the SAS Add-in to Microsoft Office. After attempting to point them to the directory … root folderclient9cdmsofficeintsetup.exe some of my users received error messages such as: COM object with CLSID {C97B3405-B0CA-4B1A-9B90-C334554D81BC}
SAS' Leonid Batkhan summarizes a lesser known but useful feature in SAS that allows you to bring Microsoft Excel functions into your SAS programs.
Have you adopted use of Microsoft Office 365? How has working "in the cloud" affected your integration with SAS applications? SAS product management wants to hear from you.
Here in the SAS Performance Lab, we’re seeing more and more SAS sites moving their SAS® 9 application workloads to Windows Server 2012. Now that we’ve had sufficient time to gather feedback from early implementers of SAS on these systems, we thought you might want a recap of some of
It's true: you can use the Microsoft Visual Studio Express tools to build custom tasks for SAS Enterprise Guide and the SAS Add-In for Microsoft Office. And I said as much in my book, Custom Tasks for SAS Enterprise Guide Using Microsoft .NET. I even provided step-by-step instructions for how
As part of my follow-up to SAS Global Forum 2013, I've posted a few articles about how to create your own client apps with SAS Integration Technologies. This article shows how to use Microsoft .NET -- the same approach used for SAS Enterprise Guide and SAS Add-In for Microsoft Office
Recently I've made several online purchases buying eBooks for the new Amazon Kindle my daughter received as a holiday gift. The online checkout process is very straight-forward, especially with the 'Continue' buttons that change to a 'Place your order' button on the final step. Did you know that the same
When upgrading from an existing 4.2 client install of SAS Add-in to MS Office, you are not prompted to enable the Outlook portion of the Add-in. As SAS points out in the KB Post http://support.sas.com/kb/40/272.html, there is a 'Switcher Utility' available in the client install. When running this, I would
The content for this post comes from David Henderson, lead software developer for the SAS Web Parts for Microsoft Sharepoint. David talks about these and other ideas for SAS-Sharepoint integration in his SAS Global Forum paper. We are pleased to announce the availability of SAS Web Parts 1.1 for Microsoft
Two users yesterday claimed that during the SAS Add-In to Microsoft Office (AMO) installation, an error message appeared stating that Microsoft Office Products were still running on their machine. When looking at the task bar AND the Task Manager Applications window, only the Installshield was up. Workaround - choose the
Whether you like it or not, Microsoft Excel is still a big hit in the data analysis world. From small to big customers, we still see fit for daily routines such as filtering, generating plots, calculating items on ad-hoc analysis or even running statistical models. Whenever I talk to customers,
SAS Enterprise Guide(EG)で簡単にPythonなどオープンソース・コードを実行できる方法を紹介します。 １．オープンソースコード実行用タスク(OST)の概要 ２．事前設定 ３．EGでの使用方法 ４．AMOでの使用方法 １．オープンソースコード実行用タスク(OST)の概要 SAS Enterprise Guide（EG）は直感的なユーザインタフェース上で、マウスの簡単操作で、透過的にデータにアクセスし、様々な分析用タスクを活用し、データの準備から加工・変換、集計・分析、レポート作成に至る一連の作業をグラフィカルなフロー図として描き、実行することができるツールです。 一方、多くの組織ではPython, Rなど様々なオープンソースのスキルを持つデータサイエンティストが混在することが多く、こうしたオープンソース（OS）とのコラボレーションも必要になってきています。従来、EGとPythonなどOSと連携する際には、データでのやりとりが必要でした。例えば、EGで作成したデータをエクスポートし、OSユーザに渡して処理してもらうか、その逆か、になります。 都度このようにデータをやりとりするには手間と時間がかかりますし、データやPythonコードなどの管理も課題となります。こうした課題を解決する手段の一つとして、カスタムタスクを活用することができます。 カスタムタスク：EGには、数多くのタスク（データ準備用タスク、分析用タスク、など）が実装されています。このタスクは顧客ニーズに応じてカスタムで作成し、活用することができるようになっています。SASのサポートサイトからカスタムタスクを作成するためのテンプレートをダウンロードし、使用することができるようになっています。カスタムタスクの作成方法の詳細に関しては、次回のブログでご紹介します。 オープンソースコード実行用タスク(OST)：OSTはOpenSourceTaskの略で、EGカスタムタスクのテンプレートに基づいて開発されています。OSTを使用することで、EG上で簡単にPythonコードを実行することができ、GUIベースの簡単マウス操作でPythonコードを再利用し、EG上で、標準実装のタスクとOSTを活用し、連携してアナリティクス作業を完結することができます。これによって、様々異なる分析スキル（GUIユーザー、SAS言語ユーザー、OS言語ユーザー）を連携し、有効活用することが可能となります。また、この分析処理は自動化することも可能です。 次にPythonコード実行用のOSTの使用方法を紹介します。EGのバージョンは8.2を使用したものです。 ２．事前設定 ・Python環境の確認 まずSAS9サーバ側にPython環境がインストールされていることを確認してください。Pythonの環境がない場合は、PythonまたAnacondaなどPythonのruntimeをインストールする必要があります。 ・SAS9サーバーの設定 SAS9のSMC(SAS Management Console)を起動し、以下の画面を開きます。 「Environment Management」>「Server Manager」> 「SASApp」>「SASApp Logical Workspace Server」>「SASApp - Workspace」を右クリックし、「Properties」をクリックし 以下の設定でXCMDの実行を許可します。 「Options」タブ >「Advanced Options」>「Launch Properties」で「Allow XCMD」をチェックし、「OK」をクリックします。 設定を有効するにはシステムのObject Spawnerのサービスを再起動する必要があります。 ・OSTパッケージの取り込み OSTパッケージをダウンロードし、展開したCustomフォルダをEG(またAMO)のインストール先（以下画面ショットのロケーション）にコピーします。そのほか、臨時ファイル保存と作業用フォルダC:/Customを作成し、準備作業が完了です。 これで、OSTが使用できる状態になります。 ３．EG上の使用方法 まず EGを起動し、処理対象データを選択します。今回はSASHELPライブラリ内にある「CLASS」を選びます。データを選択した状態で、タスクリストのSAS
One of the features of SAS Grid Manager (and SAS Grid Manager for Platform) introduced in SAS 9.4 M6 is the capability for the grid provider software to handle open-source workloads in addition to traditional SAS jobs. In this post, we’ll take a look at the steps required to get your SAS Grid Manager environment set up to utilize this functionality, and we’ll demonstrate the process of submitting Python code for execution in the SAS Grid.
In seinem Gastbeitrag stellt Metacoda sechs nützliche kostenfreie Tools zur Metadatenanalyse vor. SAS Platform-Administratoren, die mit der SAS Management Console arbeiten, kennen die potenziellen Hürden beim Thema Metadatenanalyse und beim Zugriff auf Coding-Benutzeroberflächen. Aber diesen Herausforderungen ist nun dank Metacoda beizukommen – mit sechs kostenfreien Tools. 1. Metadata Explorer
Last week I described how to use PROC IOMOPERATE to list the active SAS sessions that have been spawned in your SAS environment. I promised that I would share a custom task that simplifies the technique. Today I'm sharing that task with you. How to get the SAS Spawned Processes
If you're a SAS administrator, you probably know that you can use SAS Management Console to view active SAS processes. These are the SAS sessions that have been spawned by clients such as SAS Enterprise Guide or SAS Add-In for Microsoft Office, or those running SAS stored processes. But did
I returned to work from a 2+ week vacation this morning. When I fired up SAS Enterprise Guide (as I do each work day and occasionally on weekends), I was greeted with this message: As a SAS insider, I knew this was coming. It's a new feature that was added
If you have not yet discovered the new Ask the Expert series on the SAS Training site, you are missing out on a treasure. Visit the site right now and review all of the available topics, from "Newbie" to Analytics to Visualization to good ol' SAS programming. Go on; I'll
To develop a custom task for use in SAS Enterprise Guide (or SAS Add-In for Microsoft Office), you need a few things: A working knowledge of SAS and SAS Enterprise Guide Microsoft Visual Studio (the free Express edition will do, though the Professional edition is better) Some experience with C#
Hello, 1992 called. They want their DDE Excel automation back. Perhaps the title of this article is too pessimistic. Of course your SAS programs that use DDE (dynamic data exchange) can still work perfectly, as long as you situate your SAS software and its DDE "partner" (usually Microsoft Excel) to
To thousands of end users around the world, SAS® Enterprise Guide is a productivity tool for data management, analytics, reporting and SAS programming. As many features as SAS Enterprise Guide offers, these still represent just a fraction of what people can do with SAS. That's why a growing number of
Most organizations enjoy a plethora of SAS user types—batch programmers and interactive users, power users and casual—and all variations in between. Each type of SAS user has its own needs and expectations, and it’s important that your SAS Grid Manager environment meets all their needs. One common solution to this
This probably won't surprise any of my regular readers: "SAS custom tasks" is one of my favorite topics to talk about. Since 2007, I've written blogs about how you can use custom tasks to extend SAS Enterprise Guide and the SAS Add-In for Microsoft Office. I've shared lots of examples,
SAS Global Forum starts for me in the fall of the prior year. This is when you submit your ideas for papers and then wait patiently for many months to learn if it was selected. I enjoy writing and presenting ideas, so here are my topics and what inspired them.
Recency, Frequency, and Monetary Analysis (or RFM) is a popular customer segmentation technique employed by database marketers everywhere. Marketers use RFM to identify which customers are most likely to respond to a direct marketing campaign. The model takes into account three simple metrics: How recently did the customer buy from
Microsoft Windows 8 has been with us for a year, and its first major update -- Windows 8.1 -- has just arrived. So how does SAS support these Windows 8 platforms? The answer can be found on support.sas.com in SAS Note 46876. I'll summarize it here: SAS 9.3 and SAS
Have you seen Lego sets for young children? Not the ones with elaborate schematics and tiny complex pieces which require two engineers to put together. I am talking about sets that come with windows and doors for houses; wheels and seats for cars; flowers, plants, and trees for gardens; animals
