How to convert the horizontal lines to vertical line?

ybz12003 — Tue, 18 Aug 2020 20:42:47 GMT

Hello,

I have a 'datain1' list below.

data datain1;
      infile datalines delimiter='/';
  input  Result1 : $100. Result2 : $100. Result3 : $100.;
datalines;
	ACUTE OTITIS MEDIA/ASTIGMATISM/CONSTIPATION
;
run;

I could like to convert result1-result3 into one column 'Name.' Please help me to approach it, thanks.

data dataout1;
      infile datalines dsd;
  input  Name : $200. ;
datalines;
	ACUTE OTITIS MEDIA,
	ASTIGMATISM,
	CONSTIPATION
;
run;

Re: How to convert the horizontal lines to vertical line?

novinosrin — Tue, 18 Aug 2020 20:51:53 GMT


data datain1;
      infile datalines delimiter='/';
  input  Result1 : $100. Result2 : $100. Result3 : $100.;
datalines;
	ACUTE OTITIS MEDIA/ASTIGMATISM/CONSTIPATION
;
run;

data want;
 set datain1;
 array t result1-result3;
 do over t;
  want=t;
  output;
 end;
 keep want;
run;

topic How to convert the horizontal lines to vertical line? in SAS Programming

How to convert the horizontal lines to vertical line?

Re: How to convert the horizontal lines to vertical line?