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

sonmicAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.