How to Read This in Data Step

[User_Help]

Hi,

How to read this in Data Step?

data a;
	INPUT @ NAME $22. age gender $;
	DATALINES;
RASPUTIN 45 M
BETSY ROSS 62 F
ROBERT LOUIS STEVENSON 75 M
;

run;

[Ksharp · Accepted solution]

data a;
	INPUT;
gender=scan(_infile_,-1,' ');
age=scan(_infile_,-2,' ');
call scan(_infile_,-2,p,l,' ');
name=substr(_infile_,1,p-1);
drop p l;
DATALINES;
RASPUTIN 45 M
BETSY ROSS 62 F
ROBERT LOUIS STEVENSON 75 M
;

[KachiM]

@User_Help 

In addition to the solution given by @Ksharp, it can be solved without using SAS functions. The only requirement is that the value for NAME variable separated by two or more blanks as in:

data a;
	INPUT NAME &$22. age gender $;
	DATALINES;
RASPUTIN  45 M
BETSY ROSS  62 F
ROBERT LOUIS STEVENSON  75 M
;
run;

I introduced two BLANKS between NAME and AGE and used &$22 to read blank embedded NAME.