Prev: IN - Option
Next: Weird naming convention with newfile=bygroup ?
From: Sdlentertd on 21 Jan 2010 16:10
When import csv file :

proc import datafile='file.csv'
out=newfile dbms=csv replace;
getnames=yes;
run;

this happens: column names appear in Row 1 instead of actual column
names (that are now Var1, etc...)..... how can I either import column
names so they appear as column names, or rename first row (values)
into column names
Thank you
From: Joe Matise on 21 Jan 2010 16:59
Getnames=Yes is the option to do what you're asking. I suspect your file
might have multiple header rows or something? Visually inspect your file,
see what it looks like and if there's anything that would cause it to not
read that first line in.

-Joe

On Thu, Jan 21, 2010 at 3:10 PM, Sdlentertd <sdlentertd(a)gmail.com> wrote:

> When import csv file :
>
> proc import datafile='file.csv'
> out=newfile dbms=csv replace;
> getnames=yes;
> run;
>
> this happens: column names appear in Row 1 instead of actual column
> names (that are now Var1, etc...)..... how can I either import column
> names so they appear as column names, or rename first row (values)
> into column names
> Thank you
>
 | 
Pages: 1
Prev: IN - Option
Next: Weird naming convention with newfile=bygroup ?