Hi there, Sounds trivial?  but I have been having problems reading files If I invoke the drop down fucntionality unders files -> import data and point to a location and try reading the files I have no problems and it generates the following code: DATA WORK.test_for_sas2;     LENGTH         name             $ 3         acc_no             8 ;     FORMAT         name             $CHAR3.         acc_no           BEST1. ;     INFORMAT         name             $CHAR3.         acc_no           BEST1. ;     INFILE 'E:\saswork\_TD7416\#LN00368'         LRECL=5         ENCODING="WLATIN1"         TERMSTR=CRLF         DLM='7F'x         MISSOVER         DSD ;     INPUT         name             : $CHAR3.         acc_no           : ?? BEST1. ; RUN; To me it seems that SAS internally copies the file to our SAS server (EG) and reads it in, but If i change the infile statement from above to  point to server location where I want to read from (for automation purposes) e.g. infile   '\\sdax.server.ca\sftp_read\file.csv'  it gives me an I/O error. I am stumped. This server location is an SFTP folder for our vendors to drop the csv. I want to automate the process of reading the files, but can't do so. Would you have an idea , how to read it in? I can't use windows shell command to copy (as this functionality in SAS EG is disabled and our admin won't allow this) the files to another location and read it in. BTW if I copy this file to our SAS EG server location and point to that location using infile statement, SAS works and reads the file, So I am guessing it is some sort of the settings on this folder /server which is preventing SAS to read. Please help ? Thanks, PD ... View more

Experts: I am facing a situation I have date in a format M/D/YYYY and this is a string. m stands for single digit month (i.e. 1 instead of 01 for Jan). d stands for single digit data (e.g. 1 instead of 01 for first day of themonth, YYYY - 4 digit year). Is there a way I can use rxchange or prxchange and look for single digit month & day and convert them to double digit. eg 7/07/2010 to 07/07/2010 or 7/7/2010 to 07/07/2010 or 10/1/2010 to 10/01/2010 Here's what I tried: DATA try; INPUT dt $CHAR40.; txt= prxparse( 's/(\d\/)/0\d\//'); text = prxchange(txt, -1, dt); DATALINES; 7/07/2009 ; result : dt txt text 7/07/2009 1 0\d/00\d/2009 Message was edited by: Pdogra ... View more

Hi there, I am wondering if there is any option or methodology available with proc sql to excecute multiple code for e.g. code Section a: proc sql; create table xyz as select .............. quit; code Section b: proc sql; create table abc as select .............. quit; The current way is code in section a will be executed and execution will passed to b. Is there a way to have code in section a and b run concurrently as there are no dependencies ? ... View more

I am hoping that you help me this issue: I a trying to create a table on Oracle server (Oracle 10 G) using proc sql: All I am doing is - Bringing data from Oracle Server A and passing it to Oracle server B (please see the code): Proc sql; create table crmrs133.sales as select subscriber_seq, address_seq,campaign_number, selling_group_code from m_owner.Sales_work_order where datepart(report_date) between '01mar2009'd AND '31mar2009'd ; QUIT; CRMRS133 : Oracle server where table sales is being created hosted on Unix box A. M_owner is another Oracle server on Unix Box B. Error I get is : NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: ORACLE execute error: ORA-01461: can bind a LONG value only for insert into a LONG column. WARNING: File deletion failed for CRMRS133.SALES.DATA. How can i resolve this issue. This code was run on PC SAS (not Unix SAS). ... View more

hi experts, We have this unique situation Our I.T. believes that we can connect to Unix from PC SAS using SAS connect (when no Unix SAS is installed on the Unix box). I know this is impossible as SAS Connect transforms the 2 sessions into client/server kind of set-up, but I still want to hear from the experts what do you think ? ... View more

Quick question . Is ther a way to connect to unix box from being on a unix box with SAS connect. i.e. I have SAS installed on AIX and HP and can i logon to AIX box from HP box ,the same way we normally do in PC Sas using SAS CONNECT files ---> tcpunix.scr file ? if yes could share an example with code please ? Regards PDogra ... View more