tag:blogger.com,1999:blog-34495240587413484002024-11-05T20:44:00.500-06:00SASTechiesPlace to learn SAS and enhance your professional career...CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.comBlogger129125tag:blogger.com,1999:blog-3449524058741348400.post-20814411262143693802015-11-03T11:19:00.003-06:002015-11-03T11:31:41.861-06:00Tableau vs SAS Visual Analytics Lately, I have been working on using Tableau and SAS Visual Analytics for different clients at work… I have documented few differences of these products out of my experiences so far…. I will keep adding to this document as and when my time permits possible….I hope others can contribute to this document as well…. For the same SAS dataset that contains S&P 500 index companies by sector as theCN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-65080426606820025182015-11-03T09:46:00.001-06:002015-11-03T09:46:59.112-06:00SAS Online training Youtube Channel I have liked this set of you tube channel for SAS Online trainings...quite resourceful for beginners... https://www.youtube.com/channel/UCtjfX85t_HG9ojSunObROIACN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-38590284924739419212015-11-02T10:28:00.002-06:002015-11-03T11:20:28.378-06:00Tableau 9.1.1 can now read SAS datasets Hey Folks, I guessed this was coming...I just noticed that Tableau 9.1.1 can now read SAS datasets...Even Tableau Public has that option... The "Statistical File" option in the "Connect" menu allows to load the SAS dataset.... I'm sure SAS won't be happy in one way considering SAS VA adoptability....But the positive side of it is that more clients will learn and adopt dashboard CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-71663004086421696542015-08-31T09:31:00.000-05:002015-08-31T09:32:01.311-05:00 Hey All, Today I happened to read this good presentation about the Data Visualization Best Practices in Business Intelligence reports... There is a excellent graphic referenced here which summarizes which type of data visualization Graphic would be better for a particular data analysis... Data Visualization Best Practices 2013 from Jen Underwood CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-30919075602392835052015-06-08T15:28:00.000-05:002015-06-08T15:28:54.174-05:00Indian Baby Population in US by State Folks, I was going thru few visualizations on Tableau's website today and I came across this visualization Exploring the SSA Baby Names Dataset by one of the acclaimed Tableau professional....It made me thinking to explore of How many of those SSA baby names are of Indian American (Desi) descent... I found a website online that had a list of popular Indian baby names...I read the data into SAS CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-73765516349795683252015-06-08T06:48:00.002-05:002015-06-08T06:48:39.815-05:00Sending Email from within SAS and other options... Sending Email from within SAS and other options... FILENAME Statement EMAIL (SMTP) Access Method allows you to send electronic mail programmatically from SAS using the SMTP (Simple Mail Transfer Protocol) e-mail interface available at your site. But before you process the email code below check the values for the system options using Proc options for EMAILAUTHPROTOCOL, EMAILHOST, EMAILPORT, CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-39871722174592742552015-05-04T12:34:00.000-05:002015-05-09T00:36:02.861-05:00Photos from SAS Global Forum in Dallas Apr26 - Apr29 Photos from SAS Global Forum in Dallas Apr26 - Apr29 It was a wonderful Global Forum this year...A lot of enthusiastic people were enquiring at Qualex's booth...It was a great opportunity to meet and learn a lot from SAS folks at the Forum... It was awesome learning and knowing a lot of new SAS BI products and their implementations at various industries....The Hands-on CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0Dallas, TX, USA32.7766642 -96.79698789999997632.3496592 -97.442434899999981 33.2036692 -96.151540899999972tag:blogger.com,1999:blog-3449524058741348400.post-36852579496337082062015-04-12T11:58:00.000-05:002015-05-09T00:12:15.167-05:00SAS Global Forum in Dallas Apr26 - Apr29SAS Global Forum in Dallas Apr26 - Apr29 SAS Global Forum is happening in Dallas this year Apr26 - Apr 29... April end is around the corner Is anyone of my Blog followers going there... Qualex Consulting Services is a SGF Ruby Sponsor like every year.... Please meet me and my colleagues at the Qualex Booth if you are around...looking forward to it... One of my colleagues, TomCN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0Dallas, TX, USA32.7766642 -96.79698789999997632.3496592 -97.442434899999981 33.2036692 -96.151540899999972tag:blogger.com,1999:blog-3449524058741348400.post-3437052926570699972015-02-22T17:36:00.000-06:002015-05-09T01:10:54.015-05:00Socio-Economic Indicators around the World This Tableau viz shows the various Indicators around the world as of June 2014... Please feel free to play around with All the tabs up top and browse through the data.... The data is interesting, I will follow up with another viz with focus on BRICS countries. Source Link : The World Factbook 2013-14. Washington, DC: Central Intelligence Agency, 2014. https://www.cia.gov/libraryCN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-45001807569217316972014-12-22T16:00:00.000-06:002015-05-09T02:03:42.027-05:00SAS BI training session My SAS BI training session recording Direct Source Link CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-37421134522575781952014-11-12T00:45:00.000-06:002015-05-09T01:04:56.470-05:00Qualex's SAS Visual Analytics demo with Opera data Qualex's SAS Visual Analytics demo with Opera data Direct Source Link CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-20491525400210418912014-09-25T17:58:00.000-05:002015-05-07T18:05:47.622-05:00iQ Schedule Administrator by Qualex CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-25304915015129030422014-09-18T16:59:00.000-05:002015-05-10T03:19:35.017-05:00Using Gmail to send a message from a SAS ProgramToday I came across this interesting post about using GMAIL to send SAS outputs via SAS Email Statement...This is kind of an off topic as mostly it might not be helpful at work place...could use the same technique to send from outlook if you know the right SMTP port addresses... Please go thru the configuration steps in SAS EG... Direct Source Link CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-88924695460917293222014-08-24T17:55:00.000-05:002015-05-07T17:57:36.564-05:00SAS VA for Gaming - Implementation by QualexCN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-37353506228571465512014-07-23T06:36:00.000-05:002015-05-08T23:45:43.814-05:00Creating a Directory Listing Using SAS for Windows in TopDown orderHere I present a macro to Create a directory listing using SAS for Windows in TopDown order... SAS Institute has provided a macro to Create a directory listing using SAS for Windows....I have added additional steps to massage the results and provide a report which gives the results in descending order of the file size.... The macro provides options for - Traversing sub-dirs based on a CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-46275638074346826082014-07-07T16:18:00.000-05:002015-06-22T16:30:25.302-05:00Put distinct values of a variable in a SAS dataset to a macro variable As a SAS programmer, one would encounter many instances where one is required to create a comma or a pipe delimited list of dataset values from a dimension dataset and use that list to pull in records from a detailed transactions dataset…Usually that list is used in a SQL query or a Datastep’s IN clause. For eg. Get a subset list of car models of interest and query another fact transactions CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-65441219645590383062014-03-24T17:50:00.000-05:002015-05-07T17:54:31.777-05:00iQ-Sports Solution by Qualex CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-39229324662281872592014-03-04T14:23:00.004-06:002014-03-09T09:01:26.282-05:00SAS BI Training OnlineHey All... One of my friends wanted to post this for him... He would like to provide SAS BI training online for a fee...He would provide SAS BI material and Lab access online... Any body interested?...Please email sastechiesblog@gmail.com for more details. Duration: 45-50 hours Course Content: Business User Reporting Applications Use the SAS Add-In for Microsoft Office. Use SAS Web Report CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com3tag:blogger.com,1999:blog-3449524058741348400.post-73566293556582990862014-02-01T12:17:00.000-06:002015-05-08T23:44:40.079-05:00Building OLAP cubes with SAS Enterprise Guide...Watch the video for Building OLAP cubes with SAS Enterprise Guide…CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-84822150641128732702014-01-02T13:38:00.000-06:002015-05-07T11:12:40.459-05:00Analytics Companies Using SAS in IndiaAnalytics Companies Using SAS in India Direct Source LinkCN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com1tag:blogger.com,1999:blog-3449524058741348400.post-35723877871210574862013-11-13T15:35:00.000-06:002015-05-09T08:27:49.881-05:00Use SAS function Propcase() to streamline Google Contacts You might think I am crazy…but I have been using this macro for a long time to fix some contacts in my Google Contacts…I get a little irritated when I can’t find a particular person by email…so I wrote this macro… This macro takes for Input a .csv file that is exported from Google Contacts and outputs a file that is ready to be imported to Google Contacts….often I wanted to have Names in the Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-20786400910652825252013-10-22T13:35:00.000-05:002015-05-09T08:34:32.758-05:00Export data from SAS into Microsoft ExcelThere are a number of ways to export data from SAS into Microsoft Excel. However, very few allow for exporting into custom-formatted spreadsheets such as those demanded for specific reports, in which explicit attributes such as font sizes and column widths are required. Traditionally, Dynamic Data Exchange (DDE) was the only way to do this. Now there are newer methods for this which are CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-35476086082839212292013-10-04T13:19:00.000-05:002015-05-08T23:35:40.448-05:00Finding the nth business day of a given month and yearThis sample shows a macro version and the data step version that can be used to find the nth business day of a given month and year. This example uses the INTNX function to increment the date, time, or datetime value by a given interval or intervals. http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a000212700.htm This macro is a modified version of the Source: http://CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-55585563576503854692013-10-01T18:03:00.000-05:002015-05-07T18:05:08.575-05:00Patron segmentation on SAS VA CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0tag:blogger.com,1999:blog-3449524058741348400.post-64955304898697303752013-08-25T12:42:00.000-05:002015-06-22T16:31:46.955-05:00SAS macro to split a macro variables values to multiple macro variables values and also get the split count into another variable And also there could be other instances where you need to do the opposite i.e. split a macro variable values list into individual pieces and get them into a series of macro variable values. One can use the below macro for such a requirement. /************************************************************************************************************** * Macro_Name:   CN Sharadhttp://www.blogger.com/profile/01945648979271465057noreply@blogger.com0