topic Re: Combining 3 columns into 1 excel file in SAS Studio

Combining 3 columns into 1 excel file

Granny — Sat, 23 Nov 2019 23:14:21 GMT

Trying to combine B1 B2 and B3 which list the same thing
In excel file, they are three different columns, trying to make it one.

B1 B2 B3

A2Ph J9GV U9Wr
J3Ik H5Hb H8sh
K8Pw J2Wn

Kind of like this

Grade Age FInitial Linitial

A2Ph
J3Ik
K8Pw
J9GV
H5Hb
J2Wn
U9Wr
H8sh

Also B3 has a no value for last cell, so how to account for that?

Re: Combining 3 columns into 1 excel file

PaigeMiller — Sun, 24 Nov 2019 00:07:01 GMT

Okay, so your title says you want 1 Excel file, but your text says you want one Excel column. Can you clarify?

Also B3 has a no value for last cell, so how to account for that?

That's very much up to you, how do you want to account for that?

Re: Combining 3 columns into 1 excel file

Granny — Sun, 24 Nov 2019 00:24:15 GMT

Excel column please! I want to import it to SAS and then make the three columns merge into one, but also delete the blank value

Re: Combining 3 columns into 1 excel file

PaigeMiller — Sun, 24 Nov 2019 00:29:24 GMT

Sorry, but I'm still not clear on what you mean.

I want to import it to SAS and then make the three columns merge into one, but also delete the blank value

You want to import it into SAS? Where is the data now? Text file? Excel file? SAS data set? Database? Other?

Why not import it into Excel and then re-arrange there? Why is SAS even necessary in this problem?

Re: Combining 3 columns into 1 excel file

Granny — Sun, 24 Nov 2019 00:44:11 GMT

I actually figured it out but thank you