cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
SYN
‎06-28-2025
  • 48 Posts
  • 0 Likes Given
  • 0 Solutions
  • 4 Likes Received

Re: CSV external file load into DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-19-2012 08:37 PM
‎06-19-2012 08:37 PM
Thank you very much for your help. ... View more

CSV external file load into DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-19-2012 02:37 PM
‎06-19-2012 02:37 PM
I am loading CSV external file into DI 3.4. I am using delimiters Comma and TAB for my CSV file. Here I am uploading file correct only one problem i am getting. Last column I am getting the value  "" in all rows for that column. Can you please help me to resolve this problem. Thank you. ... View more

Re: Taking History from sas tables to sas tables in DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-19-2012 02:32 PM
‎06-19-2012 02:32 PM
Thank you very much Patrick. ... View more

Re: Taking History from sas tables to sas tables in DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-19-2012 01:16 AM
‎06-19-2012 01:16 AM
Thank you Patrik, We taken the approach like below. 1st source SAS table(Fresh 36 months data)     -     Target History SAS table(need to extract only 1 month data ie last 36th month data) Please help me to get only last 36th month data into target table. Every month source will get 3 years of data(36 months data). Need to extract last one month(36th month data to target table). 2nd and 3rd SAS source tables(Fresh 1 month data)    -     Target history SAS tables will take one month data before loading fresh data into source tables. Please help me to move data every month to history and next month it has to append. Please help me for these two approaches. Thanks in advance ... View more

Taking History from sas tables to sas tables in DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-17-2012 12:19 AM
‎06-17-2012 12:19 AM
I have three 3 csv source files and created 3 target tables. I got the data in 3 target tables using my DI studio 3.4 job. These three target tables will replace every month with fresh data. 1st table will replace with latest last 36 months of fresh data. 2nd and 3rd tables will replace with last 1 month of fresh data. My requirement is I have to take history from these 3 tables and put it in 3 target history tables. 1st table I have to move last 1 month data(means 36th month data) to history and next month i need to append the data in hisrory and so on. 2nd and 3rd tables every month move data to history table and next month onwards append the data in history table. Can you please help me which approach is good for 1st table and which approach is good for 2nd and 3rd table. Thanks in advance. ... View more

Re: How to pass macro parameter to File reader transformation to read ...

by Obsidian | Level 7 in SAS Data Management
‎06-14-2012 09:15 AM
‎06-14-2012 09:15 AM
How to pass macro parameter to File reader transformation to read latest csv file? Please I have this question in SAS DI 3.4. Thank you. ... View more

How to pass macro parameter to File reader transformation to read late...

by Obsidian | Level 7 in SAS Data Management
‎06-14-2012 09:09 AM
‎06-14-2012 09:09 AM
I have one situation, I have 3 different .CSV files and using file reader tranformation I have build the job for all 3 csv files. I want to pass latest files every time using my user written code. Can you please help me how to pass macro parameters. Is there any simple way please let me know. Thanks in advance. ... View more

Re: gzip file in unix server read into di Studio 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-11-2012 09:43 PM
‎06-11-2012 09:43 PM
Thank you for the valuable suggetion LinusH. I have given below code in job preprocess, job successful however file not uncompressed. Please advise. Thanks in advance. /* Access the data library */ LIBNAME xxx  "/aaa/dddd/ssss/file.gz" ; %rcSet(&syslibrc); /* gunzip file */ x gunzip "file.gz"; ... View more

gzip file in unix server read into di Studio 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-10-2012 11:21 PM
‎06-10-2012 11:21 PM
Hi All, I have one .gz file in unix server location /aaa/dddd/ssss/file.gz file.gz having .csv file inside. Can any one provide me the command to gzip this file use in DI studio 3.4 job. Thanks in advance. ... View more

Re: SAS Macro code using in SAS DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-04-2012 09:30 AM
‎06-04-2012 09:30 AM
Let's start like this. This macro crating 5 tables dynamically and store it in one folder. No need to crate physical structure of tables. This macro code will create more variables every next run. Here my question is how to point these macro to the target tables storing in folder. ... View more

SAS Macro code using in SAS DI 3.4

by Obsidian | Level 7 in SAS Data Management
‎06-04-2012 08:57 AM
‎06-04-2012 08:57 AM
SAS macro code taking 3 input tables and creating 5 tables dynamically using macro code. I am using this code in SAS SI 3.4. Could you please tell me how proceed for this. Any suggession please. ... View more

Re: Bring SFT server files to unix server using SAS Data Integration 3...

by Obsidian | Level 7 in SAS Data Management
‎05-30-2012 07:31 AM
‎05-30-2012 07:31 AM
Yes you are correct. I am not expecting exact code for this task. Just I need suggestion to bring the files. SFT means Secure FTP server. It is a internal mailbox server having input/output/sent items. We need to pickup the files from outbox and put it in unix server. Please suggest. ... View more

Bring SFT server files to unix server using SAS Data Integration 3.4 J...

by Obsidian | Level 7 in SAS Data Management
‎05-30-2012 05:24 AM
‎05-30-2012 05:24 AM
I have one requirement in SAS Data Integration 3.4 Job. I have some files with prefix XXX_* in SFT mailbox server. My requirement is to bring these files to unix server using Data Integration 3.4 Job. Can any one provide me the user written code for this task. Thank you. ... View more

Re: DATA INTEGRATION STUDIO 3.4 USER WRITTEN CODE?

by Obsidian | Level 7 in SAS Data Management
‎05-28-2012 10:59 AM
‎05-28-2012 10:59 AM
Thank you Shiva. I will try this. ... View more

Re: SAS DI Studio .CSV file?

by Obsidian | Level 7 in SAS Data Management
‎05-28-2012 10:43 AM
‎05-28-2012 10:43 AM
Thank you Shiva. My question here is I want to use the external file directly from server to job Like File reader transformation. Is it possible? Other wise, I need to create external file beofre it self then only I have to use in job - File reader transformation? Please clarify. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-28-2025 05:07 AM
Likes from
View All
Quick links