topic Re: Combine two column in SAS Programming

Combine two column

Tejaswini3 — Sat, 19 Nov 2022 17:12:50 GMT

I want to combine petest and desc coloumn one below the other
E g ,
Abdominal
No
Yes
Cardiovascular system
No
Yes

Re: Combine two column

fja — Sat, 19 Nov 2022 18:45:56 GMT

Looks like stacking cols ... this is available as a point and click task in Studio under Tasks->Data->Stack/Split Columns.

Generates something like this:

data work.TestData;  
   input Col1$ Col2$ Col3 $;  
   datalines;  
A B C 
D E F 
; 
run; 
 
data work.__tmp__;  
	set WORK.TESTDATA;  
	_Case_=_n_;  
run;  
  
proc transpose data=work.__tmp__ out=work.TestOut(drop=_Label_   
		rename=(col1=StackedCol)) name=_Level_;  
	var Col1 Col2;  
	by _Case_;  
run;  
  
proc delete data=WORK.__tmp__;  
run;

Re: Combine two column

Kurt_Bremser — Sat, 19 Nov 2022 19:01:10 GMT

Should this be a report?

And do not post pictures of data. Ideally, post data step code (with DATALINES) to create a copy of your dataset.

Re: Combine two column

Tejaswini3 — Sun, 20 Nov 2022 03:48:43 GMT

Can you please write full code and let me know

Re: Combine two column

Tejaswini3 — Sun, 20 Nov 2022 03:49:54 GMT

Without transpose statement, pls write code to solve

Re: Combine two column

Kurt_Bremser — Sun, 20 Nov 2022 08:32:16 GMT

If you need someone to do your work for you, you should hire a consultant.

And you have neither answered my question, nor provided usable data.

Re: Combine two column

fja — Sun, 20 Nov 2022 20:45:25 GMT

@Tejaswini3 wrote:
Without transpose statement, pls write code to solve

Why is that? Than you needed to detail your problem a bit. ... let's say just to motivate people. 😉

Err ... being with it: My observation is that you keep on asking the same questions over and over (e.g. here and here ). You got answered there, though you have neither marked these threads as solved nor detailed what was missing to an acceptable solution. ... sooo, could you help us a bit, please?