topic Re: How to convert variable from character to numeric when there is one missing value in SAS Programming

How to convert variable from character to numeric when there is one missing value

gahlot1999 — Sun, 01 May 2022 21:48:21 GMT

Data Set -

How to convert this character dataset to variable. So that I can fetch data out of it....Having issue due to missing value...

Tried - RFICDAT = input(RFICDAT, 10.), RFICDAT = input(RFICDAT, 10.)

Re: How to convert variable from character to numeric when there is one missing value

sbxkoenk — Sun, 01 May 2022 22:09:51 GMT

Use a different variable name on the left hand side of assignment statement :

RFICDATnum = input(RFICDAT, 10.);

Koen

Re: How to convert variable from character to numeric when there is one missing value

andreas_lds — Mon, 02 May 2022 06:15:50 GMT

You can't change the type of a variable, you have to create a new one, as shown by @sbxkoenk

Re: How to convert variable from character to numeric when there is one missing value

Kurt_Bremser — Mon, 02 May 2022 06:39:12 GMT

You are importing an Excel spreadsheet where the "header row" seems to be in a non-standard location. PROC IMPORT provides options to deal with this. Please show us a screenshot of the original spreadsheet.

The numbers you see are the raw values of Excel dates.

Re: How to convert variable from character to numeric when there is one missing value

gahlot1999 — Mon, 02 May 2022 09:47:54 GMT

Hi, here is the screenshot for excel spreadsheet. Could you please let me know how to handle this in proc import directly.

Re: How to convert variable from character to numeric when there is one missing value

Kurt_Bremser — Mon, 02 May 2022 09:46:16 GMT

This looks straight forward. How did you import this spreadsheet (please post the complete code)?