About deepika2

deepika2 · ‎11-22-2017

Hi , I am trying to import a hive data into SAS using ODBC connection to HIVE server. In one of the columns of HIVE table there are carriage return characters. When I import the data into SAS from HIVE table, the values of the column containing carriage return are moved to next column/row. Can anyone please help me solve this. Thanks

deepika2 · ‎06-08-2017

Hi, I am having a table in Hive and using that table I am trying to create a temporary table in Hive based on some conditions and lookup values, which are stored in a SAS dataset. I am using Execute (insert into .... ) by hadoop inside proc sql. On using the SAS dataset reference inside Execute by hadoop, it gives me an error. Can somebody suggest how can I achieve this. Thanks for the help.

deepika2 · ‎05-12-2017

Thanks for the quick reply. It actually worked.

deepika2 · ‎05-12-2017

I am trying to write a PROC SQL statement which is extracting data from SQL Server based on some date criteria. %let ExamStartDate = 01APR2017; %let ExamEndDate = 01MAY2017; data _null_; call symputx('sdate',put("&ExamStartDate."d,yymmdd10.)); call symputx('edate',put("&ExamEndDate."d,yymmdd10.)); run; proc sql; connect to odbc (dsn='aa' user=user pw=pw); create table temp1 as select * from connection to odbc ( SELECT cnd.firstName, cnd.middleName, cnd.lastName, cd.calendarDate as date FROM candidate cnd inner join CalendarDate cd with (NOLOCK) on cd.calendarDateId=cnd.eventDateId and cd.calendarDate >= convert(datetime,&sdate.) ); quit; When I run the code, it gives me all records and does not filter out the data. Can anyone suggest what am I doing wrong here. Thanks for the help.

Online Status	Offline
Date Last Visited	‎11-28-2017 02:29 AM

Remove Carriage Return in SAS dataset imported from Hive

How to persist native SAS data sets to Hadoop (Hive)

Re: Pass Date macro Variable into a PROC SQL Where statement

Pass Date macro Variable into a PROC SQL Where statement

Pass Date macro Variable into a PROC SQL Where statement

Re: Pass Date macro Variable into a PROC SQL Where statement

Remove Carriage Return in SAS dataset imported from Hive

How to persist native SAS data sets to Hadoop (Hive)

Re: Pass Date macro Variable into a PROC SQL Where statement

Pass Date macro Variable into a PROC SQL Where statement