About Sheeba

Sheeba · ‎09-26-2013

tnx a lot Linush. Any record from Table B would be a fit for join....

Sheeba · ‎09-26-2013

tnx a lot Patrick. Distinct keyword helped me out.

Sheeba · ‎09-25-2013

Hi, I am planning to use a join transformation in SAS DI Studio to join two tables A and B. The relationship between A and B is one to Many. For each row in A , I would like to take only one record from B. Is there any function which allows to perform this? Thanks in advance, Regards, Sheeba Swaminathan

Sheeba · ‎09-11-2013

Thanks Michael. I will try out the update transform with exist keyword.

Sheeba · ‎09-11-2013

Thanks Linush. I will try out that as I want to reduce the user written transformations.

Sheeba · ‎09-11-2013

Thanks Scott. I will try out this method.

Sheeba · ‎09-10-2013

HI, Is it possible to update a table A based on the values of table B using SAS DI studio? Table A and Table B has a common variable Var1 I need to update the column of A if matching values of Var1 exists in B. Thanks in advance, Regards, Sheeba Swaminathan

Sheeba · ‎08-27-2013

Thanks Jaap. I will go through this section in the user guide.

Sheeba · ‎08-26-2013

Thanks a lot for the suggestions Linush.

Sheeba · ‎08-26-2013

Thanks a lot Linush. By Cache, I refer to a temporary table which can hold only the latest Deal ID's. Using this temporary table, i am planning to pull the matching records from table B. From your reply,I believe it is possible to derive that

Sheeba · ‎08-26-2013

Thanks for the suggestion Tom. It clearly provides a plan for the problem. This situation deals with large volume of data. So I will try to find an optimal solution with the help of experts

Sheeba · ‎08-26-2013

Thanks a lot Jaap. I will try to set up User written transformations

Sheeba · ‎08-23-2013

I have a table A which contains a column Deal ID.New deal id gets added to Table A every day. I have another table B which has all the details of Deals and Deal ID as well. I need to pull some details of Deals from B into A based on deal id using SAS ETL(DI JOBS). If I have 100 deals getting added to table A every day,how will i pull the details of this 100 deals from table B using DI studio? Is it possible to store the Deal ID in cache and pull the corresponding data? Is data cache supported in SAS DI studio? Appreciate any help on this, Regards, Sheeba Swaminathan

Sheeba · ‎06-28-2013

Hi, Thanks for the detailed reply. Yes, I was trying to use JOIN_MODEL= option to build an information map from snowflake schema. So I used update infomap statements. I got the same error which is mentioned in the attached document. Thanks for the clarifications. Regards, Sheeba Swaminathan

Sheeba · ‎06-25-2013

Hi Astounding, Thanks a lot for the reply. I will definitely give it a try. Regards, Sheeba Swaminathan

Online Status	Offline
Date Last Visited	‎07-19-2023 06:27 PM

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

How do I extract data from Snowflake into SAS efficiently ?

Re: How do I add a hyperlink in the body of the email

How do I add a hyperlink in the body of the email

Re: Data Masking and encryption in sas

Re: Data Masking and encryption in sas

Re: Data Masking and encryption in sas

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: How do I extract data from Snowflake into SAS efficiently ?

Re: Queries in SAS DI Studio

Re: Queries in SAS DI Studio

Queries in SAS DI Studio

Re: update a table based on the values of another table

Re: update a table based on the values of another table

Re: update a table based on the values of another table

update a table based on the values of another table

Re: SAS DI Query

Re: SAS DI Query

Re: SAS DI Query

Re: SAS DI Query

Re: SAS DI Query

SAS DI Query

Re: Reg Information Map studio

Re: SAS validations for non numeric value