topic Re: Command to know which scripts using which Data in SAS Procedures

Command to know which scripts using which Data

sasprofile — Thu, 05 Feb 2015 19:30:04 GMT

Hello,

Is there any command in SAS to check which scripts are using which library data

Is there anyway to check in Metadata level where the tables are getting used in script

or do we need to check all the scripts manually.

I would really appreciate for quick reply

Thank you

Re: Command to know which scripts using which Data

jakarman — Thu, 05 Feb 2015 19:52:13 GMT

Use APM for dynamic access analyses.

The static analyses for library access in classic code is very hard, almost impossible.

DI metadata (that is the real "code") has all kind of relationships as impact analyses.

On what kind of SAS are you asking?

Re: Command to know which scripts using which Data

sasprofile — Thu, 05 Feb 2015 21:58:05 GMT

Coming to my SAS Environment its SAS 9.2 on Salaris.

and what kind of program or command i have to run inorder know which scripts are using which Library data.

I mean can i run from enterprise guide whatever the command or pogram thats available ?

Re: Command to know which scripts using which Data

jakarman — Fri, 06 Feb 2015 08:45:42 GMT

So you can run SAS-scripting (programs) on Solaris. When you admins/sas people dislikes you they have closed it to that level (noxcmd).
If hey would trust you in you own environment you could run Unix-scritps (solaris) Groovy java Phyton and more of that kind of own build scripts (programs). It that xcmd setting as requirement for this. No problem when the setup is done running the WS on your personal key and the Unix is set up with security controls for isolating you not doing too much harm. Yep you could cause a heavy load and some are assuming that is a bad thing to prevent you doing that.

As you are using Eguide you are having some things on Windows and you could use scritps (powershell batch) or Windows tools there.

You did not mention DI studio so that kind of source is getting out of scope.

In the mainframe with standards of good programming practices all allocations (filename/libname) are not allowed to be in programs but are isolated in dedicated start/autoexec files. It is a requirement as result of segregations Develop Test Acceptance Production having executable code mot allowed to be changed in a change proces. As of your question you are not following this kind of good programming practice.

The question now where is the code (source version) located and how is the libname regonizable coded. There will be no 100% guarantee as the coding can be done to obfuscate these functions intentionally or unintentionally.

Your source is on Solaris in readable form. -> use Unix scan/find commands to find those strings in known locations.

Your source is within in Eguide -> this a zip file, use Zip scanners to find those statement in these files on Windows

Your source is stored in readable form on Windows -> you can uses Windows scanners to find those SAS statements

Your source is stored as Eguide project in SAS metadata (9.3). You are on a dead with other tools and SAS does not have anything.

Re: Command to know which scripts using which Data

sasprofile — Fri, 06 Feb 2015 18:14:22 GMT

Jaap Karman,

Thank you very much for the solution,I appreciate it.

We have an issue for users going on with SAS AMO 5.1 for past 1 week.

we are using SAS 9.2 on Solaris (Microsoft Excel 2010)

Our SAS AMO is published as an APP on Citrix server for all our users,so all our users are logging and accessing from citrix server to run their reports.SAS AMO is not installed on users machines.

couple of users have got a problem with SAS AMO,for the past 1 week they are not able to see SAS Tab on SAS AMO.
we trouble shooted it in several ways with all below options.

File menu--Options--Add-ins--Manage--COM Add-Ins and checked SAS Add-In 5.1 for Microsoft office.
we checked File menu--Options--Add-ins--Manage--Disabled items also.It looks Enable is greyed out
(There are no disabled items)

but still they could'nt see the SAS Tab,again followed same above steps to see COM-Add-Ins box i found
the SAS Add-In 5.1 for Microsoft office again unchecked.

I can see a runtime error at the bottom of the COM-Add-ins window

Load Behavior : Not loaded. A runtime error occured during the loading of the COM Add-in.

As per SAS Note I have installed on user machine VSTO component for above error and I had make sure that VSTO got installed in below location.but still the Issue is not resolved.

C:\Program Files\Common Files\Microsoft Shared\VSTO\10

Followed below sas webesite instructions for above error and downloaded and installedd VSTO component.

http://support.sas.com/kb/50/561.html

http://support.sas.com/kb/41/327.html

Please can you help me on this issue,I would really appreciate for your suggestions and help.

even sas support failed to provide proper solution on this

Thank you for all your help in advance

Re: Command to know which scripts using which Data

jakarman — Fri, 06 Feb 2015 18:57:18 GMT

I do not like the Citrix approach when that is not your standard desktop environment. For some reason SAS people are out of their mind for going into the confrontation with the major line of the ICT support and not wanting cooperation. Never mind you are having that situation. Trying to do a root cause analysis.

- Some users are working with the AMO so your basic approach is ok.

- No disabled items in the AMO menu-s so something other is missing.

- you checked the pre-reqs like VSTO. It is part of the deployment but could fail of wrong tests within the SAS-SDW.

There could be others as the SDW doe a check and when the MS-component is missing it will install those. The best option would be sure all pre-reqs are fullfilled

It could be something in the Windows registry being missing.

The easiest way to correct/verify that one is to use the switcher utility. 50822 - SAS® Add-In for Microsoft Office might appear in Outlook 2007 even if it was not selected during the installation process

Re: Command to know which scripts using which Data

sasprofile — Fri, 06 Feb 2015 20:39:16 GMT

Thanks alot Jaap Karman for your prompt reply

All the users are accessing the SAS AMO from Citrix,AMO is not installed on the users machines.

so there are is no file called Switcherutility.exe.

and if i import the registry file from the link you provided,does it replaces only the affected registrty files or all files will be replaced with completed new registry files.

Re: Command to know which scripts using which Data

sasprofile — Fri, 06 Feb 2015 20:40:18 GMT

sorry for typ errors

Thanks alot Jaap Karman for your prompt reply

All the users are accessing the SAS AMO from Citrix,AMO is not installed on the users machines.

so there is no file called Switcherutility.exe.

and if i import the registry file from the link you provided,does it replaces only the affected registrty files or all files will be replaced with complete new registry files.

Re: Command to know which scripts using which Data

jakarman — Sat, 07 Feb 2015 08:00:26 GMT

Your Citrix is a windows environment just like your local desktop.

At the Windows Citrix desktop the AMO is installed the switcher utility is part of the AMO installation and should be found at your Citrix Windows desktop.

IT is your WIndows Citrix desktop that is having issues/problems. Your Windows Citrix support guys should be the ones for solving this issue.

As far I knows that switcher utility is updating the current user registry settings not the ones of the local machine or all users.

The goal is being capable of having multiple versions of AMO on the same desktop with one Office version.

By that is must be capable of setting the user registry settings. You are knowing/understanding a little bit of Windows admin?

Re: Command to know which scripts using which Data

sasprofile — Sun, 08 Feb 2015 17:37:53 GMT

Jaap Karman,

Thank you so much for your reply

I have one doubt, When you are saying that siwtcherutility is part of the AMO installation which is installed on Windows Citrix desktop.

when AMO is kept on Ctrix desktop and when all the other users are able to see SAS Tab on SAS AMO why can't the other 3 users not able to see SAS Tab on same SAS AMO which is kept on Citrix Desktop.

When swicthherutilty is part of the SAS AMO which is on Citrix and updating those 3 users registry settings,then it should update all other users resgistry settings and it SAS AMO should not work to any users who are accessing AMO from citrix.why its not working for those 3 users and why its working for all other users.

I have informed Citrix team to install vsto component on Citrix server level where AMO is installed and if it wont work that way then i told them to run swictherutilit.exe in the next step.

Please suggest what should i do,Its been 10days the issue is not resolved.even sas is not able to provide proper solution for this.

Thank you

Re: Command to know which scripts using which Data

jakarman — Sun, 08 Feb 2015 19:03:14 GMT

The switcher utility is aimed to work at the running the user environment not the machine environment (Win registry). The VSTO version dll-s are working at the machine level.

Citrix deployment is done for all users at the at the machine sometimes there are failures to bring that to the user environment.
40591 - SAS menus do not appear in Microsoft Office programs when SAS® Add-In 4.3 for Microsoft Office is installed on 32-bit computers with Wow6432Node

35181 - Managing multiple installations of SAS® Add-In for Microsoft Office

SAS(R) 9.4 Intelligence Platform: Desktop Application Administration Guide, Fourth Edition (Manage Multiple Instances on a Single Host - AMO)

Re: Command to know which scripts using which Data

sasprofile — Sun, 08 Feb 2015 19:45:38 GMT

so according to you whatever the instructions i gave to Citrim team is that right or do i need to do something else to fix the issue.

I have informed Citrix team to install vsto component on Citrix server level where AMO is installed and if installing vsto compoenent wont work that

then i told them to run swictherutilit.exe in the next step at Citrix server level.

please let me know whether i did right or do need to do something else

Re: Command to know which scripts using which Data

jakarman — Mon, 09 Feb 2015 06:33:45 GMT

The citric team can run that command, they do not have the user/password of your users do they?

So how would they run that command in the session of your user. (?) runas could be an option (asking password when not domain admin)

Re: Command to know which scripts using which Data

sasprofile — Mon, 09 Feb 2015 20:30:22 GMT

Why Citrix team needs user id/pwd,Citrix desktop environment is under control of Citrix team.

and they can simply go to the below switcherutility location and can run the command right in their Windows Citrix Deskptop environment.

C:\Program Files\SAS\x86\SASAddinforMicrosoftOffice\5.1\SwitcherUtility.exe

and also I am really confused which user id/pwd you are talking about.

Re: Command to know which scripts using which Data

jakarman — Mon, 09 Feb 2015 20:39:26 GMT

Your citrix is a windows environment offering windows desktops.
When you have a windows desktop you are doing a login with your personal key and personal password.
Your Windows admin has a dedicated admin-user to control that environment creating the personal keys and personal passwords.

I cannot imagine windows environments working in some other approach.

The Citrix guys are doing that in a same way. What is confusing with that?

Yes there are many Windows desktops introduced that is confusing. It started to say they got out of their mind with that.

Re: Command to know which scripts using which Data

sasprofile — Mon, 09 Feb 2015 21:13:39 GMT

All the users will be connecting to Citrix with their own user/pwd and once they login they will launch from citrix whatever the app they want

like SAS AMO, SAS Enterprise guide.

so now Citrix team have to run the SwitcherUtility.exe on the Windows server itself where the Citrix Desktop has been kep right at below location.

C:\Program Files\SAS\x86\SASAddinforMicrosoftOffice\5.1\SwitcherUtility.exe

Re: Command to know which scripts using which Data

sasprofile — Mon, 16 Feb 2015 15:21:08 GMT

Jaap karman,

am not able to find any script or code to use to run in Unix machine or EG to find out which are all the scripts using which Libraries Data.

by any chance do you have any idea what is that code to find that.

please help me

Thank you

Re: Command to know which scripts using which Data

jakarman — Mon, 16 Feb 2015 19:19:11 GMT

There are just some commands doing that. The names of those (files and grep) egrep(1): print lines matching pattern - Linux man page (output with filename/linenumber)

xargs - Wikipedia, the free encyclopedia en you will find a lot on those like The Joys of xargs - xargs and find - Tutorials - LinuxPlanet You will have to go for searching the "libname" string.

Remember it could be have hidden some things as it is not in the code maybe elsewhere.

Re: Command to know which scripts using which Data

sasprofile — Thu, 19 Feb 2015 23:59:58 GMT

SAS EG-Data Grid Error

An unexpected error occured while attempting to read the data values.Do you wish to retry or cancel ?

System.IndexoutofRangeException: Index was outside the bounds of the array.
at SAS.EG.DataAccess.DataModel.DmSasRioPageBuffer.Populate(Int32 startingRecordNumber,DataAccessor dataAccessor,Double[,] numericColValues,String[,] characteColValues)

at SAS.EG.DataAccess.DataModel.DaForSasData.BufferData(Int32 startRecord,Boolean formatted,Double[,] numColValues,String[,] charColValues).

at SAS.EG.DataAccess.DataModel.DaForSasData.CommomReadPage(Int32 record,Boolean formatted,Int32 readFlags,Int32 offset,Byte[] positionBookmark,Byte[] & bookmarks,Int32& recordRead)
---------------------------
-----------------------
-----------------------

Error follows like this...did'nt typed complete error

When one of the user is trying to open a dataset from a oracle library he is getting below error.

When I tried to open the same dataset from my system, am able to open it without any problem.

I suggested user to run the libname statement of that oracle library from his system, but when he tried to run it has thrown below error

“ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied. ERROR: Error in the LIBNAME statement.”

When I tried to run the same libname statement from my system its running successfully without any error.

I preassigned that library and even I gave permissions to that user for that library and table. but still same error.

What could be the problem ? Any ideas

Re: Command to know which scripts using which Data

SASKiwi — Fri, 20 Feb 2015 01:11:03 GMT

I suspect the user does not have the right permissions for accessing the Oracle database but you do. Check with your Oracle DBA to confirm. Once your use is set up correctly re-try the LIBNAME.