DSXchange

Used Convert and it worked. Then I came here to mention same and it was already in replies. Appreciate the help guys.

Unfortunately, after a second look, Routines might not be the option we are looking for at this point in time. From what I understand, if we take Parallel Routine path, we should make some changes in administrator to compile C++ code which would require a lot of approvals. And we also don't have a p...

Hi, I have a requirement to convert all alphabets in a field to convert to symbols. Right now, I am using EReplace to do this in a transformer. But this requirement is getting extended to multiple fields. I was wondering if I can write this code in a Routine and call it from each field so that we do...

Hi Chulett, thank you for the response. Yes, it is not XSV, it is CSV. Sorry about that. I am not converting spreadsheet to csv. My source is a DB. I am manually writing formulas in transformer. But when I output those Formulas either to CSV or XLSX spreadsheet, they look like formulas when we open ...

Hi, I have a scenario where I need to perform some estimations by picking data from different rows in a file. For example, I have 100 rows. I have to use data from rows 1 to 10 to determine value in row 20. But then I have to use that data in 20 to determine value from 11 to 19. So instead of calcul...

The reason why we didn't run unix commands in sequence job is sometimes, we will be asked to process just a single file and running the sequence will trigger multiple jobs. So, we decided to keep the whole logic in the parallel job itself. Honestly, I didn't think of using routines in parallel job. ...

Hi, So far we were downloading SAS datasets manually and using them as input in Datastage jobs. Going forward we have to connect to SAS server and pull data from Datasets directly. There is very limited information available on this online. Can you of you provide your thoughts on this? I have my ser...

Thank you everyone for the responses. I am getting extra CRs in file that we get from third party source. We figured it would be easy to fix it from our end. I used TR in before job sub routineto remove CRs and then used sed in seq stage filter to remove header and footer. I was trying to accomplish...

Hi,

I am already using sed '1d;$d' to remove first and last line of the file. Now I have to remove carriage return from the file too. I have commands that can do both tasks separately. But I'm trying to find a command that can do all tasks in one filter.

Any help is appreciated.

Thanks.

Yes. We were miss communicated that SAS is installed on the DS Server. It was not installed and the Admin's are working on it now.

Also, is there a way/code where we can access the SAS Dataset directly by connecting to server instead of someone else downloading and sending us the dataset?

I do have SAS Stage and SAS Parellel Dataset stage. Though, Looks like Parellel Dataset stage accepts only .ds files. I downloaded the SAS file and placed it on Datastage server and copied the code from here and tried to read the file using SAS stage. I got an error. My code: sas -source 'libname /o...

Hi, I have never worked on SAS and now we have a requirement to read data from SAS dataset. There is not much online that could help. I got access to SAS datasets using the SAS Enterprise Guide. Here are the details I have. When I logged into SAS Enterprise Guide, it asked me to create profile. I ga...

I came across a page in IBM KC website which explains how to write data to Excel files and these are the first three steps mentioned. 1. Double-click Unstructured Data stage to open the stage properties. 2. From the Stage tab, select Excel from the Document type list. 3. From the Write mode list, se...

I tried that. Below is the Info generated on DB2 Connector and Reject Sequential File. "db2Connector_OUT,2: Number of rows rejected: 64" "seq_Rejects,0: Export complete; 127 records exported successfully, 0 rejected." But this info is generated even when there are 0 rejects which...

Hi all, I have a sequential file capturing rejects from a db2 connector. I do not want to fail the job because I want to capture all rejects in file for analysis. But I want to abort the sequence. To achieve that, I want db2 connector to generate warnings when the rows get rejected into the sequenti...