topic Sas Base question in New SAS User

Sas Base question

Pandu — Wed, 03 Apr 2019 06:12:10 GMT

Hi All,

I have a variable name Policy_no and the values are

Policy_no

56789/k0256

58796548/k908

4785/Nk02

I want to read the value before / or want to delete (/k0256)

finally i want to read as below

56789

58796548

4785

Thank you in advance

Re: Sas Base question

Astounding — Wed, 03 Apr 2019 06:35:05 GMT

Start with:

part1 = scan(policy_no, 1, '/');
part2 = scan(policy_no, 2, '/');

That gives you the pieces before and after the/ as separate variables.

Re: Sas Base question

Kurt_Bremser — Wed, 03 Apr 2019 08:07:09 GMT

What is the rule for that funny vertical alignment of your intended result?