About india2016

india2016 · ‎05-04-2022

Hello SAS Kiwi, I tried without bulkload as well but same result. and can you please tell me, what site-specific requirements needs to check with Admin? Sorry I did not get your question.

india2016 · ‎05-04-2022

Yes LinusH , I have tried these options as well but could not push data into Hadoop table.

india2016 · ‎05-03-2022

Hello Patrick, I am not getting any warning or Error. Job is running as usual with long time and did not load single row into Hadoop table and there is no job which loads data into hadoop cluster. Trying to load data first time.

india2016 · ‎05-02-2022

Hello Experts, I need your quick help regarding bulkload option. Scenario: I am trying to load data into Hadoop library from SAS work library. Trying with sample 10 records and after 15minutes wait time, 0 records has been loaded to hadoop table.. Tried 3ways with Bulkload=Yes option but getting same output. 1) Data Hdp.abc(bulkload=yes); set sashelp.cars(obs=10); run; 2) proc append base=Hdp.abc(bulkload=yes) data=work.cars; run; 3) created table structre and tried to pust using Insert into statement. Please suggest the fastet way to load data into Hadoop table or let me know do I need to do any other changes in config file to work BULKLOAD option.

india2016 · ‎04-14-2022

Thanks Tom for your time and quick help. this code is also solve my requirement,

india2016 · ‎04-14-2022

Thanks Tom for your suggestion and code. I can do it this way as well but I have created scenarion the data is too large. so

india2016 · ‎04-14-2022

Does every record have exactly 3 values for RL_data? --Yes. Are the new variables supposed to be numeric or character? --Numeric would be preferable. And actually Kurt_Bremser has resolved the basic issue which I was facing . Now I can build the code on the basis of that. @ballardw Thank you so much for putting your efforts and time.

india2016 · ‎04-14-2022

Thanks Kurt. I worked very well. Thank you so much for your prompt help.

india2016 · ‎04-13-2022

Hello Team, I am trying to create multiple columns using single column as showin in below picture. First row has column name (tre,iop,df) from RL_DATA column. RU_ID RL_DATA 1 TRE,IOP,DF 1 0,2,3 1 9,8,0 1 8,8,9 I want table in below format RU_ID TRE IOP DF 1 0 2 3 1 9 8 0 1 8 8 9 Does anyone have shortcut method or similar scenario faced earlier then can you please give me brief idea so that I can code in that way. What I am tried till now. i) I have create macro of RL_Data first row (TRE,IOP,DF) using into : ii) Creating loop to pass each time column name and create new column in same table. But facing a lot of challenges in section ii). Please let me know the path to solve this scenario so that I can code accordingly.

india2016 · ‎11-09-2021

Hi Team, Got to know we can export XML from Qlikview and then that should import using SAS MetaData Loader. Working on that will post here the solution.

india2016 · ‎11-09-2021

Thanks Vincent.

india2016 · ‎10-27-2021

Hi All, We are trying to import metadata from QlikView into SAS relationship repository for lineages. We know that one way is to use metadata bridge(SAS Metadata Bridge for BI & Visualization Tool) But since it is paid, Is there any other way to import the same into SAS Relationship repository. Thanks in advance.

india2016 · ‎10-12-2018

Thanks @PeterClemmensen.

india2016 · ‎10-12-2018

Hi All, Need small help. I have data like below A Unique_ID Version Murder 1 1 Theft 1 2 dacoity 1 3 Murder 2 1 Murder 2 2 I want an output like below: Unique ID Previous_A Present_A 1 Theft Dacoity 2 Murder Murder Basically if for Unique_ID there is a version. For the last version and before last version if Column "A" is different then I need 2 column to be created Previous_A and Present_A. Previous A will hold the 2nd last version value and Present A will hold the last version value.

india2016 · ‎10-11-2018

1) When we run a DI job it fetches data from Oracle table and loads it into Hadoop table using Table loader transformation. The data gets loaded into Hadoop Table and then when you open the table in SAS environment you are getting some blank rows. 2) As you suggested, there is no such blank values in Oracle table but while data loading into Hadoop dataset,some extra missing rows were generated in hadoop table. DDL is created in Hadoop using CREATE TABLE node. and then using DATA LOADER node data was loaded into Hadoop tables. Should I share backend code for these transformations? I have attached backend coed for the same. Please find attached log.

Online Status	Offline
Date Last Visited	‎07-25-2024 09:17 AM

Re: Split merged row data into two rows through SAS code

Split merged row data into two rows through SAS code

Re: Getting Error in Simple SAS Code via DataFlux

Re: Better subject line needed

SAS Code Debugging: Unanticipated Behavior in dataflux SAS code

Re: Providing VA Dashboard access to user which belongs to multiple gr...

Providing VA Dashboard access to user which belongs to multiple groups

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: Required input for SAS VA dashboard report link

Re: Creating multiple columns using single column

Re: Creating multiple columns using single column

Re: Split merged row data into two rows through SAS code

Re: Required input for SAS VA dashboard report link

Re: Import metadata from qlikview to SAS

Re: Free Webinar: SAS® Visual Statistics 8.3 on SAS Viya: Getting Sta...

Re: Hyperlinks in Report Designer

Re: Query regarding bulkload from SAS to Hadoop

Re: Query regarding bulkload from SAS to Hadoop

Re: Query regarding bulkload from SAS to Hadoop

Query regarding bulkload from SAS to Hadoop

Re: Creating multiple columns using single column

Re: Creating multiple columns using single column

Re: Creating multiple columns using single column

Re: Creating multiple columns using single column

Creating multiple columns using single column

Re: Import metadata from qlikview to SAS

Re: Import metadata from qlikview to SAS

Import metadata from qlikview to SAS

Re: Need previous data if it is different from the last data

Need previous data if it is different from the last data

Re: Issue while loading data into Hadoop from Oracle