leogaller Tracker

Re: For Var 1 break Var2 by all data

leogaller — Thu, 28 Jul 2016 19:44:15 GMT

Many thanks Ballardw, your explanation was perfect! \o/

Re: For Var 1 break Var2 by all data

leogaller — Thu, 28 Jul 2016 19:35:57 GMT

Hi Ballardw!

Have already brought the data into SAS?

Yes, the data is already in SAS.

Do you need the original variable with multiple values when done?

Yes, I need, because later I will join the result dataset with another one.

Are there any other variables to consider?

Not now. I just need these two right now.

What to do if the column 2 variable is blank?

There is no blank values in variable 2 because I treated that situation when I was importing the data into SAS.

Should there be any output (remove the record) or have the line basically output as is?

Yes, I need an output just with the 2 variables.

BTW, the image of your example data seems to show a period between the values on the third row. Can that possibly occur?

Actually that is a comma, I want to break the data using that comma.

For example, write the value o var1, if var2 has two values separated by comma, I want to repeat var1 for each value in var2 that are separated.

Thanks for your attention and support! 🙂

Here is the code for sample data:

data sample_data;
	input number $ PreExecution $20.;
	datalines;
	5044 5297,5367
	5055 5297,5367,5467
;

LeoGaller

For Var 1 break Var2 by all data

leogaller — Thu, 28 Jul 2016 18:27:49 GMT

Hi guys!

I am very new in SAS Base programming, I would like of ideas about the following situation:

I am importing an excel spreadsheet, and on cell 1 I have the ID and on cell 2 multiple values separated by ','.

What I need is to repeat the value for cell 1 for all the values of cell 2 in different lines.

See the example below:

What I have

What I need

Any ideas?

Thanks in advance!

LeoGaller

Re: Configuring SAS metadata export type in DI

leogaller — Tue, 17 May 2016 12:43:45 GMT

Thank you!

Re: Configuring SAS metadata export type in DI

leogaller — Thu, 12 May 2016 19:31:07 GMT

Hi LinusH!

I need to export the metadata of some tables to use in Erwin data modeler.

I am trying to export tables metadata, located at the File Tab -> Export -> Metadata. Then I am getting the following error:

I have consulted the administration of the SAS environment, but, no answers at this moment.

Thank you!

Leonardo Galler

Configuring SAS metadata export type in DI

leogaller — Thu, 12 May 2016 14:15:28 GMT

Hi guys!

When I try to export tables metadata from DI I am getting the following error:

'No export types found. Please consult documentation on how to load export types.'

I could not find in the documentation, any of you knows how to configure the export types in DI?

Thank you in advance!

Leonardo Galler

Re: ABTs in Oracle

leogaller — Tue, 10 May 2016 21:07:43 GMT

Thanks for your anwser LinusH!

Re: ABTs in Oracle

leogaller — Tue, 10 May 2016 21:07:14 GMT

Thanks Tom, I will contact you! Best regards!

ABTs in Oracle

leogaller — Tue, 10 May 2016 20:58:20 GMT

Hi guys!

I´m working on a client where some ABTs are huge, 5Tb for example. Those ABTs are not disponible for users yet, but, our fear is that when they start to access that tables, all the querys start to get too* slow, and even not running or returning error.

My manager asked me if it is possible to move those abts that are in SAS environment to Oracle.

Is it possible? Move the abts to Oracle and continue using the scoring tools that we have?

How can I create a hardware requirement based in the size of the ABTs, quantity of users that will access it simultaneously?

I would love hear your opinions! \o/

SAS 9.4 - Credit Score for Banking

Leonardo Galler

Betreff: SAS VA Certification

leogaller — Mon, 09 Nov 2015 21:48:52 GMT

Hi Sven!

I did the exam a few weeks ago and, fortunately I've passed.

All the advices given by Michelle helped me a lot, but I believe the most important thing is that I did the Visual Analytics Fast Track and used the materials of the course for my preparation.

You don´t need to take all the course again, there 3 main areas that you must know:

1 - Data Builder

2 - Data Explorer

3 - Data Designer

You don´t need to study the administration of the tool. I suggest, if it is possible, to take the course, and then review those three areas and I believe you can pass the exam.

Good luck!

Re: SAS VA Certification

leogaller — Thu, 22 Oct 2015 09:58:18 GMT

Hi Surajit!

I will do what you said, thanks for helping me!

Best regards!

Re: SAS VA Certification

leogaller — Wed, 07 Oct 2015 23:00:02 GMT

Thank you so much Michelle!
I will do what you said! And happy for you support and attention! 🙂

Re: SAS VA Certification

leogaller — Wed, 07 Oct 2015 19:46:19 GMT

Hi Michelle, thank you!

I´ve did the Visual Analytics Fast Track course and have the materials, I am thinking about doing it all again and watch the videos at the online learning.

On your self study which materials did you use?

Best regards!

SAS VA Certification

leogaller — Wed, 07 Oct 2015 18:37:57 GMT

Hey guys!

I hope all of you are doing good!

I´m scheduled to take the SAS Certified Visual Business Analyst: Exploration and Design Using SAS Visual Analytics exam, could anyone of you help with tips, materials and places where I can take test exams for this certification.

Any help will be appreciated!

Thank you!

Re: HTML5

leogaller — Fri, 14 Aug 2015 11:34:05 GMT

Yay! \o/\o/\o/

Thanks annabrown !!!

HTML5

leogaller — Thu, 13 Aug 2015 19:36:45 GMT

Hey guys!

Can anyone tell me if SAS has plans to change VA to HTML5 instead of flash?

Thank you!

Re: User connected

leogaller — Wed, 29 Jul 2015 12:21:27 GMT

Hi Joy!

Thank you!

I´m using the classic home page for release 7.1.

User connected

leogaller — Tue, 28 Jul 2015 16:24:24 GMT

Hey guys!

There is a way to show the name of the user that is connected to the VA at that moment?

I see that the name of the user that is currently using the VA is not shown anywhere in the screen.

Thanks for your support!

Leonardo Galler