topic Re: changing place for variable from one place to another place in SAS Enterprise Guide

changing place for variable from one place to another place

sas_9 — Thu, 21 Mar 2013 15:51:31 GMT

Hi all, i have one variable name 'empsal' in middle of dataset (have around 9000 variable and 'empsal' is there in between) and i wants to bring it as second or first variable/column,- how can i do that?

plz help

thanks.

Re: changing place for variable from one place to another place

SASKiwi — Thu, 21 Mar 2013 19:05:59 GMT

Just add an ATTRIB statement before you read your dataset to make it first:

data new;

attrib empsal length = 8;

set old;

run;

If you want it second then add the variable you want first before empsal in the ATTRIB statement.

Re: changing place for variable from one place to another place

sas_9 — Thu, 21 Mar 2013 19:26:57 GMT

worked prefectly - Thanks SASKIWI.

one quick q, i have 'empsal' variable as employee name and salary,

e,g;

empsal

harstein1 150000

lawson2 120000

kumar3 50000

i want to keep salary only (150000, 120000, 50000) and remove (harstein1, lawson2, kumar3).

result would be;

empsal

150000

120000

50000

can you plz tell me how code should look like?

Thanks!

Re: changing place for variable from one place to another place

SASKiwi — Fri, 22 Mar 2013 04:16:31 GMT

If it's consistently always two words then you could do it this way:

empsal = scan(empsal,2);

However wouldn't it be better to store empsal as a number:

empsal_num = input(scan(empsal,2), best12.);