About Jagadeesh2907

Jagadeesh2907 · ‎06-14-2022

Hi Kurt, Thank you. that is very informative. just one more follow up as part of this, For a Data step view (a.sas7bvew) file, when it is copied in a like for like environment, source dataset should also be copied and should be available. is my understanding right ?

Jagadeesh2907 · ‎06-14-2022

Hi we have two servers like a PROD and UAT for production (Both Linux) and test purposes. when we copy datasets between these server it is working fine. however, when we copy SAS views, it is not working fine. hence i got the below queries to understand how it works. 1. when we copy SAS views between servers, do we need to copy the underlying dataset as well ? 2. if we copy the dataset and view from one server to another, will it work ? or should we copy the dataset from the server and create a view explicitly in the destination server ? please help clarify these queries for understanding.

Jagadeesh2907 · ‎01-07-2022

Thank you Allan. i will look into these and see if i can utilize them. Will get in touch with you if needed.

Jagadeesh2907 · ‎01-07-2022

@Patrick Thank you for these pointers. This helps in great deal in the understanding. we will try using the SMC for keeping the metadata objects which will help us in running the existing codes.

Jagadeesh2907 · ‎01-06-2022

Hi Quentin - we are not getting rid of metadata environment, but however, stop using DI studio for any job creation. True that this will not impact the code by application. however, checking for what to remove and not to remove to avoid any future breakdown of jobs.

Jagadeesh2907 · ‎01-06-2022

Thank you Patrick. I agree that I can use the same code (.sas program) to run in the scheduler and it should run fine. My main point of suspicion is around the libraries. For Example: In DI - the library references always gets the information from the metadata. So in different environments it takes the different locations. similarly RDBMS libraries point differently as they are mapped in metadata in DIS. so these needs to be updated manually.

Jagadeesh2907 · ‎01-06-2022

Hi All, Some years back I was using SAS DI studio to create the SAS jobs and hence we are having SAS DI jobs deployed for running the jobs. However, off late, we are moving away from SAS DI studio and using SAS EG to create the jobs using Base SAS program and does not use any DI components. Now we are looking to move the DI programs also into a Base SAS programs. On the outset we have identified library references what needs to be amended. Is there any utility which allows me to do it in SAS or what will be the pointers which i need to watchout when i try to remove the metadata components like tranformation ID, DI macros etc. Please advice

Jagadeesh2907 · ‎09-22-2021

Thank you Rezza, how can i explicitly control this through SQL ? is it by sorting the datasets before join or there are any other ways ?

Jagadeesh2907 · ‎09-22-2021

this explains my difference. thank you for this point. how can i force SQL to follow a certain order ? is it by sorting the datasets which are needed to be joined ?

Jagadeesh2907 · ‎09-21-2021

Hi All, I have 2 datasets A and B with a key variable "Customer_id". Dataset A does not have duplicates, however, Dataset B have duplicate key value but the complete record is not duplicate. consider this as a transaction dataset with mulitple amount for each "customer_id". when i try to do left join of dataset A with Dataset B, in the result dataset C, I would be getting multiple records for "customer_id" which has duplicate values. This is clear. What is my problem statement is that, will the order of the duplicate customer_id i.e the records of the Customer_id with duplicates differ when we run it each time ? As far as i know, SAS reads the data record by record and hence this should not change, however, wanted to have an expert opinion or check if my understanding is not correct.

Jagadeesh2907 · ‎04-30-2020

Thank you Chris.I will refer to your high performance SAS coding reference. Thank you for guiding me.

Jagadeesh2907 · ‎04-29-2020

Hi I have a customer linking dataset and i have five attibutes by below example: APPLICATION_NUM LINK_CUSTOMER_ID TEMP_CUSTOMER_ID LINKED_CUSTOMER_ID LINK_TYPE 11661523 9086964 9572284 6543652 160 11661523 9086964 9572284 9572284 190 11661523 9572284 9572284 6543652 160 what is want to do is to identify records with same application_num and link_customer_id and when they are same, i want to output only the record when the temp_customer_id is equal to linked_customer_id. that is for this example: i would need the output to be as below. APPLICATION_NUM LINK_CUSTOMER_ID TEMP_CUSTOMER_ID LINKED_CUSTOMER_ID LINK_TYPE 11661523 9086964 9572284 9572284 190 11661523 9572284 9572284 6543652 160

Jagadeesh2907 · ‎10-14-2019

HI , this is not a query on the reconciliation method. but to get the metrics from the reconciled dataset. i.e. to get the summary report from the DST3. what will be the best method in SAS to get the summary of matches and mismatches as in dst3.

Jagadeesh2907 · ‎10-14-2019

HI , this is not a query on the reconciliation method. but to get the metrics from the reconciled dataset. i.e. to get the summary report from the DST3. what will be the best method in SAS to get the summary of matches and mismatches as in dst3.

Jagadeesh2907 · ‎10-01-2019

Hi - I have a dataset which is having the reconciliation results of two datasets dst1 and dst2. dst1 app_id name 100 mark 101 steve 102 John dst2 app_id name 100 mark 101 Philip 102 John result dataset: DST3 dst1_appid dst2_appid recon_appid dst1_name dst2_name recon_name 100 100 Match mark mark Match 101 101 Match steve Philip Unmatched 102 102 Match John John Match I want to get a summary report of DST3. like below: Column Name Overall status No of Matches No of Mismatches Recon_appid Match 3 0 Recon_name Unmatch 2 1 Can i use proc report to create this type of report ? Also, would i be able to create a report where if i click to expand the overall status i will be able to know the details numbers. how can i approach this problem and what tools i can use from SAS.

Online Status	Offline
Date Last Visited	‎06-14-2022 06:49 AM

Re: Copy SAS views from one server to another

Copy SAS views from one server to another

Re: DI jobs to Base SAS jobs (EG jobs)

Re: DI jobs to Base SAS jobs (EG jobs)

Re: DI jobs to Base SAS jobs (EG jobs)

Re: DI jobs to Base SAS jobs (EG jobs)

DI jobs to Base SAS jobs (EG jobs)

Re: Can SAS give different output when we have duplicates in join

Re: Can SAS give different output when we have duplicates in join

Can SAS give different output when we have duplicates in join

Re: Copy SAS views from one server to another

Re: Copy SAS views from one server to another

Re: Can SAS give different output when we have duplicates in join

Re: Can SAS give different output when we have duplicates in join

Re: Comparing two records on key values and applying filters

Re: Copy SAS views from one server to another

Copy SAS views from one server to another

Re: DI jobs to Base SAS jobs (EG jobs)

Re: DI jobs to Base SAS jobs (EG jobs)

Re: DI jobs to Base SAS jobs (EG jobs)

Re: DI jobs to Base SAS jobs (EG jobs)

DI jobs to Base SAS jobs (EG jobs)

Re: Can SAS give different output when we have duplicates in join

Re: Can SAS give different output when we have duplicates in join

Can SAS give different output when we have duplicates in join

Re: Comparing two records on key values and applying filters

Comparing two records on key values and applying filters

Re: Report creation for reconciliation - best approach

Re: Report creation for reconciliation - best approach

Report creation for reconciliation - best approach