topic Re: Alter Informat Value from Data Source in SAS Enterprise Guide

Alter Informat Value from Data Source

User_Help — Fri, 23 Oct 2020 01:11:29 GMT

Hi all,

I m using SAS EG, realized the data source i had imported was with incorrect "Informat".

Would like to change data source from "Character" to "Numeric". (not alter in Query Builder)

Anyone could help me out?

Thanks!

Re: Alter Informat Value from Data Source

jimbarbour — Fri, 23 Oct 2020 01:15:58 GMT

I typically would just reimport the data. During the the import process, one can choose the I format to be used. One does not have to accept the determinations that SAS makes.

Jim

Re: Alter Informat Value from Data Source

User_Help — Fri, 23 Oct 2020 07:16:10 GMT

How could i do this in Query Builder?

As when i wanna changed from "Character" to "Comma20.5", it appeared as below"

Please assist.

Re: Alter Informat Value from Data Source

jimbarbour — Mon, 26 Oct 2020 03:00:59 GMT

Well, first of course click on Query Builder.

When the first screen of Query Builder opens, click on "Add a New Computed Column." I'm using EG 8.2, but other versions will have something similar.

Notice in the above that I have a variable called Num_Char which contains numbers but has been defined as character.

When you click on "Add a New Computed Column," click on "Advanced expression" and click on "Next".

In the next screen, type in INPUT(your_variable_name, 8.) in the expression window. My variable name is Num_Char, but you should substitute your variable name. Click on "Next."

In the next window, type in the name of the column, the length (generally 8 for numeric variables), and the desired format (in this case COMMA20.5).

Click on "Next," and in the following window, click on "Finish." When you click on "Finish," the Query Builder dialog windows will close, and you'll be back to the main Query Builder window. Click on "Run."

The Query will run, and you will have a new column named with whatever name you gave it (I typically would use the original character name but the definition will now be numeric).

Jim