Date:         Thu, 19 Jan 2006 14:07:42 -0500
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: import csv file
Comments: To: Ran S <raan67@YAHOO.COM>

Ran,

After you run one proc import, copy the resulting code from the log, paste
it into the enhanced editor, modify (as desired) the field names which
were assigned by proc import (as well as any formats and/or informats you
might want to change), and then run the modified code.

Art
-------
On Thu, 19 Jan 2006 13:53:51 -0500, Ran S <raan67@YAHOO.COM> wrote:

>Hi,
>
>I am trying to import .csv file to SAS using following code:
>
>PROC IMPORT OUT= WORK.TEST
>            DATAFILE= "c:\..\***.csv"
>            DBMS=CSV REPLACE;
>     GETNAMES=YES;
>     DATAROW=2;
>     GUESSINGROWS=20;
>RUN;
>
>Its importing fine but the way variables are appearing is not easy to read
>lot of underscores... How can I also change the variable names or keep
>varables only 8 char long.
>
>I would appreciate your help.
>
>Thanks!