Hi All, I used the data step to covert a few variables from charater to numeric. data NEW; SET HAVE; Account_New=input(Account, 10.); Bor_New=input(Bor, 3.); drop Account Bor; rename Account_New=Account Bor_New=Bor; run;   After I did this, the order of variables changed. Is there any way to restore back the original order of each columns? There are about 50 columns and Account is the first one. So dropping this variable from the data step technically changed the order of all other columns.   Any help is much appreciated! Thanks. ... View more

Hi, I ran a query in SAS to pull the data (63 columns, 18k rows) and then update this table to Teradata using ansi mode.   Create table APPS_TEMP as (select col1,col2,col3....col63 from abc) libname Space teradata server='' user=&user_name password=&pwd schema='Space' mode=ansi;   insert into Space.APPS  select * from APPS_TEMP   I was able to run this with no issue last month, but this month I got this error message "ERROR: On an insert, update, or index operation, the value applied to a Teradata integer was out of range - greater than 2147483647." Please advise how I could fix it. Any help is greatly appreciated. Thanks ... View more