how to remove comma

[manish_1]

How to extract salary without Rs and comma in salary as in the raw file. I am not able to find my mistake.

this is my code

data sasdata.new;
infile "F:\Raw.txt";
input Id @3 Name $3. @17 Incentive : percent3. @10 Salary : comma9.;
Total=salary+salary*incentive;
run;

attached the raw data file.

[Reeza]

Doesn't Salary start at 9, not 10? 

[manish_1]

Hi Reeza,

I am new to sas. Can you tell me the function of @ and : in sas programming. I am not exactly able to get it.

Thanks

[Jagadishkatam · Accepted solution]

Please try

data new;
infile cards missover;
input Id @3 Name $3. @17 Incentive : percent3. @9 Salary :comma9.;
Total=salary+salary*incentive;
cards;
1 Ram Rs250,100 44%
2 xyz Rs310,000 20%
3 Abc Rs420,000 30%
4 MMN Rs520,000 40%
;

@ holds the input record for the execution of the next INPUT statement within the same iteration of the DATA step. This line-hold specifier is called trailing @.

[manish_1]

thanks for explaining. I Understood how does @ works.