Friday, 22 July 2016
Monday, 18 April 2016
Installation guide from DexLab Analytics
Dexlab Analytics
03:10
advanced MS Excel, big data analytics, big data certification, big data hadoop courses, excel dashboard learning, Linux operating system
3 comments
Thursday, 10 March 2016
13 Advantages of R over Excel in Data Analytics
Dexlab Analytics
03:11
Advanced excel course, advanced excel course online, advanced Excel institute, Advanced excel training, advanced MS Excel, Analysts & data modelers, big data analytics
3 comments
Related posts :
For More Info On Big Data
Tuesday, 1 March 2016
Easily Analyze Data with MS Excel
Dexlab Analytics
23:03
Advanced excel course, advanced excel course online, advanced Excel institute, Advanced excel training, advanced MS Excel, big data analytics, big data hadoop courses
2 comments
This video presents to you some features of MS Excel that make analysis of data a snap. And all this from the confines of your favorite spreadsheet program environment. MS Excel also throws on the platter a host of tools with which advanced users may perform complicated tasks in Big Data and Analytics. So as you can see your favorite spreadsheet program is far more powerful than you previously thought.
Related posts :
For More Info On Big Data
Friday, 12 February 2016
How to Export To Excel from SAS
Dexlab Analytics
02:56
advanced MS Excel, Excel dashboard layout, excel dashboard learning, Excel dashboard training, sas certification, Sas course, SAS experts, sas training centers in gurgaon
1 comment
![]() |
Nevertheless with SAS you can both read from MS Excel in a variety of ways and also export data into spreadsheets to be opened in Excel. There are a number of methods to achieve the same each having its own set of disadvantages and advantages. Some of the better methods for doing the same follow in the paragraphs below.
Differences between 64-bit and 32-bit Architectures
A few of the concepts and terms need to be cleared out before we proceed.
For you to be able to create excel files from the SAS environment itself you are in need of SAS/ACCESS to PC Files. This will; let you perform all sorts of interchanges in file formats to and from SAS and other apps of the PC which include Excel as well.
But the shift from 32 bit architecture to a 64 bit one has ensured that 64 bit SAS sessions will not be able to run the PROC EXPORT DBMS=EXCEL program unlike its 32 bit counterpart.
This may be remedied in two different ways:
- Installing data providers which are 64 bit which ship with the 64 bit MS Office but keep in mind that you cannot have 32 bit and 64 bit variants of these data providers concurrently.
- You may also make use of the PC Files Server which resides on the same Windows installation where you have SAS. But for this to work it is necessary to have the SAS program use DBMS=EXCELCS which basically instructs SAS to utilize PC Files Server in contrast to data providers that are used in-process.
The Better Ways to Export SAS to Excel
- LIBNAME EXCEL- This serves to read and write Excel files as sheets when the bit architecture (i.e. 32 or 64 bit) of SAS matches that of MS Office. The excel file serves as a SAS library where ranges or sheets form the member tables.
- LIBNAME PCFILES performs the same function as the above with the difference being in using PC Files Server. It is good for situations where there is difference in architecture(Whether 32 bit or 64 bit)
- PROC EXPORT DBMS=EXCELCS makes use of PC Files Server to write files in the Excel format. The output behavior may be controlled to a great extent and is well suited to situations where there is a difference in bitness.
- PROC EXPORT DBMS=EXCEL- This is most suitable in cases where the bit architecture of SAS matches that of MS Office.
- PROC EXPORT DBMS=XLS- This lets you export to Excel files directly without any external dependencies. However its function are limited as far as format and volume are concerned. It works on both the UNIX and Windows platforms.
- PROC EXPORT DBMS=XLSX- This was introduced in version 9.3M1 and is able to directly export to Excel 2010 files. There is no need for any driver or added software like PC Files Server.
- PROC EXPORT DBMS=CSV- This produces CSV files used most often in Excel.
- ODS TAGSETS.CSV- This also creates CSV files. An alternative way is to use the DATA step and FILE output.
- ODS TAGSETS.EXCELXP- This makes use of ODS to output XML files in Office. The appearance of the content may be controlled to a significant extent but recent MS Excel versions refuse to see it as a “native” format.
- FILENAME DDE- This uses Windows messages in order to control the functions of Excel files down to the level of cells. In order for this to work SAS and Excel must reside in the on the same machine. Another point to be noted is that it will not work in Workspace Servers of SAS or servers which are referred to as stored process. It lets you leverage a tremendous amount of control, a quality prized by Advanced SAS users.
If all this sounds exciting to you even if you are a newbie to the field a proper SAS Training Institute in Gurgaon will help you along the way.
Related posts :
Tuesday, 26 January 2016
Excel essentials that makes you the right employee
Dexlab Analytics
22:41
advanced excel course online, advanced Excel institute, advanced MS Excel, Excel features, excel training, MS Excel, online MS Excel tutorials
No comments

A few nifty Excel tricks to keep up your sleeve:
- How to send a read-only PDF file?
Often you may need to send a read-only PDF Excel spreadsheet for sharing important information that cannot be edited or manipulated. In such instances a PDF document comes in handy. Now you may be thinking that sending an Excel sheet PDF is simple using Adobe Acrobat. But what if you do not have Adobe Acrobat? You can still send a PDF using Excel itself. Simply follow the below mentioned steps: click on File > Send > and email the file as a PDF Attachment. You can also avail the option to save the file as a PDF instead of emailing; it helps you save files in forms that cannot be edited thereafter. In case your present Excel version downloads the updated add-on from the official website of Microsoft. - How to import data from a website?
If you come across a website with data that you need to work on a project with but want it in the spreadsheet form, how do you convert it? Click on File > Open > then change the format of the file to All Web Pages. With this all the file formats like .html, .htm, .mhtml etc. will be covered. Then simply go to the web pages and click on Open. When you are done with these steps the webpage content will open but the formatting might still require some tinkering. But still this is way easier than building a new workbook from scratch. - How to fine-tune specific search results using filter?
When using a huge spreadsheet with numerous data on it but you have to find out a specific one from thousands of entries, you may find yourself lapsing into a mini-coma. But thankfully Excel has a function called Autofilter that can be used to search for something that you specifically want to find and exclude what is irrelevant to your search needs at the moment. To use this function, click on the cell at the lower left-hand corner go to Data > Filter > AutoFilter, then you will find narrow boxes in your spreadsheet that will further help you narrow your search. Then use the custom filter and simply type in the type of data you are looking for in the sheet.
While these are a few simple tricks and techniques in Ms Excel, there are plenty of other smart Excel features that can help you be an asset to your firm. To learn more advanced MS Excel techniques we recommend you find a suitable advanced Excel institute in Gurgaon.
Related posts :


