About Oleg_L

Oleg_L · ‎03-28-2012

Tom, I tried your code. No success. I suppose that your code adds '0D'x (CR) to the end of text lines. It does not replaces embedded '0D'x (CR) with '|'. Oleg.

Oleg_L · ‎03-28-2012

Tom, the embedded line breaks include '0D0A'x and the lines end with '0A'x Oleg.

Oleg_L · ‎03-27-2012

Thank you very much for your help. It works. I removed the line from your code: if eof then stop; Oleg.

Oleg_L · ‎03-27-2012

Tom, how can i determine that? I suppose that description field was wrapped by entering Alt+Enter in the system where data was generated. I see that wrapped lines contain square symbol. I don't know how to explain this more definitely. Oleg.

Oleg_L · ‎03-27-2012

OS2Rules, thanks for your advise. I find a solution by using your code, retain and scan function. Oleg.

Oleg_L · ‎03-27-2012

Art, i can not attach the copy of the file here. The information is confidential. OS2Rules: thanks for you reply. I'll try your approach. Oleg.

Oleg_L · ‎03-26-2012

Tom, thanks for your reply. The version of SAS is 9.2 under Windows server 64x. Files were generated on my PC workstation under Windows XP from Business Objects query and saved through Business Objects interface on my PC. If i use default option TERMSTR then i have errors in a few records only (where records are wrapped). Oleg.

Oleg_L · ‎03-26-2012

Hello SAS-users. I have to import a lot of .csv files to SAS dataset. The csv delimiter is Tab ('09'x). The files were imported from a Business Objects query. Some records are wrapped to two strings in csv files (by Alt+Enter in a description character field). How can i import these files correctly with infile statement? I use SAS EG 4.3 under Windows server. I've tried option termstr="crlf" but the output dataset contains no observations in this case. The log is below: 14 data test; 15 infile "\\sasabm01.region.vtb.ru\UOLib\PLI_FX\Input\2012\Loans_cnt\MSK_20120201_20120215.csv" 16 firstobs=2 dlm='09'x dsd truncover encoding='utf-8' termstr="crlf"; 17 informat dt ymddttm19. debet $20. credit $20. sum_rur commax17. txt $100.; 18 input dt -- txt; 19 run; NOTE: The infile "\\sasabm01.region.vtb.ru\UOLib\PLI_FX\Input\2012\Loans_cnt\MSK_20120201_20120215.csv" is: Filename=\\sasabm01.region.vtb.ru\UOLib\PLI_FX\Input\2012\Loans_cnt\MSK_20120201_20120215.csv, RECFM=V,LRECL=1536,File Size (bytes)=1434841, Last Modified=26Mar2012:11:37:42, Create Time=26Mar2012:12:06:55 NOTE: 0 records were read from the infile "\\sasabm01.region.vtb.ru\UOLib\PLI_FX\Input\2012\Loans_cnt\MSK_20120201_20120215.csv". NOTE: The data set WORK.TEST has 0 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds Memory 22971k OS Memory 33096k Timestamp 26.03.2012 14:58:41 I've also tried termstr=crlf (without quotes) but this cause an error: ERROR: Invalid string. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase.

Oleg_L · ‎03-14-2012

proc transpose data=have out=want; by column1; var column2 column3; run; Regards, Oleg.

Oleg_L · ‎09-16-2011

Thank you Jonam. I will investigate your documentation. Oleg.

Oleg_L · ‎09-16-2011

Thanks for your reply Ksharp. But i can not open your link. Oleg.

Oleg_L · ‎09-16-2011

Hello SAS-users. How can i read .htm files into SAS dataset? Is it possible? Now I save .htm files as Excel and use proc import. Is it the only way? I use SAS 9.2 Thanks in advance. Oleg.

Oleg_L · ‎08-31-2011

Thanks for your reply. There is no SAS PC Files Server at my workstation. I use EG 4.3 What should i do? Windows Service The server can be manually set to run as a Windows service. To run as a Windows service, select Start Control Panel Administrative Tools Services. Locate SAS PC Files Server in the Name column. Select Properties.

Oleg_L · ‎08-31-2011

What is "SAS PC Files Server"? Where can i find it? For Microsoft Access files, you must use the SAS PC Files Server, as shown in these examples: proc import dbms=accesscs out=sas-data-output-filename replace table='accessmdb-table-name'; port=8621; server="server-name.company.com"; database='\directory\filename.mdb'; run; proc export data=sashelp.shoes outtable='accessmdb-table-name' dbms=accesscs replace; database='\directory\filename.mdb'; server="server-name.company.com"; port=8621; run;

Oleg_L · ‎08-31-2011

Hello EG-users. I use proc import to import Excel 2003 files. Data contains cyrillic characters. After importing XLS to SAS dataset cyrillic letters are being convert to some other simbols (readable or unreadable). Some cyrillic letters become latin letters or digits. How can i import Excel files without this issue and save original cyrillic characters? Thanks in advance. Oleg.

Online Status	Offline
Date Last Visited	‎07-05-2019 07:24 AM

transposing data

Re: How to export large number of variables to csv without wrapping th...

Re: How to export large number of variables to csv without wrapping th...

Re: How to export large number of variables to csv without wrapping th...

Re: How to export large number of variables to csv without wrapping th...

Re: How to export large number of variables to csv without wrapping th...

How to export large number of variables to csv without wrapping the li...

Re: Need to save excel with password

Re: Anyone know how to use the IRR function?

Re: Anyone know how to use the IRR function?

Re: How can I read data with header from the file

Re: SQL Update - Updating a table with corresponding values in a secon...

Re: Import only specified columns from excel sheet

Re: joing tables using PROC SQL

Re: Rename

Problem reading csv files. (Some records are wrapped).

Re: Problem reading csv files. (Some records are wrapped).

Problem reading csv files. (Some records are wrapped).

Problem reading csv files. (Some records are wrapped).

Problem reading csv files. (Some records are wrapped).

Problem reading csv files. (Some records are wrapped).

Problem reading csv files. (Some records are wrapped).

Problem reading csv files. (Some records are wrapped).

make columns different

Read .htm files into SAS dataset

Read .htm files into SAS dataset

Read .htm files into SAS dataset

PROC IMPORT DBMS=ACCESS

PROC IMPORT DBMS=ACCESS

Importing XLS files with cyrillic characters data