topic How to Read This in Data Step in New SAS User

How to Read This in Data Step

User_Help — Sat, 09 Nov 2019 12:46:43 GMT

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;

Re: How to Read This in Data Step

Ksharp — Sat, 09 Nov 2019 12:51:33 GMT

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
;

Re: How to Read This in Data Step

KachiM — Sat, 09 Nov 2019 13:14:16 GMT

@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.