Skip to main content

Featured post

How to Show Data science Project in Resume

In any project, the Data analyst role is to deal with data. The data for data science projects come from multiple sources. This post will explain how to put in data science project in Resume.
Data Science project for Resume The first step for an interview of any project is you need Resume. You need to tell clearly about your resume.

In interviews, you will be asked questions about your project. So the second step is you need to be in a position explain about project.

The third point is you need to explain the roles you performed in your data science project. If you mention the roles correctly, then, you will have 100% chance to shortlist your resume. Based on your experience your resume can be 1 page or 2 pages.
How to show Technologies used in Data science projects In interviews, again they will be asked how you used different tools to complete your data science project.

So, you need to be in a position to explain about how you used different options present in the tools. Sometime…

Write and Read Excel files into SAS Studio

The point is how to import excel file into SAS. Step by step process given on reading Excel file into SAS and writing Excel file from SAS.

SAS vs Excel Files

Reading an Excel file into SAS

Suppose that you have an Excel spreadsheet called auto.xlsx. The data for this spreadsheet are shown below:

MAKE MPG WEIGHT PRICEAMC Concord 22 2930 4099AMC Pacer 17 3350 4749AMC Spirit 22 2640 3799Buick Century 20 3250 4816Buick Electra 15 4080 7827

Import Wizard

Using the Import Wizard is an easy way to import data into SAS. The Import Wizard can be found on the drop down file menu. Although the Import Wizard is easy it can be time consuming if used repeatedly.

The very last screen of the Import Wizard gives you the option to save the statements SAS uses to import the data so that they can be used again.The following is an example that uses common options and also shows that the file was imported correctly.

PROC IMPORT OUT= WORK.auto1 DATAFILE= "C:\auto.xl"
DBMS=xlsx REPLACESHEET="auto"; GETNAMES=YES;RUN;
The out= option in the proc import tells SAS what the name should be for the newly-created SAS data file and where to store the data set once it is imported.
  • Next the datafile= option tells SAS where to find the file we want to import.
  • The dbms= option is used to identify the type of file being imported.
  • The replace option will overwrite an existing file. To specify which sheet SAS should import use the sheet="sheetname" statement. The default is for SAS to read the first sheet. Note that sheet names can only be 31 characters long.
The getnames=yes is the default setting and SAS will automatically use the first row of data as variable names. If the first row of your sheet does not contain variable names use the getnames=no. 

Writing Excel files out from SAS

It is very easy to write out an Excel file using proc export in SAS. Here is a sample program that writes out SAS data called mydata to an Excel file called mydata.xlsx into the directory "c:\dissertation".

proc export data=mydata outfile='c:\dissertation\mydata.xlsx'
dbms = xlsx replace;run;

Comments

Most Viewed

Hyperledger Fabric Real Interview Questions Read Today

I am practicing Hyperledger. This is one of the top listed blockchains. This architecture follows R3 Corda specifications. Sharing the interview questions with you that I have prepared for my interview.

Though Ethereum leads in the real-time applications. The latest Hyperledger version is now ready for production applications. It has now become stable for production applications.
The Hyperledger now backed by IBM. But, it is still an open source. These interview questions help you to read quickly. The below set of interview questions help you like a tutorial on Hyperledger fabric. Hyperledger Fabric Interview Questions1). What are Nodes?
In Hyperledger the communication entities are called Nodes.

2). What are the three different types of Nodes?
- Client Node
- Peer Node
- Order Node
The Client node initiates transactions. The peer node commits the transaction. The order node guarantees the delivery.

3). What is Channel?
A channel in Hyperledger is the subnet of the main blockchain. You c…