mojerry_realdolmen Tracker

Re: updating datasets online via UI

mojerry_realdolmen — Tue, 27 Jun 2017 19:13:16 GMT

office add-in? you can retrieve your dataset, modify it, reload it.

Re: Lastest release of Adobe Flash Player (26.0.0.126) causes problems with Designer and Data Builde

mojerry_realdolmen — Thu, 15 Jun 2017 10:34:03 GMT

thanks for the tip, this is a workaround so users can continue!

Re: Lastest release of Adobe Flash Player (26.0.0.126) causes problems with Designer and Data Builde

mojerry_realdolmen — Thu, 15 Jun 2017 09:59:47 GMT

yep, thanks for this feedback. My client is now crying 😉

Re: Count distinct values when missing fields/Notmissing fields

mojerry_realdolmen — Wed, 03 May 2017 13:40:22 GMT

the easiest way is to make a calculated item and working with IF then else case.

IF ( 'column'n Missing )
RETURN 1
ELSE 0

this will flag all your missing columns. The sum will tell you how many cells are missing.

you can use the NotMissing to count the number of filled cells/rows.

Re: Help: ERROR: DBMS type EXCEL not valid for import.

mojerry_realdolmen — Sat, 31 Dec 2016 10:52:31 GMT

Hi,

If you're using eguide 64 bit then you need to check if your office installation is also in 64 bit.

oter solution is to use the access to pc file server.

kind regards

Re: How do I get to the Geo Maps server from behind a firewall

mojerry_realdolmen — Mon, 13 Jun 2016 08:10:46 GMT

as there is an issue with ntlm authentification the "easiest" way is to explain to IT that you just need access to a specific website to retrieve ineractive maps. Give them the different URL as listed above but depending on the system used they'll need to provide the IP address to open the gate 😉

Re: How do I get to the Geo Maps server from behind a firewall

mojerry_realdolmen — Wed, 20 Apr 2016 11:36:07 GMT

a bit late :

Internet connection

Source

Client

Target

Component accessed

Port

Direction

SAS Node/Server Host

SAS Web Application Server

opnsta.sas.com

opnstb.sas.com

opnstc.sas.com

OpenStreetMap server

80/443

Outbound

Re: Failed to create signature file.

mojerry_realdolmen — Sat, 20 Feb 2016 17:49:22 GMT

good question,

You should have/create a group where the sas users are existing.

No rights means no import.

kind regards

Re: Failed to create signature file.

mojerry_realdolmen — Tue, 12 Jan 2016 09:14:42 GMT

signature file is created by SAS. So you should empty the folder and then retry this.

Do you have the same error message?

is it wintel or linux running? If linux you can execute the setuid.

Re: Failed to create signature file.

mojerry_realdolmen — Wed, 16 Dec 2015 09:32:15 GMT

To figure out where the signature file location is :

Open SMC.

Right-click on Environment Management > Server Manager > Public LASR Analytic Server.

Then Properties > Options > Advanced Options > Additional Options and check the value for "Signature files location on server".

You can have this issue when the VA server is on autostart and autoload data.

Re: Using calculations or sas functions?

mojerry_realdolmen — Tue, 08 Jul 2014 12:24:30 GMT

to me the last code is the best looking. When you read it you know directly what it's doing.

the previous line is if your data is formatted but works as espected.

Re: Using calculations or sas functions?

mojerry_realdolmen — Tue, 08 Jul 2014 08:57:50 GMT

true, as I have multiple calculations I do this in an empty dataset 😉

Using calculations or sas functions?

mojerry_realdolmen — Tue, 08 Jul 2014 08:34:31 GMT

Hi,

I've got a technical question. What the best to use?

to know the number of days between two dates should I use datedif or just do the math? lastdate-firstdate gives also the number of days.

b=put(year(date),z4.)!!put(month(date),z2.) or b=put(date,yymmn6.)

working on dates where I have is stored in two macrovariables. The first one is numeric and the second one is a format (yyyy/mm/dd). If I want to know the day should I use the day(numdate) or do substr(date_char,9,2)

Re: Visual Analytics || newbie

mojerry_realdolmen — Wed, 19 Feb 2014 16:01:36 GMT

1. big chances you don't have it. How to know if you have it or not? ask IT 😉

2. Trough the web URL. but unfortunately I don't know the typical address used.

3. No, internet is not necessary

4. That's a SAS question.

5. SAS Dashboard portal.

I think VA is like a bazooka for killing a mosquito it you're thinking to just generate a few dashboards. But if after this you think to analyse your data and let the business look after it and generate new reports SAS VA is a great tool!