Thanks, all
The last two are options for setting the Oracle login in the .profile of a production UNIX ID instead of hardcoding it in multiple shell scripts. Whether it's good practice or not, I don't know.
I'm looking for environment shell variables to be created within my .profile that would provide the user ID and password for the Oracle instance on that server.
These would be in additon to ORACLE_HOME and ORACLE_BASE. I seem to remember having these at a previous job a few years back.
Then...
Problem Description:
I inherited a job stream consisting of ten fastload jobs. They all have the logon hardcoded at the beginning. I would like to import the logon statements using .RUN but get the following unexplained error :
= FASTLOAD UTILITY VERSION 07.05.00...
A group of users maintains tables in a database with a limited disk space ...
Is there a way to determine the absolute and/or relative amounts of disk space each table is taking up within the database ?
Hopefully there's an SQL based solution.
Thanks
I know that there is a SAS ODBC driver that would allow applications such as Excel and Queryman to read a SAS dataset using SQL syntax.
You would need to use the documentation from SAS Institute to set this up. Don't know how complicated that is. Good luck.
Aside from performance times, you won't always get the same result from proc SQL, merge.
If there are duplicate values in the fields you are joining/merging on for more than one fo the datasets, proc sql will provide the more predictable result.
I have an HTML page that uses javascript to open a Java applet in a full sized new window. That's all it does. After the new window opens, I would like the parent window to go back to the previous URL.
Is there a JavaScript function that accomplishes the same thing as the browser back button ?
Mike,
Try to use a pipe filename statement with the dos 'SET' command. You will return info about system variables to a data step and then can parse out the ones you want :
filename env pipe 'set';
data _null_;
infile env;
length vars $ 500;
infile env lrecl=2000;
input vars &;
varname =...
I will assume you are running PC SAS and the data needs to come back to you PC.
Does the mainframe have SAS installed? Can you remote connect to it? If so then track down a mainframe SAS program that connects to the database and retrieves data using a pass thru query. Remote connect to the...
Create and test a file DSN to access your teradata database. From excel, choose data-> get external data-> new database query and select the name of the DSN you just created. Follow the prompts to create and run a query. After you have that working, start recording an excel macro and repeat the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.