About gabriel_k

gabriel_k · ‎07-19-2018

Just usual dataset with both numeric and character variables. The problem is that the tables are probably to large to run on a server set up.

gabriel_k · ‎07-19-2018

Is there other option? I get the insufficient memory error.

gabriel_k · ‎07-19-2018

Hello, I have large sas tables (100 mln lines) and up to 200 columns in each one. Could someone share a code that would produce a summary statistics on both categorical and numeric variables. I need something similar but more stats (count, min, max, avg, std, q1, q3...etc): https://communities.sas.com/t5/SAS-Procedures/Count-missing-values-of-100-variables-in-with-column-output/td-p/235075/page/2 Thanks in advance.

gabriel_k · ‎08-01-2017

Hello, I see that there is some kind of Git integration in SAS EG 7.1. There is Git installed on my machine and I can commit changes and then view the history of the local SAS repo. Is there a way to push and fitch from SAS EG or should I use Git ?

gabriel_k · ‎07-11-2017

My question actually is about how to intagrate this all and not about the magic of MPRINT option, not to say more. Specificaly when thete is 50000 lines of code and lots of marco variables out of macros ?

gabriel_k · ‎07-11-2017

How would i write code that is out of Macros ?

gabriel_k · ‎07-10-2017

Hello, I have a large project with lots of macros and included programs (SAS 9.3 on WIN server via EG 7.1 32-bit). The idea is to produce executable code in external .sas files after the project execution. I have found this article and would like to do exactly they are doing: http://www.lexjansen.com/pharmasug/2002/proceed/TechTech/tt14.pdf Could someone post the code transforming MPRINT Outputs to executable code?

gabriel_k · ‎07-10-2017

Hello, I have found this article and would like to do exectly they are doing. http://www.lexjansen.com/pharmasug/2002/proceed/TechTech/tt14.pdf I have contacted autors but don't have an answer so far. May be you have seen an example of a similar program on the internet?

gabriel_k · ‎06-21-2017

Never mind, its fine, I'll run first the code that defins variables.

gabriel_k · ‎06-21-2017

Is it possible to make SAS interpret the variables also? For instance if I have a DATA step the macro variables inside are not interpreted in generated code.

gabriel_k · ‎06-19-2017

Probably there was some problem with server I've tried it later and it works fine, that is exectly what I was looking for. thanks a lot:)

gabriel_k · ‎06-19-2017

filename mprint "...\mysasfile1.sas"; options mprint mfile; run; options mprint mprintnest source source2; %macro test(initial); proc print data=sashelp.class; where substr(name,1,1) eq "&initial."; run; %mend test; %test(A); %test(J); Trying to run your code with the parts mentioned in the article, everything goes smooth no errors ... but code is not printed to the file. What could it be?

gabriel_k · ‎06-15-2017

There is some macro code, sas base code, it exports and imorts data.. does lots of stuff, the question is how to keep track of final code executed and try to have it in the file to rerun the later in case of problems or something.

gabriel_k · ‎06-15-2017

I mean the code generated by SAS macros you are wright, and it would be great to have it appart of the log that it is possible to execute this code directly in case I need.

gabriel_k · ‎06-15-2017

Hello, We have a SAS code executed regulary in our data management department. Programs are pretty large (20000 lines) with lots of parametres. Every time we save logs to external files and I wonder if it is possible also to save interpreted code (all variables evaluated) or the base code once executed to external text file too? Thanks in advance for your ansvers.

Online Status	Offline
Date Last Visited	‎07-19-2018 11:36 AM

Re: sas large dataset summary statistics

Re: sas large dataset summary statistics

sas large dataset summary statistics

SAS Enterprise Guide 7.1 Git integration

Re: Post-processing MPRINT Outputs to Generate Macro-Free Code

Re: Post-processing MPRINT Outputs to Generate Macro-Free Code

Post-processing MPRINT Outputs to Generate Macro-Free Code

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

SAS Enterprise Guide 7.1 Git integration

Re: sas large dataset summary statistics

Re: sas large dataset summary statistics

sas large dataset summary statistics

SAS Enterprise Guide 7.1 Git integration

Re: Post-processing MPRINT Outputs to Generate Macro-Free Code

Re: Post-processing MPRINT Outputs to Generate Macro-Free Code

Post-processing MPRINT Outputs to Generate Macro-Free Code

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

Re: Export executed code to external file

Export executed code to external file