Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

Import txt-file in SAS.

Hi,

When i use the code below a txt-file is imported. There is a numeric field (American notation) e.g. 23,000.00 that will be imported and the result is in my table 23.
How can i solve this. I need (European notation) 23.000,00.
Tx
PROC IMPORT 
	OUT       = certi 
	DATAFILE  = "inp" 
	DBMS      = TAB REPLACE ;
	DELIMITER = ";" ; 
	GETNAMES  = NO ; 
	DATAROW   = 1 ; 
RUN ;

Open in new window

0
sonmic
Asked:
sonmic
1 Solution
 
tobey1Commented:
This thread I think answers your question.

http://www.experts-exchange.com/Database/SAS/Q_26488249.html

If you cannot access that, then run the import, and look at import code in the SAS log.  Copy that code and change the informat (use commax##. or dollarx##.) for the field that you wish to import (American vs. European) then run that program instead of PROC IMPORT (same results) and now your data should be corrected.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now