pedromagalhaes Tracker

Re: Data Lineage - SAS Script

pedromagalhaes — Fri, 24 Jul 2015 22:33:10 GMT

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...

Data Lineage - SAS Script

pedromagalhaes — Thu, 23 Jul 2015 22:31:24 GMT

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

Re: Convert CSV file to SAS Table (sas7bdat)

pedromagalhaes — Tue, 14 Oct 2014 21:43:44 GMT

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.

Re: Convert CSV file to SAS Table (sas7bdat)

pedromagalhaes — Tue, 14 Oct 2014 18:57:03 GMT

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..

Re: Convert CSV file to SAS Table (sas7bdat)

pedromagalhaes — Tue, 14 Oct 2014 14:19:17 GMT

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.

Re: Convert CSV file to SAS Table (sas7bdat)

pedromagalhaes — Tue, 14 Oct 2014 14:16:32 GMT

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.

Re: Convert CSV file to SAS Table (sas7bdat)

pedromagalhaes — Tue, 14 Oct 2014 14:11:11 GMT

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!

Convert CSV file to SAS Table (sas7bdat)

pedromagalhaes — Tue, 14 Oct 2014 13:51:51 GMT

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?