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: 
pedromagalhaes
‎09-01-2015
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Data Lineage - SAS Script

by Fluorite | Level 6 in SAS Data Management
‎07-24-2015 06:33 PM
‎07-24-2015 06:33 PM
Imagine the situation that i have only SAS Scripts, dozen of them. The business users, most of then, use EG to create their own SAS Scripts. Then these scripts start to be prodcutive (run periodically). The final user dont want to pass this workflow to the IT people, which are using SAS Workflow Studio. They want to have the flexibility to edit these SAS scripts. So the business user are responsible to support these "ETL" processes, running using EG (SAS Scripts) So the tool give a Big Picture, how the sources are connected, dictionary, documentantio... ... View more

Data Lineage - SAS Script

by Fluorite | Level 6 in SAS Data Management
‎07-23-2015 06:31 PM
1 Like
‎07-23-2015 06:31 PM
1 Like
Hello, I am Java/SAS developer and I am building a tool that helps me do impact analysis, document the workflow process, generate a data dictionary. How the tool works: I have many SAS scripts from my customers storend in tree folder. The tool reads and parses all SAS scripts and generate a dependency sources graph. Using some pre define tag stored in SAS Script, is possible to generate a dictionary about data. So it help me too see the big picture of all SAS Scripts, how each sources dependens, do impact analysis, document the process and data. It was very useful to me. I attached a screenshot from the tool. (Sem título - Images Host) I would like to know if it make sense for other SAS Consultants? I would like to provide the tool for the community, just to see if it make sense.ive ... View more

Re: Convert CSV file to SAS Table (sas7bdat)

by Fluorite | Level 6 in SAS Programming
‎10-14-2014 05:43 PM
‎10-14-2014 05:43 PM
If SAS make possible to generate a (sas7bdat) i will give him a FREE user... I translate my CSV fil to (sas7bdat) and now only a user with SAS can read it. So the user has to buy SAS license. So i think this argument is invalid. ... View more

Re: Convert CSV file to SAS Table (sas7bdat)

by Fluorite | Level 6 in SAS Programming
‎10-14-2014 02:57 PM
‎10-14-2014 02:57 PM
So, I dont have a way to create a sas7bdat ? I will have another file (similiar to CSV) that i need to import to SAS. Why SAS dont give, for example, a DLL to create the sas7bdat? i really doesnt understand.. ... View more

Re: Convert CSV file to SAS Table (sas7bdat)

by Fluorite | Level 6 in SAS Programming
‎10-14-2014 10:19 AM
‎10-14-2014 10:19 AM
I know that R is language. But what i actually need to do is to call this function (something like this): write.xport(df = test.df, datafile = 'test.sas7bdat', codefile = 'test.txt', package = "SAS") Or i call the function, or execute a R Script for load the SAS table. ... View more

Re: Convert CSV file to SAS Table (sas7bdat)

by Fluorite | Level 6 in SAS Programming
‎10-14-2014 10:16 AM
‎10-14-2014 10:16 AM
We have a ETL process. The ouput of the process is a csv file, in different formats. The user always get this file and import using SAS. I would like to import it for him generating a SAS Table, using a library/DLL. That's the use case. ... View more

Re: Convert CSV file to SAS Table (sas7bdat)

by Fluorite | Level 6 in SAS Programming
‎10-14-2014 10:11 AM
‎10-14-2014 10:11 AM
Thanks for the response! The next challenge is to call a R function from Java/C++, for example. If anyone know a library to C++ or Java, it will be amazing! ... View more

Convert CSV file to SAS Table (sas7bdat)

by Fluorite | Level 6 in SAS Programming
‎10-14-2014 09:51 AM
‎10-14-2014 09:51 AM
I have a huge CSV file, and i want to convert it to a SAS Table. I know that i can use SAS to make an import, but i am interested in create the SAS table using, for example, C++, python or any available library. For example, in SPSS i can easily create a SAS Table using the command "Save as type" to SAS v9+ Windows (*.sas7bdat). And it not necessary to have the SAS installed. Is there any library to make this? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
View All
Likes from
View All
Quick links