topic Incorrect values is datasets imported from CSV. in SAS Procedures

Incorrect values is datasets imported from CSV.

sankarasarma — Mon, 06 Oct 2014 17:41:40 GMT

Hello,

I am a newbie to SAS and I am trying to import a CSV file into SAS Dataset . The import was successful. However the format of 16 digit long numeric values are represented as exponential values in SAS observations(TranID, CreditCardNo) in a particular datset. So can you please let me know how to view TranId, CreditCardNo as a normal 16 digit number in SAS Tables.

Thanks,

Sankar.

Re: Incorrect values is datasets imported from CSV.

art297 — Mon, 06 Oct 2014 17:48:36 GMT

Import those two fields as character variables with a length of 16. If you used proc import, modify the code that it produced (which should be shown in your log).

Re: Incorrect values is datasets imported from CSV.

ballardw — Mon, 06 Oct 2014 17:52:34 GMT

Are you going to use those for computation such as total TranId or average TranID? If not import them as character. If you imported them using proc import it makes a guess as to the data type something should be and if all digits then assumes they are numeric. Which will have issues with many ID values. Besides the appearance which is just the display format associated but numeric precision means that 16 digit numeric are not likely to be accurately stored.

Proc import, guessing that is what you used, will generate SAS datastep code that can (and often should) be modified to control import and display format. It is likely that you would see lines like:

informat TranID best16. ; Change them to informat TranId $16. ;

Re: Incorrect values is datasets imported from CSV.

sankarasarma — Tue, 07 Oct 2014 16:39:13 GMT

Thanks for providing the solution ballardw. Its Working now :smileygrin: