topic How to shorten identifier length and add leading zeros? in SAS Programming

How to shorten identifier length and add leading zeros?

Denali — Mon, 03 Aug 2020 12:38:06 GMT

Hi,

The indentified variable is currently listed as character $500. How can I shorten the length to $8 and add leading zeros to those numbers shorter than 8 characters? Thank you.

proc contents results:

record_id

Char

500

$500.

Proc print results:

Obs	record_id
1	25481
2	27775
3	167205
4	168552
5	195018
6	293336
7	303971
8	336269
9	360908
10	362220
11	00362383
12	370550
13	447997
14	00496297
15	499403
16	506068
17	506914
18	514282
19	525407
20	584554
21	681037
22	775671
23	788309
24	840175
25	862188
26	35044537

Re: How to shorten identifier length and add leading zeros?

Jagadishkatam — Mon, 03 Aug 2020 12:43:24 GMT

Please try below code to derive record_id2 variable

record_id2=put(input(record_id,best.),z8.);

Re: How to shorten identifier length and add leading zeros?

Denali — Mon, 03 Aug 2020 12:48:01 GMT

Thank you so much! It worked!

Re: How to shorten identifier length and add leading zeros?

Ksharp — Mon, 03 Aug 2020 13:46:56 GMT

data have;
input record_id	$;
length want $ 8;
want=record_id;
want=translate(right(want),'0',' ');
cards;
25481
27775
;