topic Extracting first few digits from a class in SAS Programming

Extracting first few digits from a class

jiasyuen — Wed, 21 Apr 2021 07:40:17 GMT

data base1;
set lib.base1;

run;

proc summary data=base1 nway missing;
class prd;
var gp;

run;

My prd is a set of date. I am required to extract the first 4 digits of it. For example, 202012, and I only need 2020.

Is there any way to extract it? Thank you.

Re: Extracting first few digits from a class

andreas_lds — Wed, 21 Apr 2021 07:53:27 GMT

Depends on the type of prd:

if it is a string, use substr-function
if it is numeric, convert in to string and use substr
if you have a real date, use year-function to extract the year.

Re: Extracting first few digits from a class

jiasyuen — Wed, 21 Apr 2021 08:09:04 GMT

Let say it's a string. How would I convert? Can you show me the line of code? Thank you.

Re: Extracting first few digits from a class

Patrick — Wed, 21 Apr 2021 08:45:07 GMT

data base1;
set lib.base1;
prd2=substrn(prd,1,4);
run;