In this video we will be discussing about how to import a CSV file into SAS. For this we'll be using the procedure called proc import data file. So let's do it proc import data file. Equals first we have to give the path of our data file via var we'll do import the CSV file for linear regression. So this is my linear regression CSV file. I can take the path from the properties or even take it from the address bar.

Then we have to give the name of the data file that is the CSV file that is linear underscore record is predicted dot CSV and we are using the keyword for out equals to linear. So after we import the data file into SAS, the data set will be created inside work as we did not specify any library name over here and it will be the name of the data set will be linear. Then we are giving the key word called replace, replace transform. My Excel file is getting replaced with SAS data set and then Dra. Let's run this code So this is my work literally. Let's open the linear data set, proceed This is my data set, whichever imported.

Here I have got 200 observations. And I have variables like customer satisfaction, product quality, ecommerce, technical support content resolution advertising, product line, sales force image, competitive pricing, warranty claims packaging, or the billing, flat price, flexibility and delivery. So I have around 13 to 14 independent we're 13 to 14 variables or columns, where since this is a linear regression data, so you can understand very well my customers are searching the dependent variable and the rest of my independent variables. So basically I have converted my CSV file into a fast phi or those fast data set. If this file was an Excel file, say if it was if the CSV file was an Excel file means it is saved in dot XLS format or dot XLS x format. So if it is in dot XLS format we are going to just replace the CSV by XLS and then we are going to import it.

So, this is how you import an Excel file into SAS. Thank you. Goodbye. See you all for the next video.