I_Kong_SAS Tracker

Re: Is it possible to open a welcome card after you press dismiss in SAS Mobile BI?

I_Kong_SAS — Wed, 21 Sep 2016 19:49:50 GMT

Hi BLE, in advanced settings, there is a Restore default settings toggle button that can bring back the welcome message by restoring the app to default settings. However, it will remove your report and server settings as well. If you are looking for the help text, you can click ? and navigate to More about the App>More about SAS(R) Mobile BI and Your Portfolio.

Re: Executing a SQL query from the Data Preparation in SAS Visual Analytics

I_Kong_SAS — Thu, 11 Aug 2016 20:03:02 GMT

Hi raulet69, if I followed your question correctly, if you start with the UI and then unlock the generated code to enter your code: in the UI you should see a Properties panel where you can set the view option. In the Output panel you set a name for this view. At the bottom of the generated code, this name is then used in a data step with a set statement. Give that a try. Hope that helps.

Re: Report structure not looking good when export in PDF file

I_Kong_SAS — Thu, 26 May 2016 21:08:03 GMT

Hi Anand, a different approach might work well if you are able to incorporate a few additional steps: if you have SAS Add-In for Microsoft Office, you could bring your VA report objects into an Office document and adjust the layout or add non-VA objects, then export to PDF with a similar layout. Also, SAS Mobile BI may be another good alternative if the reports are primarily needed for users on the go.

Regards,
I-Kong

Re: Downloading Yelp Reviews

I_Kong_SAS — Thu, 26 May 2016 13:38:44 GMT

Hi Idenney. Yes. You can make the text variable a document collection in the left panel - right before making the word cloud.

Re: Faxebook statistics

I_Kong_SAS — Wed, 25 May 2016 14:06:54 GMT

Hi Jesper, SAS VA gathers text primarily for text analysis in this case, although some statistics are included. For more statistics, you may want to export csv from your Facebook Insights or use the Facebook Insights Pages API (https://developers.facebook.com/docs/platforminsights/page https://developers.facebook.com/docs/graph-api/reference/v2.6/insights)

Best,
I-Kong

Re: Downloading Yelp Reviews

I_Kong_SAS — Mon, 23 May 2016 16:47:20 GMT

Hi Idenney, that sounds very interesting. I don't know if your client has a way to access the reviews on their own businesses. I would hope so. I'm not too familiar with the Yelp API, but it appears from the FAQ: https://www.yelp.com/developers/faq and ToS that they do not allow full review text access by third parties via API or "scraping" (a SAS or other program to efficiently retrieve this text via API or spiders/robots). Assuming you can legally and technically retrieve this text you'll need a unique document ID for the variable you want to make a document collection. For example, if you have a Review variable and a ReviewID variable, right click on Review and make it a Document Collection, then select ReviewID as the Document ID.

Re: Downloading Yelp Reviews

I_Kong_SAS — Mon, 23 May 2016 16:24:22 GMT

Hi Idenney, can you tell us a little more about your data and what you want to do? Unfortunately Yelp doesn't make full text of reviews available for this kind of text analysis. There is an academic challenge (non-commercial use) with some data and sample questions for researchers: https://www.yelp.com/dataset_challenge

Re: Don't want hover help with axe names

I_Kong_SAS — Thu, 05 May 2016 21:41:28 GMT

Hi xangadix, why do you want the hover to not appear? It looks like it may be interfering with your legend? Also, if you are using 7.3 and use the modern viewer, the hover effect does not happen.

Re: Unable to Schedule a data query for less than an hour time interval

I_Kong_SAS — Thu, 05 May 2016 21:35:38 GMT

Hi nattargekar, the smallest interval is one hour. It generates a .sas file. You might be able to get more advanced or creative with SAS Management Console.

Regards,

I-Kong

Re: Scheduling Error SAS VA: Data Builder

I_Kong_SAS — Thu, 05 May 2016 21:18:21 GMT

Hi Balraj, it sounds like you are likely hitting the condition described in the Note where an external user is a user on the operating system ; this user needs access to the location where a .sas file will be saved. There is also some more detail here: http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1ddpa5p0q2x28n1hgkexlzh7v5y.htm

Regards,

I-Kong

Re: Unable to find time trigger saved earlier in Data Builder query scheduler

I_Kong_SAS — Thu, 28 Apr 2016 15:35:54 GMT

Hi nattargekar, you should be able to select the event, then click Edit. If that does not work, you may need to contact Tech Support (http://support.sas.com/ctx/supportform/createForm). Thanks. I-Kong

Re: A match for marketers: SAS Visual Analytics 7.2 and Google Analytics

I_Kong_SAS — Tue, 29 Mar 2016 03:40:01 GMT

Thanks for spotting that @MichelleHomes! See you there! Bring some questions or send some in early!

Re: Uncompress Data while Loading to LASR from HDFS

I_Kong_SAS — Wed, 08 Jul 2015 14:06:00 GMT

Hi Shivam, the data is memory mapped so if it is compressed on disk, it will be compressed in memory as well. Depending on the lifecycle of your data, you might consider keeping the data uncompressed while it is "fresh" and in use a lot, then later compressing it for backup. For example, you might be using the current year's data frequently now but using the previous year's data less frequently so you could consider compressing the older data.

Hope that helps,

i-kong

Re: Will the young German team conquer the 2015 FIFA Women’s World Cup?

I_Kong_SAS — Mon, 06 Jul 2015 19:48:49 GMT

It's interesting how the pattern applied to the final four teams, with the oldest of the four semifinalists winning the tournament and the youngest finishing in fourth place: USA, Japan, England, Germany. Wonder if the new FIFA rankings will have a stronger correlation with team average age now.

Re: Integration with D3

I_Kong_SAS — Mon, 06 Jul 2015 14:35:39 GMT

Hi Danny, you might want to check out Graph Builder first to see if there is customization you can do for your customization there. I haven't used D3, but I believe the way to incorporate D3 for your customer would need to be via stored processes (include your D3 javascript inside the stored process).

Regards,

I-Kong

Re: Will the young German team conquer the 2015 FIFA Women’s World Cup?

I_Kong_SAS — Tue, 30 Jun 2015 19:27:47 GMT

Interesting analysis, but experience will prevail over youth in tonight's game. We'll have to see if there is a new pattern in the data in 2019.

Re: Integration with AdobeMarketing

I_Kong_SAS — Fri, 22 May 2015 15:07:36 GMT

Hi Praveen, it may depend on what access you have to your Adobe or other cloud data and what SAS tools you are using. For example, SAS Visual Analytics 7.2 has built in access to Google Analytics data. There is a post about that topic here:. If you are working with a SAS reps or consultants, they can help you with your specific cases, but please post back if you have some general questions or updates.

Re: A match for marketers: SAS Visual Analytics 7.2 and Google Analytics

I_Kong_SAS — Wed, 20 May 2015 14:30:37 GMT

Thanks for the great ideas on this topic and others, Michelle. We'll check into those and other links as well.

Re: A match for marketers: SAS Visual Analytics 7.2 and Google Analytics

I_Kong_SAS — Wed, 20 May 2015 14:28:39 GMT

jim32353253252352, check out this article: How effective is your corporate Facebook page?

For your Twitter question, can you send us more details?

Re: A match for marketers: SAS Visual Analytics 7.2 and Google Analytics

I_Kong_SAS — Mon, 18 May 2015 14:11:28 GMT

Hi Michelle! Thanks for your interest. Behavior is about page paths and pageviews, similar to the Behavior section in your Google Analytics reports. The data is imported at an aggregate level (grouped by dimensions) so it mainly lends itself to reporting. You can find out more about the specific metrics and dimensions in the Google Analytics docs: Dimensions and metrics - Analytics Help or in more detail in this reference guide: Dimensions & Metrics Reference