一道面试题引发的 “大案”
昨天一个学生去一个金融公司面试，面试官问了一个 SQL join 问题：Suppose we have 2 tables, they both have some duplicates on the ID variable ( the linking key). If we full join…
Category: Tools
Celebrate Christmas as a data scientist: Use SAS to play Jingle Bells
Jingle Bells, Jingle Bells, Jingle all the way…… 2020 is an unprecedented year full of challenges, struggles and strives for every one. Now it is…
A Brief Summary of Advantages and Drawbacks of Python
Python is the most popular programming language nowadays. Based on my own experience, here is a list of advantages and limitations/drawbacks of Python…
Looping and Macro in SAS and Python
Macro or looping is an advanced programming in SAS, R and Python, it is necessary and very useful in real work, but it is quite hard and requires a ve…
【BigData Key Skills】： Part 3. Add New Columns and Conditional Processing
In previous two sections, we talked about how to sort, dedup and subset data. In this section, we are going to discuss on another important…
【BigData Key Skills】： Part 2. Subset Data
As a data scientist, it is very often to subset data or slice data. Generally speaking, there are two ways in slicing data: vertically and…
Organize and Manage External Files by SAS Programming
SAS is not only an analytics, business intelligence and data management software, but also a powerful tool that can make your housekeeping work more e…
【BigData Key Skills】： Part 1. Sort and Dedup Data
Currently, big data analytics are widely used in many industries such as financial, telecom, insurance and retail industries. As it is well known, the most…
