List iput query

anirghy — Tue, 31 Aug 2021 15:41:05 GMT

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.

Re: List iput query

sbxkoenk — Tue, 31 Aug 2021 17:26:23 GMT

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

topic List iput query in Programming 1 and 2

List iput query

Re: List iput query