List iput query

[anirghy]

I am fairly new to SAS.Can anyone help me to read this data.

EVANS DONNY 112 29,996.63
HELMS LISA 105 18,567.23
HIGGINS JOHN 111 25,309.00
LARSON AMY 113 32,696.78
MOORE MARY 112 28,945.89
POWELL JASON 103 35,099.50
RILEY JUDY 111 25,309.00
RYAN NEAL 112 28,180.00
WILSON HENRY 113 31,875.46
WOODS CHIP 105 17,098.71

There should be three variables as 'Name' 'ID' and 'Salary'

Thanks in advance.

[sbxkoenk · Accepted solution]

Hello,

I like to use a delimiter, but you can also do without (little code changes are needed then).

You can also use the 'datalines' keyword instead of 'cards'.

data have;
LENGTH NAME $ 12 ID $ 3 Salary 8; 
infile cards delimiter='|';
format Salary comma10.2; 
input Name $ ID $ Salary :comma10.;
Name=strip(Name);
cards;
EVANS DONNY |112|29,996.63
HELMS LISA  |105|18,567.23
HIGGINS JOHN|111|25,309.00
LARSON AMY  |113|32,696.78
MOORE MARY  |112|28,945.89
POWELL JASON|103|35,099.50
RILEY JUDY  |111|25,309.00
RYAN NEAL   |112|28,180.00
WILSON HENRY|113|31,875.46
WOODS CHIP  |105|17,098.71
;
run;
/* end of program */

Cheers,
Koen