topic Re: SUBSTR in SAS Programming

SUBSTR

VALLY — Mon, 12 Jul 2021 17:23:52 GMT

Hi Expect.

i have the following dataset: VAR

20000000427276985 3020210406999912310000004476Z1000000Z100000100005100DR009500000000010137899589

And when i do a substr it return blank colums.

code:

PROC SQL;
CREATE TABLE MAP_COP_FILE AS
SELECT
SUBSTR (CAT(VAR1),1,1) AS ITEM,
SUBSTR (CAT(VAR1),2,35) AS 'External Account Number'N,
SUBSTR (CAT(VAR1),37,2) AS 'Account Status'N
FROM VBM.SAP_NOM

;
QUIT;

output:

please assist

Re: SUBSTR

PaigeMiller — Mon, 12 Jul 2021 17:46:25 GMT

I get non-blank answers, so something in your code is wrong, or that's not the data.

data have;
var1='20000000427276985 3020210406999912310000004476Z1000000Z100000100005100DR009500000000010137899589';
run;

PROC SQL;
CREATE TABLE outp AS
SELECT
SUBSTR (CAT(VAR1),1,1) AS ITEM,
SUBSTR (CAT(VAR1),2,35) AS acct_no,
SUBSTR (CAT(VAR1),37,2) AS acct_status
FROM have;
QUIT;

Please show us (a portion of) the data, not as something you typed in, but following these instructions.

Also, the CAT function is not needed here.

Re: SUBSTR

ballardw — Mon, 12 Jul 2021 19:07:08 GMT

Why are you calling the CAT function? CAT is intended to combine two or more variables. With a single variable it just adds overhead.

Re: SUBSTR

Reeza — Mon, 12 Jul 2021 20:14:29 GMT

Show your log....