SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Need to load a variable as BIGINT to Hadoop

Reply
Occasional Contributor
Posts: 7

Need to load a variable as BIGINT to Hadoop

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;

 

PROC Star
Posts: 549

Re: Need to load a variable as BIGINT to Hadoop

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

Ask a Question
Discussion stats
  • 1 reply
  • 87 views
  • 0 likes
  • 2 in conversation