{"id":5591,"date":"2018-02-24T18:33:27","date_gmt":"2018-02-24T23:33:27","guid":{"rendered":"http:\/\/www.thejuliagroup.com\/blog\/?p=5591"},"modified":"2018-02-24T20:57:30","modified_gmt":"2018-02-25T01:57:30","slug":"whipping-your-data-into-shape-with-sas-part-1-for-today","status":"publish","type":"post","link":"https:\/\/www.thejuliagroup.com\/blog\/whipping-your-data-into-shape-with-sas-part-1-for-today\/","title":{"rendered":"Whipping your data into shape with SAS : Part 1 for Today"},"content":{"rendered":"

I’m sure I’ve written about this before – after all, I’ve been writing this blog for 10 years – but here’s something I’ve been thinking about:<\/p>\n

Most students don’t graduate with nearly enough experience with real data.<\/h3>\n

You can use government websites with de-identified data from surveys, and I do, but I teach primarily engineering and business students so it would be helpful to have some business data, too. Unfortunately, businesses aren’t lining up to hand me their financial, inventory and manufacturing data (bunch of jerks!)<\/p>\n

So, I downloaded this free app, Medica Scientific from the app store and ran a simulation of data for a medical device company<\/a>. Some friends did the same and this gave me 4 data sets, as if from 4 different companies.<\/p>\n

Now, that I have 4 Excel files with the data, before you get to uploading the file, I’m going to give you a tip. By default, SAS is going to import the first worksheet. So, move the worksheet you want to be first. In this case, it’s a worksheet named “Financials”. Since SAS will use the first worksheet, it could just as well be named “A whale ate my sandwich”, but it wouldn’t be as obvious.<\/p>\n

While you are at it, take a look at the data, variable names in the first row.\u00a0 ALWAYS give your data at least a cursory glance. If it is millions of records, opening the file isn’t feasible and we cover other ‘quick looks’ in class.<\/p>\n

These steps and the next few use SAS Studio, which is super-duper helpful for online courses.<\/strong><\/p>\n

1. Upload the file into the desired directory
\n2. Under Tasks and Utilities select Utilities and then Import Data
\n3. Click select file and then navigate to the folder where your file is and click open
\n4. You’ll see a bunch of code but nothing actually happens until you click on the little running guy.<\/p>\n

\"menus<\/a>
First select the data set<\/figcaption><\/figure>\n
\"the<\/a>
Have you clicked the running guy? Good!<\/figcaption><\/figure>\n

 <\/p>\n

Okay, now you have your code. Not only has SAS imported your data file into SAS, it’s also written the code for you.<\/p>\n

FILENAME REFFILE '\/home\/annmaria\/examples\/simulation\/Tech2Demo.xlsx';
\nPROC IMPORT DATAFILE=REFFILEDBMS=XLSX OUT=WORK.IMPORT1;
\nGETNAMES=YES;
\nRUN;
\nPROC CONTENTS DATA=WORK.IMPORT1;
\nRUN;<\/code><\/p>\n

Now, if you had a nice professor who only gave you one data set, you would be done, which is why I showed you the easy way to do it.<\/p>\n

However, very often, we want to compare several factories or departments or whatever it is.<\/p>\n

Also, life comes with problems. Sigh.<\/h3>\n

One of your problems, which you’d notice if you opened the data set is that the variables have names like “Simulation Day” .\u00a0 I don’t want spaces in my variable names.<\/p>\n

My second problem is that I need to upload all of my files and concatenate them so I have one long file.<\/p>\n

Let’s attack both of these at once. First, upload the rest of your files.<\/p>\n

Now,\u00a0 open a new SAS program and at the top of your file, put this:<\/p>\n

OPTION VALIDVARNAME=V7 ;<\/p>\n

It will make life easier in general if your variable names don’t have spaces in them. The option above automatically recodes the variables to valid variable names without spaces.<\/p>\n

Now, to import the next 3 files, just create a new SAS program and copy and paste the code created by your IMPORT procedure\u00a0 FOUR TIMES (yes, four).<\/p>\n

From Captain Obvious:<\/strong><\/p>\n

\"\"<\/a>
Captain Obvious wearing her obvious hat<\/figcaption><\/figure>\n

Although you’d think this would be obvious, experience has shown that I need to say it.<\/p>\n