Learning SAS? Welcome to the exclusive online community for all SAS learners.

Code running slow in SAS

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

Code running slow in SAS

I have been analyzing the NSDUH data sets. I have used my editor files on several occasions before and it worked perfectly fine until recently.

 

Reading in a permanent (combined 10 year data set) in to a work file on SAS is now taking several hours. It worked fine a month ago but I seem to be having problems now despite not making any changes to the file or the data sets in the folders.

 

What do I do to fix this?

 


Accepted Solutions
Solution
‎06-01-2018 12:00 PM
Super User
Posts: 13,950

Re: Code running slow in SAS

Where are the files you are reading? On your local hard drive or a network location? You may have network connectivity issues.

 

Are you re-reading the same files? If so, STOP IT!. Learn how to create a permanent library and read the files into that library. Then the next session you just need to make sure the library is active and use the data set.

 

Or are you now reading much larger files?

 

Showing code used is often helpful.

View solution in original post


All Replies
Super User
Posts: 24,027

Re: Code running slow in SAS

Are you using SAS Studio/SAS UE or a different version? If a different version, please elaborate.

Solution
‎06-01-2018 12:00 PM
Super User
Posts: 13,950

Re: Code running slow in SAS

Where are the files you are reading? On your local hard drive or a network location? You may have network connectivity issues.

 

Are you re-reading the same files? If so, STOP IT!. Learn how to create a permanent library and read the files into that library. Then the next session you just need to make sure the library is active and use the data set.

 

Or are you now reading much larger files?

 

Showing code used is often helpful.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 179 views
  • 0 likes
  • 3 in conversation