topic Re: Removing line returns from SAS data file in SAS Programming

Removing line returns from SAS data file

nketata — Thu, 15 Jun 2017 16:17:46 GMT

Hello, How to get the file WANT starting from HAVE ?

data HAVE;

infile datalines truncover;

input var1 $200.;

datalines;

(S) Benefit

plans

(S) car

allowance

(S) Technology,

Economic Development Initiative

Motor allowance

(S) Small Business and Tourism

Agriculture

(S) Small Business

Financing Act

;

run;

DATA WANT;

format var1 $200.;

var1="(S) Benefit plans"; output;

var1="(S) car allowance"; output;

var1="(S) Technology, Economic Development Initiative Motor allowance"; output;

var1="(S) Small Business and Tourism Agriculture"; output;

var1="(S) Small Business Financing Act"; output;

run;

Re: Removing line returns from SAS data file

art297 — Thu, 15 Jun 2017 18:16:47 GMT

Here is one way:

data HAVE;
  infile datalines truncover;
  input var1 $200.;
  datalines;
(S) Benefit
plans
(S) car
allowance
(S) Technology,
Economic Development Initiative
Motor allowance
(S) Small Business and Tourism
Agriculture
(S) Small Business
Financing Act
;
run;

data want (drop=_:);
  length var1 $200;
  retain var1;
  merge have (rename=(var1=_var1_in)) have (firstobs=2 rename=(var1=_var1_next));
  if first(_var1_in) eq '(' then var1=_var1_in;
  else var1=catx(' ',var1,_var1_in);
  if missing(_var1_next) or first(_var1_next) eq '(' then output;
run;

Art, CEO, AnalystFinder.com

Re: Removing line returns from SAS data file

Astounding — Thu, 15 Jun 2017 19:24:24 GMT

Another way to get from the HAVE data to the WANT data:

data want;

length var1_combined $ 200;

do i=1 to 2;

set have;

if i=1 then var1_combined = var1;

else var1_combined = catx(' ', var1_combined, var1);

end;

keep var1_combined;

rename var1_combined = var1; /* optional */

run;