Solved
Contributor
Posts: 56

# separate variable

name \$ gender \$ age;
raviM26 rajeshM28 shaliniF5  how to separate this three variable

Accepted Solutions
Solution
‎01-06-2018 11:55 AM
Super User
Posts: 2,061

## Re: separate variable

It does work, you are not reading correctly as you missed out the informat in the input statement

data have;
input h : \$9. @@;
age=substr(h,anydigit(h));
gender=substr(h,anydigit(h)-1,1);
name=substr(h,1,anydigit(h)-2);
datalines;
raviM26 rajeshM28 shaliniF5
;
run;

All Replies
Super User
Posts: 2,061

## Re: separate variable

data have;
h='raviM26';
age=substr(h,anydigit(h));
gender=substr(h,anydigit(h)-1,1);
name=substr(h,1,anydigit(h)-2);
run;

Contributor
Posts: 56

## Re: separate variable

not work for all

``````data have;
input h \$ @@;
age=substr(h,anydigit(h));
gender=substr(h,anydigit(h)-1,1);
name=substr(h,1,anydigit(h)-2);
datalines;
raviM26 rajeshM28 shaliniF5
;
run;``````
Solution
‎01-06-2018 11:55 AM
Super User
Posts: 2,061

## Re: separate variable

It does work, you are not reading correctly as you missed out the informat in the input statement

data have;
input h : \$9. @@;
age=substr(h,anydigit(h));
gender=substr(h,anydigit(h)-1,1);
name=substr(h,1,anydigit(h)-2);
datalines;
raviM26 rajeshM28 shaliniF5
;
run;

Contributor
Posts: 56