How to return column format type?

[Maksim_Naumov]

Hello everyone!

Could somebody advise how i can return format type in SQL query?

I import Excel file and one of column can be imported wirh numeric or char type, and depends on data type i'd like to use code like this:

case when GRB(column name) = numeric then ...
        when  GRB(column name) =char then...

[japelin]

you can get variable information from SASHELP.VCOLUMN or dictionary table.

data class;
  set sashelp.vcolumn;
  where libname='SASHELP' and memname='CLASS';
  keep name type;
run;

PROC SQL;
    SELECT type, name
    FROM dictionary.columns
    WHERE libname='SASHELP' and memname='CLASS';
QUIT;

[ballardw]

If this means that you have been importing multiple files that should have the same structure then you need to take control of how you read data at the beginning. A "column" should have the same properties. Unfortunately Excel enforces no rules on any cell, much less entire columns.

Search the forum for IMPORT and EXCEL. This is such a common problem we answer some form of it nearly daily, if not multiple times per day.