awesome video; just acquired older 2500 which runs and moves great but both lift cyls leak bad; may be I'll give this a try, looks doable thanks to you
Man you are soo great... I wanted to calculate skewness in pure python but was unable to find the formula to do so... littely you are a life saver! Keep making these types of videos
really helpful but I am looking for importing 5 sheets(one excel file) in the same SAS version 9.2 can you tell me how to do. it will very helpful to me.
what if the excel doesn't have variable names? If i use proc import it will screw up the first row/observation, how can you create a new row for the imported excel data? Thank you!
why nobody never told me there was this way of importing data? so much easier than building the proc by myself, more than that, it actually works! New SAS learner here going through lots of stress and frustation but this helped me to regain my energy. God bless you sister
Nick, I am not exactly sure what you mean by "trying to do age," but you can create dummies for age ranges. For example, if you want a dummy for anyone under 21 and another dummy for folks 21 up to but not including 25 from a variable called AGE the following two dummies will work. AgeLT21=0; if AGE<21 then AgeLT21=1; Age21_25=0; if AGE >= 21 and AGE < 25 then Age21_25=1; This is assuming you're not trying to create a dummy for each individual age your data set.
If you are trying to do dummies by age groupings, there are a lot of different routes you can take. If you wanted to essentially create a dummy for EVERY age (less one age), it's a little trickier. You wouldn't want to manually create a whole bunch of dummies. Depending on the proc used, you might be able to use the CLASS statement to do that for you.
Sorry for the late reply. I missed your comment. The answer to this varies. Depending on the features you are installing, some may be skipped; however, when installing this way, the installation program will ask for the needed cd/dvd when it's required. The install in the video is from flash drive, so there are no media changes required. This is much easier and faster...even though it's really time consuming due to the size of the install.
You can connect directly to Excel through a library, but not every install has that option. Also, as I understand it, there is also some issues when you have a 64bit version of SAS and a 32bit version of Excel with this (and other Excel-related features) not working correctly.
You can do that...In fact, if you save the code from the import routine, you can use and edit the code to work with other Excel files pretty easily. This is especially useful when you are still regularly modifying or updating the original Excel file. If I re-do this video, I will try to include that set of steps.
There are others, but thanks. One person that does an excellent job with SAS tutorials is Ani Katchova. She provides a lot of good examples for someone interested in intro applied econometrics. Her work is top notch in my book. You can find it here. sites.google.com/site/econometricsacademy/home
Wow first to comment: Im a new SAS learner and I see there is not as much video aided help out there. I appreciate this video, it helped me a great deal. Please continue your work :-) Thank you.
Thanks for the tutorial. Do you happen to know how then treat those dummies in SAS Miner? As binary or interval variables? I need those for logistic regression and it seems to me that former choice is the right one but I am not sure.
+Boa Dławiciel It would depend on your coding. Here is a good example that I think answers your question. www.ats.ucla.edu/stat/sas/faq/proc_logistic_coding.htm