topic Re: how to assign variables take from first record in SAS Programming

how to assign variables take from first record

thanikondharish — Fri, 07 Sep 2018 13:57:19 GMT

a1	a2	a3	a4	a5
name	age	sex	country	race
101	22	f	india	black
102	23	m	india	white
103	24	f	usa	black

take first record create as variable names like see below

name	age	sex	country	race
101	22	f	india	black
102	23	m	india	white
103	24	f	usa	black

Re: how to assign variables take from first record

RW9 — Fri, 07 Sep 2018 13:31:00 GMT

fix import

Re: how to assign variables take from first record

andreas_lds — Fri, 07 Sep 2018 13:38:25 GMT

There is no information about "race" in the first table ...

The name alone is not sufficient to create a variable, type and length are required, too. That information could be extracted for the variables a1-a4 from sashelp.vcolumn, so you don't need to provide it, if having all variables as character-vars satisfies conditions.

Is it really necessary to create new variables? Would renaming a1-a4 be ok?

Can you post the table as dataset using datalines statement, so that we have something to work with?

Re: how to assign variables take from first record

thanikondharish — Fri, 07 Sep 2018 13:50:31 GMT

i did by using import but how to do without using proc import

Re: how to assign variables take from first record

RW9 — Fri, 07 Sep 2018 13:51:28 GMT

datastep infile

Re: how to assign variables take from first record

Ksharp — Fri, 07 Sep 2018 15:00:45 GMT

proc import............;

getnames=yes;

run;