How to Import a SAS Dataset into SAS ODA - Demonstration

[@hannahdibling6468]

I don't ever take the time to comment but THANK YOU. I'm in a graduate program and I have such an issue with SAS and of course there's no explanations just "Do the assignement." You are amazing and I will be watching the rest of your video!!!!

[@billstewart6891]

Thank You!! Finally, an instructor that speaks fluent "student". Your explanation was brief, on-point, and understandable. Thank you so much.

[@DethWench]

You're welcome!

[@downonme1000]

I'm a graduate student in public health. And at first I truly thought that I wasn't good enough for the program because I didn't understand this. Your videos have helped me ace my homework. Thank you so much!!!

[@pallavi15apr]

I was stuck on this step since forever. You are the best👍

[@saniyamehta1582]

I can't thank you enough right now, was stuck since 2 days.

[@rivanmoodley2331]

Worked perfectly. Great video.

[@mthokozisisteventavinnkosi1994]

SIMPLICITY. Thank you

[@Rationalreviewer]

Omg thanks alot. Very nicely explained. Clear expression.

[@ajaykushwaha-je6mw]

I tried the same. I am able to import Data set into SAS but in data set it is showing only 5 observation but actually there is 300 hundreds. How can I fix this issue.

[@DethWench]

I'm sorry, I just saw this comment. It is hard to troubleshoot I/O problems in SAS even when I'm right there, but the main thing I would say is to read the log file. That is the best way to decode what is actually happening with your data - either it's importing and you can't see it, or it's getting hung up on the import.

[@yungpesca9809]

thx u saved me

[@peymanzada8169]

How do I import a file in my sas studio that ends with sas only?

[@DethWench]

Hi there. If a file ends with sas (e.g., 100_read in data.sas), it is actually a code file. This means that it can be opened in Notepad. It's hard to import files into the SAS environment, and it's different in every interface, so I'll tell you my hack. What I do when I have this problem - which is SAS code not in a SAS environment - I just open the .sas file in Notepad, so I can see it. Then, I create a new blank code file in the SAS environment. Then I go to Notepad, do control-A (select all the code), copy, and paste into my new blank code file. Then I save it in the SAS environment. That way, it is in the new environment. However, then you have to run it to make sure it works in the new environment. The LIBNAMES may not map, etc. Good luck!

[@viviennenguyen4436]

Is there a way you can open a .sas7bcat file using .sas7bdat?

[@DethWench]

Hi there. A file named with anything followed by .sas7bdat is a data file - meaning it contains data and needs to be opened by an application. The SAS application is the only one I know of that can open it, but you can convert it using R to something else (like .txt or .csv) and then open it using Excel or Notepad in another format. The R package I use is foreign (cran.r-project.org/web/packages/foreign/). In contrast, the code files in SAS - which end in .sas - and the log files in SAS - which end in .log - can be opened in Notepad. But of course, you can't run the code unless you open the SAS application and use the SAS code in the SAS environment. I hope this makes sense to you...?