topic Re: Format in New SAS User

Format

Antoine44 — Thu, 03 Oct 2019 07:57:17 GMT

Hi everyone,

I'm trying to import a CSV file in SAS via clicking on 'file' then 'import data' but once the file is in SAS it gives me a different value.

How can I import a CSV file and keep the same values?

Thanks!

Re: Format

Kurt_Bremser — Thu, 03 Oct 2019 08:00:58 GMT

Write your own data step, and use that. With the automated helpers (either the import wizard of Enterprise Guide or proc import), changes in the data can (and will) cause unwanted changes in the structure.

If your original task runs a proc import, copy the data step code from the log, adapt (and simplify!) it is as needed, and use that in the future.

Re: Format

Kurt_Bremser — Thu, 03 Oct 2019 08:06:04 GMT

If values are imported wrongly, please supply example data from the csv file (use the [i] button for posting textual data), and tell us which column was incorrectly read.

Re: Format

Antoine44 — Thu, 03 Oct 2019 08:19:48 GMT

CSV file
RIC             Price         Volume
AEIS.O          14.07         1500

SAS file

RIC             Price         Volume
AEIS.O          1             2

Here's an example of what happens to an observation when I import the CSV file.

I don't use any particular code, I just use the import data function from the file menu

Thanks for your help!

Re: Format

Kurt_Bremser — Thu, 03 Oct 2019 10:14:12 GMT

Please show the REAL content of the csv file. It should look something like this:

RIC,Price,Volume
AEIS.O,14.07,1500

NEVER (and I mean never as in "not even when hell has frozen over so hard that the brimstone is superconducting") inspect a csv file with Excel or similar, as you will only see what Excel thinks of the data. Use a proper text editing/viewing tool, like notepad++.

Which import wizard do you use? That of Base SAS, SAS Studio, or Enterprise Guide?