topic Re: Need help with code in SAS Programming

Need help with code

Sultana — Tue, 06 Jul 2021 04:03:09 GMT

Here is a sample data set where column 1 is the ID which has the employees name and number

I only want the numbers to be outputted

ID	Date	Amount
Robert, Andrews 222-22-1234	2019	1,234.00
Albert, Sanders 123-45-6789	2018	2,34.67
Zack, Snyder 111-22-3333	2020	1,234.77

I need the following output

ID	Date	Amount
222-22-1234	2019	1,234.00
123-45-6789	2018	2,34.67
111-22-3333	2020	1,234.77

input ID : $12

Year : Year.

Amount: comma13.

;

Please let me know how to only the ID numbers in the output table no names.

Thanks

Re: Need help with code

ChrisNZ — Tue, 06 Jul 2021 04:15:20 GMT

A very simple way would be to use the anydigit() function inside the substr() function .

Re: Need help with code

andreas_lds — Tue, 06 Jul 2021 04:17:21 GMT

There are several ways you can do this:

compress-function to keep only numbers and hyphen.
regular expression with prxchange
anydigit-function to get the position of the first number, then substr to extract the number.

I am sure that after having the a quick look at the documentation of the functions, you are able to solve the problem. If not, please post data in usable form and the code you already have.

Re: Need help with code

Sultana — Tue, 06 Jul 2021 04:31:20 GMT

can you provide me the compress function code to get only the number and hypen.

Re: Need help with code

andreas_lds — Tue, 06 Jul 2021 05:08:51 GMT

What have you tried? Being able to read the docs and find required information is a necessary skill to learn a programming language.

want = compress(have, '-', 'kd');

Re: Need help with code

novinosrin — Tue, 06 Jul 2021 12:36:23 GMT

Your ID has a clear pattern for a SCAN function starting from right to left-

 length want_id $15;
 want_id=scan(id,-1,' ');

data have ;
  infile cards truncover expandtabs ;
  input ID $28.	Date	Amount :comma10. ;
  format amount comma10.2 ;
  cards;
Robert, Andrews 222-22-1234	2019	1,234.00
Albert, Sanders 123-45-6789	2018	2,34.67
Zack, Snyder 111-22-3333	2020	1,234.77
;

data want ;
 set have ;
 length want_id $15 ;
 want_id=scan(id,-1,' ') ;
run ;

proc print noobs ; run ;

ID	Date	Amount	want_id
Robert, Andrews 222-22-1234	2019	1,234.00	222-22-1234
Albert, Sanders 123-45-6789	2018	234.67	123-45-6789
Zack, Snyder 111-22-3333	2020	1,234.77	111-22-3333