BookmarkSubscribeRSS Feed
BenConner
Pyrite | Level 9

Hi,

 

I'm seeing we can get significant benefit from converting some of our master files over to SPDE format.  Savings in both space and run times look promising. 

 

One of the minor inconveniences is lack of support for views.  Was wondering if pointing a different non-SPDE libname to the same folder that SPDE uses would result in any issues, if only to define views..  I would think not, but I've been surprised before.

 

Version 9.4 TS1M5, Windows 2012 R2 server.

 

Thanks!

 

--Ben

3 REPLIES 3
LinusH
Tourmaline | Level 20
Your question is, probably unintentional, inconsistent. View is queries at rest, and usually doesn't care about where it's stored, or where the data it's referencing is stored. This is especially true for Base and SPDE library data.
To answer your question: yes it's possible. But I can't see any benefits for doing so. Just risking confusion for the maintenance team.
Data never sleeps
BenConner
Pyrite | Level 9

Hi Linus,

 

Thanks for replying.  Yeah, probably could have done a better job phrasing  it.  🙂

 

I guess I'm asking if something like this would cause heartburn with SAS at any point:

 

libname out 'c:\sasdata\project1';

libname out2 SPDE  'c:\sasdata\project1';

 

I would stuff views into the out libname and the data itself in the out2 libname.

I'm not expecting any conflicts but wanted to make sure this wouldn't cause SAS issues.

 

--Ben

BenConner
Pyrite | Level 9
I did run this by SAS Tech Support. While they didn't say 'no, you can't do that', their response is 'we never do that'. LOL...

That suggests to me it works now, but we won't guarantee it will work in the future. Close enough to 'no' for rme.

--Ben

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 600 views
  • 2 likes
  • 2 in conversation