topic Re: data logic in SAS Programming

data logic

Almoha — Thu, 27 Sep 2018 20:14:13 GMT

All,

I have the following values in a variable VAR1. Need to create a variable VAR2 and populate x and Y

VAR1

x /1234/ ()

y /4567/ ()

VAR1 VAR2

x /1234/ () x

y /4567/ () y

Re: data logic

SuryaKiran — Thu, 27 Sep 2018 20:24:26 GMT

Your representation of sample data doesn't make sense. Please provide proper sample data.

If they are properly delimited then you can use SCAN or SUBSTR functions or if looking for specific words then use FIND or INDEX

data test;
infile datalines ;
input var1 $20.;
datalines;
x /1234/ ()
y /4567/ ()
;
run;

data want;
set test ;
var2=scan(var1,1);/* If they are properly delimited by space*/
run;

Re: data logic

Almoha — Thu, 27 Sep 2018 20:41:31 GMT

No ,there are not properly spaced.
and can have mutiple () () or {} etc..

Re: data logic

PeterClemmensen — Thu, 27 Sep 2018 20:46:16 GMT

data have;
input VAR1 $50.;
datalines;
x                  /1234/ ()
y                  /4567/ ()
;

data want;
   set have;
   var2=substr(VAR1,1,1);
run;

Re: data logic

Astounding — Thu, 27 Sep 2018 21:22:44 GMT

Even simpler?

data want;

set have;

length var2 $ 1;

var2=var1;

run;

Re: data logic

andreas_lds — Fri, 28 Sep 2018 04:47:22 GMT

@Almoha wrote:
No ,there are not properly spaced.
and can have mutiple () () or {} etc..

Then, please, be so kind to post example data having the same complexity as your real data.