topic Re: how to remove comma in SAS Programming

how to remove comma

manish_1 — Mon, 24 Apr 2017 06:23:55 GMT

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.

Re: how to remove comma

Reeza — Mon, 24 Apr 2017 06:36:43 GMT

Doesn't Salary start at 9, not 10?

Re: how to remove comma

manish_1 — Mon, 24 Apr 2017 06:51:35 GMT

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

Re: how to remove comma

Jagadishkatam — Mon, 24 Apr 2017 07:14:45 GMT

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

Re: how to remove comma

manish_1 — Mon, 24 Apr 2017 08:40:30 GMT

thanks for explaining. I Understood how does @ works.