Are you using ACCESS to PC File Formats or to ODBC? Please show us your connection statement (whether it's SQL or LIBNAME). /Linus ... View more

This is not quite a MS Office question, is it? Nevertheless, there are no simple yes/no answer to this. If you got a typical query, try it out in both SAS and Oracle. To look behind the curtains a bit, you could use _method option in Proc SQL for SAS joins. MESGLEVEL=I will tell you if index is used for join optimization. debug=',,,D' sastraceloc=SASLOG will give you the Oracle SQL when doing implicit SQL pass.tru using LIBNAME ORACLE. /Linus ... View more

Could you be more specific about your client column? Pls give some examples of your 12 different values (which I assume exist for each client?). Without knowing these, I could only guess that you need to clean your client columns in prior to the merge. /Linus ... View more

I'm not so sure that it is SAS that behaves differently on different platform. It could be the encript application as well that behaves differently between platforms. Have you tested it with other applications than SAS? /Linus ... View more

DBLOAD is the old fashioned way. I doubt it would faster than using LIBNAME together with Oracle bulk load (which is enabled by using BULKLOAD= option). /Linus ... View more

This is not SAS support- It's a forum in which SAS users share problems and knowledge. I suggest that you submit this problem to SAS tech support, on this website: http://support.sas.com/ctx/supportform/createForm /Linus ... View more

One approach is to do a complete and separate SAS installation on the new server. Then use the metadata promotion/replication tool in the Metadata Server plug-in in management console. /Linus ... View more

No, you can not call a data step from within a proc sql You can read tables or views created by data steps. From 9.2, you can create your own functions, which you can call from proc sql. These functions a re created by data step like syntax, and are defined by PROC FCMP. /Linus ... View more

> - does the usage of "%abort return" work for the > given scenario or should I consider anything else? Abort will terminate the current SAS session. %include will run your jobs within the original session, therefore will your whole workflow terminate at abort return. > - is "%global F" sufficient to define it as a > variable available throughout B1 - B3? Yes, since it will be declared as global in the "whole" session (see above). /Linus ... View more

If you mean MS Access, you can use the tools in SAS/ACCESS to PC File Formats. See on-line doc for examples. /Linus ... View more

You can read B, and based on the information there, create a macro variable (CALL SYMPUT) that contains a KEEP list which can be used when reading A in the next step. /Linus ... View more

Concepts about SAS date and time: http://support.sas.com/documentation/cdl/en/lrcon/59522/HTML/default/a002200738.htm About reading date format from external databases (i.e. Oracle, SAS/ACCESS to RDBMS): http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a003113620.htm /Linus ... View more

Is this a SAS question? Or is it purely about UNIX file management? What do you mean by "data is derived"? You can use cat command to concatenate files. /Linus ... View more

After a little stroll around the net, I found that this seems to be a generic problems. Some of the suggested solutions are: -running as root (not recommended) -using printf together with telnet -using something called sudo (seperate package) -using somthing called expect package /Linus ... View more

Isn't it possible to call a script that in turn does the su command (and calls the restart spawner script)? /Linus ... View more