Hello! I am importing a space delimited txt file that has several columns, among them a column which contains budget prices written in the following format ($10,000,000). I want to import this file making sure that this column is treated as a numeric value. I wrote the following code, however when I print the code the values are incomplete and don't show the full value as provided in the source file. This is what is included in the source txt file. Numbers provided in this image include $1,344,000 ; $2,100,000 ; $2,000,000 ; $0 ; $1,400,000 . This is the code I made: DATA File; INFILE '/folders/myfolders/sasuser.v94/File.txt' DSD DLM=' ' FIRSTOBS=2; INPUT infodate :ANYDTDTE10. infotime infoyear info1 :$50. budget $ info2 info3 info4 info5 info6 info7; RUN; PROC PRINT DATA=File; RUN; I bolded the variable in question to make it easier for you to see what I did specifically. These are the outputs I got from the PRINT Output. NOTE: there is code I didn't include that actually ordered all the budget data from highest to lowest. Any and all help is appreciated! Thank you!
... View more