SandorSzalma Tracker

Re: How do I log on google account in SAS program

SandorSzalma — Fri, 17 Jul 2015 07:43:15 GMT

Hello Alonzo,

https://developers.google.com/maps/documentation/directions/intro#RequestParameters

According to this you should use your API_KEY (and not username/password) like this

filename x url "http://maps.googleapis.com/maps/api/directions/xml?origin=&p1&destination=&p2&key=API_KEY"

Regards,

Re: JRE

SandorSzalma — Thu, 21 May 2015 07:56:26 GMT

SAS Management Console, SAS IML Studio uses per default the private JRE delivered by SAS.

In some cases SAS uses the standard JRE installed on the PC.
For example SAS Enterprise Miner thin client which can be launched via Java Web Start.

With us SAS EM 12.1 thin client (which comes with SAS 9.3 TS1M2) works with Java JRE 1.8 Update 31.

Re: SAS Remote Library Invisible Datasets

SandorSzalma — Thu, 03 Apr 2014 12:49:29 GMT

Hi bnarang,

you use ODBC connection defined on the SAS server.

Maybe you should have a look on it. (odbc.ini). Do you access an Oracle database?

If yes, ask your SAS-administrator to change the username to uppercase.

You can define schema with your libname statement, too:

libname abc odbc dsn = "xxx" schema = "YYY";

It is important to use uppercase schema-name with odbc connection for Oracle.

Hopefully it helps.

Regards,

Sándor

Re: Extract large numbers from Oracle using EG Query Builder

SandorSzalma — Tue, 29 Jan 2013 12:32:40 GMT

Hi,

with EG 5.1 it is possible to format a numeric column to a string:

proc sql;

create table work.xxx as

select t1.id format=$CHAR25.

from db.tb1 t1;

quit;

Regards,

Sándor

Re: deployment wizard launches on reboot after install

SandorSzalma — Tue, 29 Jan 2013 11:57:46 GMT

Hi,

If I were you, I would identify the missing third party components and install them before the SAS installation.

Regards,

Sándor

Re: How to access Oracle data residing in separate schemas in SAS?

SandorSzalma — Wed, 19 Dec 2012 13:11:14 GMT

ncsthbell,

I say only that you do not need 3 database connections (usernames/passwords) if you have everything in one database.

After the execution of this SQL-script, you can manage in your SAS-program the Oracle connections (only) with your access.

Regards,

Sándor

Re: How to access Oracle data residing in separate schemas in SAS?

SandorSzalma — Wed, 19 Dec 2012 12:36:52 GMT

If you have all data in one database, your Oracle user can get select grants to the objects in the two other schemas.

(--select 'GRANT SELECT ON SCHEMA_1.' || table_name || ' TO YOUR_ID;' from all_tables where owner='SCHEMA_1'; )

you can use your user in the libname statements: (same like from Hai.Kuo)

libname schema_my oracle path=db schema=my authdomain=authmy;

libname schema_1 oracle path=db schema=one authdomain=authmy;

libname schema_2 oracle path=db schema=two authdomain=authmy;

proc sql;

connect to oracle (

authdomain=authmy path=db"

);

create table my.myTable as

select

from connection to oracle(

select * from one.TableName

);

disconnect from oracle;

quit;

Re: Proc Mixed fails to compute because of memory

SandorSzalma — Thu, 13 Dec 2012 16:05:45 GMT

maybe you need a hotfix?

48126 - PROC MIXED might issue the message "integer overflow on computing amount of memory required" unnecessarily

Re: "winscp" to transfer data from server to local drive

SandorSzalma — Thu, 13 Dec 2012 09:35:07 GMT

we use winscp only with Unix servers.

having SAS running on Windows server, I would create a share on it and map this share on my pc.

Re: "winscp" to transfer data from server to local drive

SandorSzalma — Tue, 11 Dec 2012 14:38:31 GMT

Hi,

usually you can use putty, winscp without changing anything on the unix server.

(SSH-connection is per default enabled (port 22) and preferred.)

Regards,

Sándor

Re: EG 2 Expiration

SandorSzalma — Tue, 04 Dec 2012 09:56:23 GMT

"If you think an upgrade won’t be feasible, contact Technical Support (support@sas.com) and they can help you through your options."

Re: Introduction, EG + Oracle + recursive programming

SandorSzalma — Tue, 04 Dec 2012 08:46:49 GMT

Hi,

You can access an Oracle database via SAS/ACCESS Interface to ODBC, too.

ODBC driver for Oracle is needed, ODBC-connections have to be defined.

SAS server, Oracle Client, ODBC-driver must be the same flavor: 32-bit or 64-bit (and not mixed).

You might want to have a look on Oracle SQL Developer, too.

Here you can read about recursive programming:

Recursion (computer science) - Wikipedia, the free encyclopedia

Sándor

Re: chmod: can't access / Unix_SAS / Autosys

SandorSzalma — Mon, 03 Dec 2012 09:20:39 GMT

Hi Ranny,

AFAIK there is no X: drive on Unix.

A file on Unix filesystem looks like this: "/hotest/folder1/folder2/filename.csv"

Regards,

Sándor

Re: excel to SAS dataset in UNIX

SandorSzalma — Mon, 03 Dec 2012 08:36:26 GMT

does this U: drive point to a shared-filesystem on the Unix server, where SAS runs?

(Samba-Share?, U:\ -> SAS_Server:/xx/yy)

If yes, you can use PROC IMPORT without PC File Server, too.

Re: excel to SAS dataset in UNIX

SandorSzalma — Fri, 30 Nov 2012 08:19:14 GMT

Hi,

you should give a try with PROC IMPORT.

It supports Export/Import with XLS, XLSX files on Unix Platfrom, too.

(SAS OnlineDoc: PROC IMPORT, Supported Data Sources and Environments)

Regards,

Sándor

Re: Converting from 64 bit to 32 bit SAS

SandorSzalma — Tue, 27 Nov 2012 14:22:29 GMT

you can use SAS 9.3 32-bit on Windows 7 64-bit, too..

Re: Where are the prompts located?

SandorSzalma — Tue, 27 Nov 2012 07:45:24 GMT

Hi,

Do you really need prompts?

With SAS Server & SAS Metadata Server you could create authentication domains for logins.

with SAS local without SAS Metadata Server you could create file with libname statements with encrypted passwords.

Do you share a technical user in the database, you can share the file, too.

Do you have your own user in the database, you can put the file on your own drive.

(Here we all have our private H: drive, I would put the file there.)

Regards,

Sándor

Re: SAS Deployment software Licensing issue

SandorSzalma — Thu, 22 Nov 2012 11:18:49 GMT

Hi,

your boss should ask for a new SID file with SAS 9.2...

Regards,

Re: How can I start JBOSS dependant on SAS BI on UNIX?

SandorSzalma — Tue, 20 Nov 2012 11:39:51 GMT

Hi Paul,

we develop SMF services for our applications (like SAS) running on Solaris.

It is easy to manage local dependencies among the SMF services.

Regards,

Sándor

Re: many sas processes in LCK/sleep state

SandorSzalma — Mon, 19 Nov 2012 13:50:22 GMT

Hi,

nohup writes an output file, nohup.out, do you have the input SAS-files in one folder?

Your Solaris-admin should be able to tell you the reason of the locks. (prstat -mL, plockstat, mount options)

In the command line, together with the input file (-sysin), -noterminal, -nonews I would define logfiles (-log) and outputfiles (-print) , too.

SAS Help: Optimizing SAS I/O can give you some hints, too.