About 4john

4john · ‎07-11-2011

Thanks SASjedi.It really helped.

4john · ‎07-09-2011

Hi, Below is a sample code that I have written.I am just wondering if there is any limitation on the number of values IN operator can hold.In the below example SELECT statement in step 5 holds more than 10000 ids. LOG file shows the ERROR : ORACLE prepare error: ORA-00972: identifier is too long 1 proc sql; 2 create table TEST as 3 select * from 4 oracle.sample 5 where id in ( select unique id from orcl.notice) ; 6 quit; Any inputs would be really appreciated. Thanks.

4john · ‎12-06-2010

Thanks Andreas.

4john · ‎12-01-2010

Is there a way to do it using call system or %sysexec ?

4john · ‎12-01-2010

all the .csv files are created on a PC and all have ANSI format.So before I read them into Unix SAS,I need to convert them into Unix format.Else,last variable is not getting populated properly.

4john · ‎12-01-2010

Can any one please suggest a way to convert multiple(>25) flat files in PC format to Unix format in SAS? Thanks

4john · ‎11-17-2010

I am using %sysexec with dos2unix to convert a .csv file created in PC format to an Unix file format. How can I convert multiple PC files into Unix file format using these same commands?(other solutions are welcome too) Thanks in advance.

4john · ‎11-05-2010

Hi, Is it possible to run a sas program (.egp file) developed in EG on a Unix SAS system? why is the sas syntax in .egp file(when exported to sas file) looks very different than the usual SAS coding? Thanks, John

4john · ‎09-29-2010

Thanks for the explanation Cynthia and Gary.

4john · ‎09-29-2010

I have a .egp file.Is it possible to open it in Unix SAS. Note: I do not have access to SAS Enterprise Guide. Thanks in advance.

4john · ‎09-29-2010

Thanks Gary.It worked. It would be very helpful if you can give a brief explanation of how $ symbol next to put statement fixed this issue. Thanks in advance.

4john · ‎09-27-2010

I have a dataset with sixty columns and 300 observations.I would like to create a tab delimited file with out the column variables in the first row. I used below code.But its creating a tab space at the beginning of the first column.Please suggest me a way to create a tab delimited without the variable names in the first row. data _null_; file "&fileloc/&outfile" lrecl=32760; set work.report; put (_all_)('09'x); run; Thanks in advance.

4john · ‎07-13-2010

I am accessing 2-3 million records from Oracle into SAS which is taking 4-5 hrs.Is there a way to increase the performance and reduce time.I guess,DB load and server load are causing this scenario. It takes 3.5hrs real time and 6min cpu time. Any suggestion would be great. Thanks, John

4john · ‎06-22-2010

I am working in a unix sas environment.I do batch submissions.But any ideas regarding time scheduling a batch submission would be great. os : solaris5 shell : korn shell sas : v9 Thanks

4john · ‎05-21-2010

Hi, i was trying to import a spreadsheet(excel 2003).but i am getting an error saying DBMS type EXCEL not valid. libname meds '/dat/sak/MDII/Reects/int/inient'; PROC IMPORT OUT= mes.rejan DATAFILE= "/dat/sak/MDII/Reects/int/inient/P.309.inp_01JAN09_31JAN09_0.1.xls" DBMS=excel REPLACE; GETNAMES=YES; RUN; Suggest me a way to import multiple spreadsheets into SAS datasets. Thanks.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

IN list operator limit (ERROR : ORACLE prepare error: ORA-00972: ident...

IN list operator limit (ERROR : ORACLE prepare error: ORA-00972: ident...

Re: convert flat files in PC format to Unix format

Re: convert flat files in PC format to Unix format

Re: convert flat files in PC format to Unix format

convert flat files in PC format to Unix format

%sysexec

Enterprise guide project file in Unix SAS

Re: tab delimited file without column header/names

Opening .egp file in Unix - SAS

IN list operator limit (ERROR : ORACLE prepare error: ORA-00972: ident...

IN list operator limit (ERROR : ORACLE prepare error: ORA-00972: ident...

IN list operator limit (ERROR : ORACLE prepare error: ORA-00972: ident...

Re: convert flat files in PC format to Unix format

Re: convert flat files in PC format to Unix format

Re: convert flat files in PC format to Unix format

convert flat files in PC format to Unix format

%sysexec

Enterprise guide project file in Unix SAS

Re: tab delimited file without column header/names

Opening .egp file in Unix - SAS

Re: tab delimited file without column header/names

tab delimited file without column header/names

data access from Oracle - performance issues

job scheduling in Unix SAS

importing excel 2003 spreadsheets into SAS