About india2016

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.

india2016 · ‎10-09-2018

Hello Team, We are facing issue while loading data into hadoop environment from Oracle database using DI job (Table Loader Node). But when table is loaded into hadoop , multiple missing observations are generated which are not in Oracle data-base. Anyone faced this issue then please suggest what should I do to overcome this issue? Any suggestion will be appreciated.

india2016 · ‎09-12-2018

@LinusH It means I have assigned the library.

india2016 · ‎09-12-2018

Hi All, Need small help. I am getting error while I am trying to open tables in SAS data integration. Error is "Libref not assigned" although library is assigned in SAS SMC. Do I need to do entry in autoexec file?? Please let me know

india2016 · ‎09-04-2018

@FredrikE First Dataset below: Districts Date FIR A 02-09-2018 2 B 02-09-2018 5 A 03-09-2018 3 A 04-09-2018 5 B 04-09-2018 6 Second dataset Below Districts P_Date Petty Case A 01-09-2018 3 B 02-09-2018 3 A 02-09-2018 4 A 04-09-2018 6 B 04-09-2018 7 Frond end I have to use general date. But from the back end we need FIR number By districts and date from 1st dataset and number of petty cases by districts and date from 2nd dataset.

india2016 · ‎09-03-2018

Hello All, Need your small help . I want to have a summarisation report for few columns. Those columns at the back end depends on different date. But in VA at the front end I want to show the data having generalized date, Say for example. Frond end is like this Date Slider Districts No. Of FIR No. OF Petty cases No. Of MOBs 1 12 23 22 2 3 45 33 3 4 6 44 4 5 7 55 5 78 89 66 6 90 89 77 7 11 90 88 Date is generalized at the front end. At the back end all this 3 number columns depends on different date.

Online Status	Offline
Date Last Visited	‎03-31-2024 04:45 AM

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: Adding a users authdomain and userid of SAS metadata via SAS Code

Adding a users authdomain and userid of SAS metadata via SAS Code

Getting error while trying to connect to Dataflux repostiory on Data m...

Restrict user to access libname tables

Re: Query regarding bulkload from SAS to Hadoop

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: 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: Mapping datavalues from 2 different datasets

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

Issue while loading data into Hadoop from Oracle

Re: LIbref not assigned in SAS data integration

LIbref not assigned in SAS data integration

Re: Date prompt in SAS VA

Date prompt in SAS VA