About Sandhyaa

Sandhyaa · ‎02-13-2013

Patrick, We are creating a library for SQL server database using ODBC Engine. Where to define the macro variable for the schema while creating the Library?

Sandhyaa · ‎02-12-2013

src Col seq no a 1 a 2 a 3 b 1 b 2 c 1 Based on one of the source columns, a sequence no has to be generated. If the source value changes, then the sequene no must start from one. Is this is possible in SAS DI without using user-written transformation?

Sandhyaa · ‎01-16-2013

so, cant we achieve this without going for an user written transformation?

Sandhyaa · ‎01-16-2013

we have a requirement like this. src src col1 src col2 src col3 a a1 a123a234 b b1 b123b234b345 tgt tgt col1 tgt col2 tgt col3.1 tgt col3.2 a a1 1 a123 a a1 2 a234 b b1 1 b123 b b1 2 b234 b b1 3 b345 We need to split the src_col3 into multiple rows such that in each row, the tgt_col3.2 will have only 4 characters. The no. of rows that can result from a single row is dynamic as it is based on the data length of the src_col3. tgt_col3.1 is a sequnece no whcih denotes, for each tgt_col1 ie."a", how many rows are made up. Can this be achieved using SAS DI with any transformation?

Sandhyaa · ‎01-15-2013

Thanks Linush. Its working fine.

Sandhyaa · ‎01-11-2013

Linus, could you please me more clear. I wanna know how can we achieve this using a sort transformation alone? Is there any option in SORT transformation where we can sort within a group and filter only one record out of the group?

Sandhyaa · ‎01-10-2013

In the example i mentioned above, i want to group the columns based on Col_1 and want to sort within the group, so that i can pick the first record from each group. This is the requirment.

Sandhyaa · ‎01-10-2013

With sas sort transformation, we dont have a group by. I want to order the the fields within a particular group and i need one record from each group as the output. My source is SAS dataset. Not teradata. So could you please tell us a possible solution to achieve this?

Sandhyaa · ‎01-08-2013

The requirement is like this. Col_1 Col_2 123 Abc 123 Bcd 234 Abc 234 Bcd And i want the output of reords like this Col_1 Col_2 123 Abc 234 Abc Here i meant, partition_by Col_1, order_by Col_2 Asc, qualify the statments whose row_number =1 It typically means assigning a row number after the order by and partition by and fetch the records with row_number =1 I can find this function in SAS DI if the source is a Teradata table. But not sure of how to implement this for SAS Datasets.

Sandhyaa · ‎01-08-2013

We have a requirement to group the records based on a field and extract only one record from each group. Kind of using statements like, qualify(row number()over(partition by order by)). How to implement this in SAS DI over SAS Datasets?

Sandhyaa · ‎12-12-2012

We have a requirment to use same jobs for same type of tables from two different database schemas of SQL Server. So can we use the same jobs by parameterizing the library reference of the tables in SAS DI? Is this possible?

Sandhyaa · ‎12-09-2012

Actually, we need to write an entry into the audit log if the job fails. Since, the job is running till postcode, we have written the code for audit log in the job's post code based on the return code value. If the job is not going to be executed till the job's post code on failure cases, then we need to handle this code at the transformation level. For this purpose only, we just want to confirm.

Sandhyaa · ‎12-09-2012

By fails, i mean that, the transformation may fail for any reason, ie. a lookup table is missing or anything else like that, error code > 0 Can you just give me a scenario where the job wont run till postcode if anything fails inbetween. Because, for all possible error scenarios, the job is running till the post code.

Sandhyaa · ‎12-07-2012

Is it always , when a transformation in a job fails, the successive transformations will get executed upto the job's post code?

Sandhyaa · ‎12-05-2012

a. This job is not creating lib_comm.TBL_COM_ERR_MASTER. It is already created. b. &GEN_LOG is a macro global variable and it is also resolved in the job. c. Failure occurs before the job. The error is like "this step is stopped" because error occuered before this export.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: can library name be parameterized in sas datasets?

sequence no based on an input field

Re: how to split a column into rows dynamically in sas di?

how to split a column into rows dynamically in sas di?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

how to implement qualify statement in SAS DI?

Re: can library name be parameterized in sas datasets?

sequence no based on an input field

Re: how to split a column into rows dynamically in sas di?

how to split a column into rows dynamically in sas di?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

Re: how to implement qualify statement in SAS DI?

how to implement qualify statement in SAS DI?

can library name be parameterized in sas datasets?

Re: Job execution when a transformation fails

Re: Job execution when a transformation fails

Job execution when a transformation fails

Re: job's post code execution on failure case