topic Re: How to convert variables which can handle both numeric and character data? in SAS Programming

How to convert variables which can handle both numeric and character data?

Rakesh93 — Wed, 14 Oct 2020 05:40:50 GMT

I have a lab dataset in which LBSTNRHI, LBSTNRLO, LBREFID , LBSTNRHI_US, LBSTNRLO_US are there. I want to convert these variable so that they could handle both character data type as well as numeric data type. Kindly share your answers with programming code.

Thank you.

Re: How to convert variables which can handle both numeric and character data?

SASKiwi — Wed, 14 Oct 2020 05:47:22 GMT

Only SAS character variables can store both character and numeric data. Use PROC CONTENTS to confirm if your variables are either character or numeric:

proc contents data = MyLib.MyTable;
run;

Re: How to convert variables which can handle both numeric and character data?

Rakesh93 — Wed, 14 Oct 2020 05:54:06 GMT

I have mentioned those variables in message. I want only those variables
can read both numeric and character data. Do you know any formats which can
Achieve that?

Re: How to convert variables which can handle both numeric and character data?

SASKiwi — Wed, 14 Oct 2020 06:37:33 GMT

If LBSTNRHI, LBSTNRLO, LBREFID , LBSTNRHI_US, LBSTNRLO_US are character variables then they can store both character and numeric data. Use PROC CONTENTS as I showed you to confirm if they are character or not.