Working on some fun things \u00a0using \u00a0SAS Studio, so, expect a number of short posts over the next few days. Last time, I talked about the utilities and how easy it is to import an Excel file. Now let’s say maybe you are not aUnix person \u00a0and you have no idea how exactly to code a LIBNAME statement \u00a0that is not on Windows. \u00a0Never fear, it’s super easy.<\/p>\n
Right click on the folder where you want to save your data set. From \u00a0the \u00a0menu that appears, select the last choice which is ‘properties’.<\/p>\n
A window will come up that shows the name of your folder and its location, it’s easy to spot because it’s right next to the word Location. It will look something like this:<\/p>\n
\/home\/your_name\/data_analysis_examples<\/p>\n
to save your data you have uploaded an Excel file and imported into \u00a0SAS, remember that the files were saved in the work directory and named import, import 1 etc.If I wanted to \u00a0sort those data sets and then merge them together into a permanent data set, I’d do it in the exact same way as if I was using Windows. The only thing different is the LIBNAME statement, as you can see below.<\/p>\n
LIBNAME\u00a0in “\/home\/your_name\/data_analysis_examples”;<\/p>\n
Proc sort data = work.import;
\nBy username;<\/p>\n
Proc sort data = work.import1;
\nBy username;
\ndata in.crossroads ;
\nmerge work.import work.import1;
\nBy username;
\nrun;<\/p>\n
If, later on, I want to use that data set in a program, again I would do it exactly the same as in Windows and the only thing different would be my LIBNAME.<\/p>\n
<\/p>\n
LIBNAME\u00a0in “\/home\/your_name\/data_analysis_examples”;<\/p>\n
<\/p>\n
Proc means data = in.Crossroads;<\/p>\n
Run;<\/p>\n
Completely random fact, unrelated to SAS studio, or maybe it is related, \u00a0I hurt my arm again, so I have been writing my SAS programs using Dragon voice recognition software. \u00a0If you are going to use SAS studio on a Mac, you should be aware that Dragon does not work on Firefox on the Mac so open up Chrome if you want to use voice recognition software, or at least the software from Dragon. This has nothing to do with SAS specifically.<\/p>\n
![\"Buy](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2016\/09\/BUY-Banner-copy.png\")
<\/a><\/p>\n