I'm trying to get use to coding in SAS and it's syntax, because If I want to do more statistical analysis and data basic manipulation, I can do it all in SAS vs "Do it in SQL Server, paste it to a work book, and then import the data in SAS."
Am I doing it wrong or is DataStep really slow? Im trying to pull a basic table from one of our servers, but it's really slow.
Here's my code:
data Counts(firstobs= 1 obs=10);
set library.table;
run;
All I'm doing is I'm pulling the first 10 observations from table. We do house a lot of data, but I figured just pulling the first 10 observations shouldn't be too complicated. I also just tried obs = 10, but that pulled all my data, but took about 20 minutes.
*EDIT.. after about 20 minutes, the firstobs=1 did not work.
Am I missing something?
Also, I'm not using Proc SQL on purpose so I can learn another language.
Am I doing it wrong or is DataStep really slow? Im trying to pull a basic table from one of our servers, but it's really slow.
Here's my code:
data Counts(firstobs= 1 obs=10);
set library.table;
run;
All I'm doing is I'm pulling the first 10 observations from table. We do house a lot of data, but I figured just pulling the first 10 observations shouldn't be too complicated. I also just tried obs = 10, but that pulled all my data, but took about 20 minutes.
*EDIT.. after about 20 minutes, the firstobs=1 did not work.
Am I missing something?
Also, I'm not using Proc SQL on purpose so I can learn another language.
Last edited: