SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phil_NZ
Barite | Level 11

Hi all SAS Users,

 

I am wondering if there are too many differences between reading the data from a directory in the portable external hard drive and a directory located in the computer. My portable external hard drive is HDD and the hard disk in my computer also HDD.

 

The reason I did so because I want the computer having space to run the code.

 

Warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
There are too many other factors to offer a conclusive answer. A SSD connected via USB 2.0 is less reliable than an installed SSD. A SSD on a network drive that's being scanned or backed up may be significantly slower to write to than an external drive. If you're only reading and not writing files it's different and it's different again if you're planning to redirect your full work directory to the external drive versus your local drive.
And if you're using Viya it's different again, as that supports in memory operations.

Most places that have a Server are usually connecting to a data warehouse or data server and there's well defined processes for the ETL so its usually not something a statistician or analyst would worry about. The cases where you require external data should be rare and should be smaller data files. Otherwise why would you invest millions in a software solution like SAS?

View solution in original post

17 REPLIES 17
SASKiwi
PROC Star

There is no difference between the two as far as SAS is concerned except the external drive may have slower performance.

ballardw
Super User

You may find, depending on everything you do, that the drive letter changes as well. Like insert a thumb drive before connecting the external drive.

So extra care may be needed if reusing program code.

Phil_NZ
Barite | Level 11

Hi @ballardw 

Thank you for your suggestion.

 

Can I ask what does "drive letter changes" mean, please? So, you mean be careful about the directory reference (folder pathway), did I explain you properly?

 

Warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
ballardw
Super User

@Phil_NZ wrote:

Hi @ballardw 

Thank you for your suggestion.

 

Can I ask what does "drive letter changes" mean, please? So, you mean be careful about the directory reference (folder pathway), did I explain you properly?

 

Warm regards.


 

At least in my Windows experience the permanent drives and/or drive partitions installed will have the letters C, D (and so on) in the order they were set up. My current set up goes to drive F: for the DVD drive.

 

If I plug a thumb drive into a USB port it gets the next available drive designation G:. If I plug in my portable external drive it gets H:. If I disconnect both and then reconnect the portable external drive the next time it will get the letter G:. So the paths change. The main concern is if you remove and reconnect items in a different order then any code using those paths needs to be addressed very carefully as they may change. UNC strings may be a work around but I haven't tried them with removable media. This may point to some other approaches:

https://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n07buc7sg08fdrn1c...

 

 

I suspect similar happens on a Linux/Unix but don't have any experience (my last Linux box died before I had a thumb drive).

 

 

Phil_NZ
Barite | Level 11

@ballardw 

 

Ahhhh, I see what you mean, I never plug in my USB inside so it does not change, but good experience for me in the future. 

 

Thank you very much for your experience

 

Warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Reeza
Super User
Did you verify if you were running a server or local installation? That matters a lot for a question like this.
Phil_NZ
Barite | Level 11

Hi @Reeza 

I am running on SAS EG remotely server, not locally installed. Hope that I understand you correctly.

 

Warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Kurt_Bremser
Super User

Then the file in question needs to  be uploaded to the server anyway, which is usually a manual process, unless you want to use the Copy Files task (provided by EG) in a project for automation..

 


@Phil_NZ wrote:

Hi @Reeza 

I am running on SAS EG remotely server, not locally installed. Hope that I understand you correctly.

 

Warm regards.


 

Phil_NZ
Barite | Level 11

Hi @Kurt_Bremser 

Sorry in advance if I explain you inappropriately!

 

So, you mean that in my case, there is no well-taken difference between calling a dataset from an external hard drive  and the same dataset from an existing hard drive (says disk C or D).

 

Warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Reeza
Super User

Then it doesn't matter at all. You need to upload your data to the server and that takes time regardless, and once its there the space on your computer is entirely irrelevant. All the work happens on the server and you only see the results. Your computer resources should not be massively effected, except when displaying graphical output.

 

 

 

Phil_NZ
Barite | Level 11

Hi @Reeza  and @Kurt_Bremser 

Thank you for your explanation. Can I ask the same question in case SAS is installed locally in the computer, please?

 

Many thanks and warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Phil_NZ
Barite | Level 11

Hi @Kurt_Bremser 

Yes, I see, @Kurt_Bremser 

 

I just think of buying a laptop i7 with 556 SSD this morning to smash this project. I also believe that the internal storage would be much better than the external one. 

 

Thank you for your bits of help!

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • 2516 views
  • 13 likes
  • 5 in conversation