topic Re: Need to load a variable as BIGINT to Hadoop in SAS Data Management

Need to load a variable as BIGINT to Hadoop

lauracw4 — Mon, 06 Aug 2018 13:24:19 GMT

When I loaded an numeric ID variable to Hadoop using a simple data step, it went up as DOUBLE, adding a ".0". This causes problems with joins. What format should an ID be in when in SAS so that it will load up to Hadoop as BIGINT?

data had.hadoop_table;

set lib.sas_table;

run;

Re: Need to load a variable as BIGINT to Hadoop

kiranv_ — Mon, 06 Aug 2018 13:48:53 GMT

need to do something like below by using dbsastype

data had.hadoop_table;

set lib.sas_table (dbsastype= (name='char(20)'));

run;

please check this link for more info.

http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001371572.htm