Numeric to character

[bhca60]

I am using SAS VIYA and trying to convert a variable “ID” (data from an excel import) from numeric to character. I am trying to join it to the “ID” in another data set to bring back any matches.

I’ve done this but it brings nothing back and want to make sure if that’s because there are no matches or because something is wrong with my input:

Data c;
Set b;
ID_char=put(ID,8.);
Run;

[Kurt_Bremser]

Hoe do the codes in the other dataset with the character variable look like?

[bhca60]

 The ID is a six digit  number 123456

[Kurt_Bremser]

Then use the Z6. format instead of 8.

[Reeza]

Try adding the -l component and trim in case you have blanks?

ID_Char = put(trim(ID), 8. -l);

(PS not that familiar with Viya)

[bhca60]

It looks like it worked but there is an ID that has a leading zero like 099999 but still shows as 99999.

[ballardw]

---

@bhca60 wrote:
It looks like it worked but there is an ID that has a leading zero like 099999 but still shows as 99999.

---

Shows where?

If you send values to a spreadsheet quite often the rules of the spreadsheet will convert text containing digits to numeric which loses the leading zeros.

[Kurt_Bremser]

That's why you need to use the Z format, which prints leading zeroes.

[bhca60]

Right but I imported it to sas from excel and thought that it would include a 0 in the output after conversion to character.

[Kurt_Bremser]

Numbers do not have leading zeroes. You must force the display of leading zeroes by using the proper format during the conversion to character.

[bhca60]

And what if you want to remove leading zeros but keep it a character?

[Reeza]

ID_char = put(input(id_char, 8.), 8. -l)

[Reeza]

Then you can use the Z6 format in your conversion.

ID_char = put(trim(ID), z6. -l);

[Tom]

---

@Reeza wrote:

Then you can use the Z6 format in your conversion.

ID_char = put(trim(ID), z6. -l);

---

Do not use the TRIM() function with a NUMERIC variable. 

There is no need to use the -L modifier with the Z format as there will not be any leading spaces to remove.

ID_char = put(ID, z6.);

[SASKiwi]

@bhca60  - It is normally better to fix this problem in Excel and then re-import. Open Excel, select the ID column. In the Data tab, select the Text to Column wizard, and go through the dialog, selecting Text as your column type. Now, when you re-import into SAS your ID column type will stay as character.