About Aj

Aj · ‎10-09-2017

Thank you @Reeza. Your inputs helped me to solve the problem. the DSN= should be the server DSN

Aj · ‎10-04-2017

Thanks @SASKiwi and you are right. I will notify you and @Reeza and also @ballardw when I am able to connect using Server DSN names instead of my local DSN names. I appreciate all of your quick responses.

Aj · ‎10-04-2017

Thank you very much @Reeza . you are correct. My SAS EG connects to a server and I am giving a DSN = <My local ODBC connection name> (CLARITY_CLONE). I have requested for the server DSN name. Hopefully, that would resolve the problem. Thanks again for think through it. I am not able to run it locally so I will wait to get the DSN name at the server for the requested database.

Aj · ‎10-04-2017

Thank you very much for checking on this Rezza. I tried it out without quotes and I get the same error. LIBNAME temp ODBC DSN=CLARITY_CLONE user=munjula pwd=XXXXXXXXXX; ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement.

Aj · ‎10-04-2017

Thank you very much for a quick look Ballard.Any inputs would be extremely helpful. Yes.I have added it to System DSN. Please see the attachment.

Aj · ‎10-04-2017

Any inputs would be very useful. I am not able to connect SAS EG 7.1 to SQL Server. I tried different syntax but nothing works, ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. My system is 64 bit. I am using SAS EG is 32 bit to connect to SQL Server. I have checked the ODBC connection to SQL Server (64 bit) which is successful. I tried connecting to SQL server using SAS EG 7.1 (64 bit) but no success. Codes I am trying: LIBNAME temp ODBC DSN='CLARITY_CLONE' user=XXXXX pwd=XXXX schema=CLARITY; libname mydblib odbc noprompt="uid=XXXX;pwd=XXXX;dsn=CLARITY_CLONE" stringdates=yes; proc sql; connect to odbc (dsn=CLARITY_CLONE user=XXXXX pwd=XXXX); create table test as select * from connection to odbc; quit ;

Aj · ‎10-04-2017

Any inputs would be very useful. I am not able to connect SAS EG 7.1 to SQL Server. I tried different syntax but nothing works, ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. My system is 64 bit. I am using SAS EG is 32 bit to connect to SQL Server. I have checked the ODBC connection to SQL Server (64 bit) which is successful. I tried connecting to SQL server using SAS EG 7.1 (64 bit) but no success. Codes I am trying: LIBNAME temp ODBC DSN='CLARITY_CLONE' user=XXXXX pwd=XXXX schema=CLARITY; libname mydblib odbc noprompt="uid=XXXX;pwd=XXXX;dsn=CLARITY_CLONE" stringdates=yes; proc sql; connect to odbc (dsn=CLARITY_CLONE user=XXXXX pwd=XXXX); create table test as select * from connection to odbc; quit ;

Aj · ‎10-04-2017

Any inputs would be very useful. I am not able to connect SAS EG 7.1 to SQL Server. I tried different syntax but nothing works, ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ERROR: Error in the LIBNAME statement. My system is 64 bit. I am using SAS EG is 32 bit to connect to SQL Server. I have checked the ODBC connection to SQL Server (64 bit) which is successful. I tried connecting to SQL server using SAS EG 7.1 (64 bit) but no success. Codes I am trying: LIBNAME temp ODBC DSN='CLARITY_CLONE' user=XXXXX pwd=XXXX schema=CLARITY; libname mydblib odbc noprompt="uid=XXXX;pwd=XXXX;dsn=CLARITY_CLONE" stringdates=yes; proc sql; connect to odbc (dsn=CLARITY_CLONE user=XXXXX pwd=XXXX); create table test as select * from connection to odbc; quit ;

Aj · ‎04-28-2016

Hi ballard, I tried your code and gave a lenth of $ 5000.But it doesn't copy the whole path. It stops at C:\Users. I tried it from different directory, but result is same. What do you think is the problem here. Thanks,

Aj · ‎04-26-2016

I have around 70 different files with same structure which have pipe delimeter. The structure is same and they are all text files with .txt.processed, .txt, .txt.orgi .txt.orgi as the type of the files. I was able to read the names of the files into a data set as mentioned by you. I can import all the files at once to a single dataset, using the code infile ('C:\path\*.log' 'C:\path\*.gti' 'c:\path\*.txt') . But i want to get the corresponding filenames from those files, added as a seperate column. I agree, the last suggestion is too complicated.sorry to confuse you 🙂

Aj · ‎04-26-2016

Hi Ballard, I have around 70 different files with same structure which have pipe delimeter. The structure is same and they are all text files with .txt.processed, .txt, .txt.orgi .txt.orgi as the type of the files. I was able to read the names of the files into a data set as mentioned by the User 'RW9'. I can import all the files at once to a single dataset, using the code infile ('C:\path\*.log' 'C:\path\*.gti' 'c:\path\*.txt') . But i want to get the corresponding filenames from those files, added as a seperate column.

Aj · ‎04-25-2016

Hi Can any one please help me to find a way to do the following: I have multiple files in a folder, of different formats (.tmp, .processed, .orgi) : I want to import them at all at once and do the following. 1. Code to read in just the file names in the folder. 2. Code to import the name of the file as a seperate column, along with the data in the file. 3. Code to read in the file name as the data set name for each file in the data.

Aj · ‎02-09-2016

This worked for me too. Thank you very much

Aj · ‎02-09-2016

Thanks ballard. I used the filename to get the names of all the files I imported.

Aj · ‎02-08-2016

1, I have multiple unstructured log files with different formats/Type of file i.e, : .log, .GTI, .txt files 2. I want to read them all into a single data step eg: file1.log, file2.GT1, file3.txt into a single data set. 3. I tried to import them using "infile 'C:filepath\*.log" but I will be missing the files from other formats. Is there a way to upload all of them at once?

Online Status	Offline
Date Last Visited	‎10-09-2017 02:39 PM

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: CLI ERROR to Microsoft ODBC Driver Manager SQL Server ODBC DSN Con...

CLI ERROR to Microsoft ODBC Driver Manager SQL Server ODBC DSN Connect...

Error Connecting SAS EG to SQL Server

Problems when connecting SAS EG to MS SQL Server databases

Re: How do I import the names of files (different types) in a folder a...

Re: How do I import the names of files (different types) in a folder a...

Re: How do I read multiple raw data files with different structure in ...

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: Problems when connecting SAS EG to MS SQL Server databases

Re: CLI ERROR to Microsoft ODBC Driver Manager SQL Server ODBC DSN Con...

CLI ERROR to Microsoft ODBC Driver Manager SQL Server ODBC DSN Connect...

Error Connecting SAS EG to SQL Server

Problems when connecting SAS EG to MS SQL Server databases

Re: How do I import the names of files (different types) in a folder a...

Re: How do I import the names of files (different types) in a folder a...

Re: How do I import the names of files (different types) in a folder a...

How do I import the names of files (different types) in a folder along...

Re: How do I read multiple raw data files with different structure in ...

Re: How do I read multiple raw data files with different structure in ...

How do I read multiple raw data files with different structure in one ...