topic Re: Extract first 8 digits left of the number in SAS Procedures

Extract first 8 digits left of the number

rakeshvvv — Mon, 25 Aug 2014 12:23:54 GMT

I would like to pull out the first 8 digits to the left of the number........the numbers marked in yellow should be discarded.....

295999335

295999333

295999336

295999337

Thanks

Ksharp — Mon, 25 Aug 2014 13:17:13 GMT

This variable is character or numeric ?Assuming it is character.

data have;

set have;

length want $ 8;

want=variable;

run;

rakeshvvv — Mon, 25 Aug 2014 13:29:41 GMT

Thanks...Can you suggest a solution if the variable is Numeric....

stat_sas — Mon, 25 Aug 2014 13:45:43 GMT

For numeric you can try something like this

data want;

set have;

want=int(variable/10);

run;