topic How do I put first and last name into one variable??? in SAS Programming

How do I put first and last name into one variable???

jsjoden — Mon, 25 Sep 2017 02:24:14 GMT

data statedata;

infile '\\Client\E$\SASData\StateData.txt'

delimiter = ' ' ;

input States $ Region $ Manager Visits d z k l m n i o g;

run;

libname state '\\Client\E$\Data';

data state.state_final;

set statedata;

run;

proc print data=state.state_final;
run;

It runs well/ however, in the first variable (states) there are states like new york and that add an extra space which throws everything off. So how do I in cases where there is spaces between the state names put them together in one in variable 1(states).

Please include it in my code. Been stuck on this forever. Thank you!

Re: How do I put first and last name into one variable???

SASKiwi — Mon, 25 Sep 2017 03:04:05 GMT

Not sure what your data looks like but I'm guessing you need an INFORMAT modifier for your STATES variable:

input States : $8. Region $ Manager Visits d z k l m n i o g;

Re: How do I put first and last name into one variable???

ChrisNZ — Mon, 25 Sep 2017 03:33:56 GMT

Since there are spaces in the first variable, how do you know where the second variable starts starts? You need another delimiter.

Either a comma, or two spaces.

& allows for single spaces in strings and waits for several spaces before reading the next variable, so may be this help.

Of course, you could have provided sample data to help us answer properly....

 
input STATE &: $16. REGION $ MANAGER VISITS D Z K L M N I O G;

Re: How do I put first and last name into one variable???

jsjoden — Mon, 25 Sep 2017 05:19:48 GMT

I attached screenshots of what I am getting. I want the second column for the words like north dakota etc. for the second word dakota to be put in the first colum ( so as one word). Thank you

Re: How do I put first and last name into one variable???

jsjoden — Mon, 25 Sep 2017 05:21:03 GMT

I attached screenshots of what I am getting. I want the second column for the words like north dakota etc. for the second word dakota to be put in the first colum ( so as one word).

Re: How do I put first and last name into one variable???

FredrikE — Mon, 25 Sep 2017 08:35:57 GMT

How about this? 🙂

data one;

infile '\\Client\E$\SASData\StateData.txt' delimiter='|';

length inputstr rinput $200 states region $32 visits x z y $8 pos 8;

input inputstr;

rinput = strip(reverse(inputstr));

y = strip(reverse(scan(rinput,1)));

z = strip(reverse(scan(rinput,2)));

x = strip(reverse(scan(rinput,3)));

visits = strip(reverse(scan(rinput,4)));

region = strip(reverse(scan(rinput,5)));

pos = indexw(strip(inputstr),region);

states = strip(substr(inputstr,1,pos-1));

run;

Re: How do I put first and last name into one variable???

ballardw — Mon, 25 Sep 2017 14:31:58 GMT

@jsjoden wrote:

I attached screenshots of what I am getting. I want the second column for the words like north dakota etc. for the second word dakota to be put in the first colum ( so as one word). Thank you

If you must attach screenshots please use an image format like PNG or JPEG. Microsoft documents are security risks and many users here will not open them for that reason or have organization policies and/or security software that blocks them.

Re: How do I put first and last name into one variable???

jsjoden — Mon, 25 Sep 2017 16:48:46 GMT

Thank YOU!!