f



Import Data in the SAS Folders with SAS 9.3

Hi everyone,
I 'm a beginner with SAS 9.3.
In my company, there is a filesystem dedicated for SAS user (on the SAS ser=
ver).
It is divided into several directories. With the 9.1.3 I have configured th=
e 'Files' directory (in the SAS Main server, under the libraries), with Win=
dows security to separate data. But it doesn't work with SAS9.3. Everybody =
sees everything.
So I would try to use the "SAS Folders" functionnality (with Metadata (ACT)=
 to manage the securiry.
I can create sub-folder in the ShareData folder.
But how can I add SAS tables in theses folders. I tried with DIS (import ta=
bles), but each time I need to create a libname. Our users like create a lo=
t of sub directories for their projects. So I wouldn't create its one by on=
e.
Is there a way to do this simplier ? What are the best practices to manage =
security folder. I would like to start with a clean installation.
Thank for your response.

J=E9r=F4me.
0
jvanheule (21)
10/3/2013 3:52:50 PM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
694 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
SAS System Viewer 9.1 was able to open datasets that were created by V8 engine (SAS 8.2), but is unable to open datasets that are created with V9 engine (SAS 9.1.3). Does this need SAS System Viewer to be upgraded ? or Something else needs to be done ? In message <0ae08496-acd1-4c40-8828-b88d059c0d0e@f40g2000pri.googlegroups.com>, msiddu2000 <msiddu2000@gmail.com> writes >SAS System Viewer 9.1 was able to open datasets that were created by >V8 engine (SAS 8.2), but is unable to open datasets that are created >with V9 engine (SAS 9.1.3). > >Does this need SAS System...

Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return: is your table from windows? compressed from another system? and specially with personnel formats hard coded inside? Andre msiddu2000 a �crit : > SAS System Viewer 9.1 was able to open datasets that were created by > V8 engine (SAS 8.2), but is unable to open datasets that are created > with V9 engine (SAS 9.1.3). > > Does this need SAS System Viewer to be upgraded ? > or > Something else needs to be done ? > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 7598...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #3
Okay, I think I need to weigh-in on this. First, the exam is designed to test what you know about how SAS works. I think it does a fair job at that. (I say so partly because I only scored 89 on the exam. Now, I didn't prepare for the exam; I was really testing the exam when I took it as opposed to using the exam to test my skills.) The exam doesn't know how well you can program. There is a big difference between having a large vocabulary and knowing the rules of grammar and knowing how to write. Similarly, there's a big difference between knowing how SAS works and knowing how...

SAS Clinical Data Standards Toolkit 1.2 for SAS 9.1.3
For download: SAS Clinical Data Standards Toolkit 1.2 for SAS 9.1.3 http://ftp.sas.com/techsup/download/hotfix/12clintlkt.html On Jul 22, 10:51=A0am, Lex Jansen <lexjan...@gmail.com> wrote: > For download: > > SAS Clinical Data Standards Toolkit 1.2 for SAS 9.1.3 > > http://ftp.sas.com/techsup/download/hotfix/12clintlkt.html ------- It is very useful for SAS users, thanks a lot! Chunming LI Is toolkit for SAS 9.2 also available? If yes, may i have the link. Thanks Such On Jul 22, 12:28=A0pm, IndiMatrix <chunming.li...@gmail.com> wrote: > On Jul 22, 10:51=...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #9
ALan , Lets keep this to straight SAS, I dont tell people what they should use in SAS to produce the report, but rather I say here is what the report should look like, here i sthe data set, here ar the specs, now go make it happen. If your hirng a junior level programmer they should know the data step and say proc sort, proc print, proc format. If your going after a Senior level programmer the test should be harder and reflect more things like ODs, macro, etc... In your case you dont promote straight SAS solutions and that is great, but a whole other market than a straight SAS programmer. ...

What r the data types in SAS? in Base SAS , and SAS SQL
Hi all, What are the different data types in Base SAS and SAS SQL?? Regards, Amar. "Amar Mundankar" <amarmundankar@gmail.com> wrote in message news:5d3eb1f8-ea05-48f1-b41c-92b517889cbc@d4g2000yqa.googlegroups.com... > Hi all, > What are the different data types in Base SAS and SAS SQL?? > > Regards, > Amar. PROC SQL is part of base SAS, but it doesn't matter, the answer is the same wherever you are in SAS. SAS has only two data types, character and numeric. You use formats, informats, and lengths to achieve the effects other languages implement with a m...

Summary of the differences of Base SAS 9.1.3 and SAS 9.2
Anyone have the release notes (or a summary of it?) On what the major differences to expect from Base SAS 9.1.3 and 9.2? From what I heard, there aren't that many differences besides a new installer that helps with upgrades. ...

Re: How to filter sas data sets into separate sas data sets #3
Lizette, Instead of trying to merge the two data sets, I would probably try to create a SAS format from the values of VAR1 in data set 1. Then, NODE1, NODE2 and NODE3 could be compared against the format for a match. The example below is a simplified version of what you could do and shows a printout of how it works. It has 5 observations in data set 1 and only 3 variables in data set 2, but I think the logic should hold for the example you gave. After the example is code that could be used to actually split the data as you had requested. Hope this helps. * create sas data set 1 ; data ...

Re: Summary of the differences of Base SAS 9.1.3 and SAS 9.2
You heard wrong... check out sascommunity.org, there's a page there somewhere that describes the differences. The major things that make a difference to me are XLSX support and improved hash support, but FCMP and ODS/Proc Template improvements undoubtedly make a huge difference to many folks. -Joe On Mon, Oct 19, 2009 at 5:17 PM, Jerry <jerryang@cisco.com> wrote: > Anyone have the release notes (or a summary of it?) On what the major > differences to expect from Base SAS 9.1.3 and 9.2? > > From what I heard, there aren't that many differences besides a new > in...

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
Sick joke, not funny. You would have thought that adding the 9 tag to the exam would have meant testing the ability of using version 9. Not so. The exam doesn't test the ability of version 9. It doesn't even test the ability of using SAS. It tests one's ability of guessing the right answer, because on a lot of the questions that's all you can do. We cannot take material out of the test centre, so I am relating these issues from memory, but 42 is the answer to the Universe, and this one did stick in my memory. Question 42: Correct answer: None of the above. They have swapped ...

Re: Summary of the differences of Base SAS 9.1.3 and SAS 9.2 #2
Dear SAS-L-ers, Jerry posted the following: > Anyone have the release notes (or a summary of it?) On what the major > differences to expect from Base SAS 9.1.3 and 9.2? > > From what I heard, there aren't that many differences besides a new > installer that helps with upgrades. Jerry, yea; I've got them right here: http://support.sas.com/documentation/whatsnew/index.html With a simple click of the old mouse, you can check out the differences bet= ween (8.2) and (9.0, 9.1, 9.1.2, 9.1.3) or between the aforementioned and S= AS 9.2. I've gotta warn you the...

Re: OT : Differences I need to Know for SAS 8 to SAS 9.1.3 #3
On Fri, 17 Nov 2006 14:45:33 -0600, SAS_learner <proccontents@GMAIL.COM> wrote: >I was thinking in lines of like this > >beginning with SAS 9.1, the %SYMEXIST function can be used to determine if a >macro variable exists. The function returns a value of 1 if the macro >variable exists and a value of 0 if it does not. Here is the syntax: > >%let check=%symexist(x); > >Prior to SAS 9.1 you can use the following macro to determine if a macro >variable exists: > >%macro check(mvar); > %local i tmp; > %let dsid=%sysfunc(open(sashelp.vmacro)); > %let num=%sysfunc(varnum(&dsid,name)); > %do %until(&ob = -1); > %let i=%eval(&i+1); > %let ob=%sysfunc(fetchobs(&dsid,&i)); > %let val=%sysfunc(getvarc(&dsid,&num)); > > %if &val = %upcase(&mvar) %then %do; > %let ob = -1; > %let tmp=yes; > %end; > > %else %do; > %let tmp=no; > %end; > > %if &ob=-1 %then %do; > &tmp > %end; > >%end; >%let rc=%sysfunc(close(&dsid)); >%mend check; > >/** Check for the existence of the macro variable abc **/ >%put Does the macro variable exist:%check(abc); In the first post of this thread, you seemed to be keeping the focus on potential problems: things which work in 8 but not in 9.1.3, or which give different results in 9.1.3. That should be a short list. SAS has almost always made compatibility with existing user code a high pri...

Re: FW: Summary of the differences of Base SAS 9.1.3 and SAS 9.2
there won't be any statements missing: no longer available. my memories are of having problems w/UPCASE/lowcase of variable names in output data sets created by sas procedures you will have to sanitize your comments: no special characters, like ampersand or percent and s- or d-quotes /* don't have this */ * %dothis ; %* A&B nor this; Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > -----Original Message----- > From: Shanks N [mailto:shanks.n@gmail.com] > Sent: Wednesday, December 16, 2009 10:43 AM > To: Fehd, Ronald J. (CDC/CCHIS/N...

Re: Deleting SAS Data from a SAS DATASET #9
On Fri, 15 Aug 2008 16:09:46 -0500, Mary <mlhoward@AVALON.NET> wrote: >A view helps on deletes, but I wonder how it affects performance of querying the data- wouldn't storing the data in 24 different locations cause a significant slowdown in perfomance upon querying the data versus having it all in one table that is indexed? If this data is queryied a lot but only deleted once a month, the time in querying (which probably is in peak time) could be much more important than the time in deleting (which could be run when the computer is not busy, such as nights or weekends). hi, go...

Re: Deleting SAS Data from a SAS DATASET #3
The disadvantages of using SQL delete are (1) NOBS= is no longer accurate, and (2) POINT= may behave unexpectedly. If those are not issues, then the delete would be faster, with or without an index, than recreating the data set (especially if the data set has indexes that would need to be rebuilt). -- Jack Hamilton jfh@alumni.stanford.org On Aug 15, 2008, at 11:17 am, Mary wrote: > One thing you might do is to add an index on the snap_dt to the > dataset; if that's there then you should be able to delete the > records in place: > > proc sql; > delete from prod.ma...

Re: Converting from SAS 5 to SAS 9 #3
Dear SAS-L-ers, Nat Wooding, a knowledgeable neighbor just to the South of SAS Mecca posted the following: > Just to jump in, in V6, there was a Proc V5toV6 but that only > gets you one step along the way. I just checked and the proc > is not available in V9 (at least on the pc). > Nat, what a very clever way to inch along towards the goal! My mental picture is that of the old fire brigade where a bucket of water is passed from individual to individual: SAS V5 to SAS V6; SAS v6 to SAS V8, and SAS V8 to SAS V9. The bucket of water is, of course, the original SAS V5 data sets. Unfortunately, the original poster may have reached the end of the line if he/she does not have SAS V6. I say this because the SAS V8 online doc for Windows states the following: Procedures The following SAS procedure is no longer supported: V5TOV6 For more information about procedures, see SAS Procedures under Windows. If SAS V8 doesn't support V5TOV6, then I'll bet that SAS V9 does not support it either. So, hopefully, the original poster has SAS V6 laying around in one of those dusty file cabinets somewhere in the bowels of his organization. Nat, I'll catch you elsewhere on the 'L! I hope that this suggestion proves helpful now, and in the future! Of course, all of these opinions and insights are my own, and do not reflect those of my organization or my associates. All SAS code and/or methodologies specified in this posting are for ill...

SAS 9 and SAS 8
Could someone send me the papers or articles that gives the differences between sas 8 and sas 9 and new function and changes in sas 9. Thanks http://support.sas.com/documentation/whatsnew/index.html and many proceedings at http://www.lexjansen.com On Nov 20, 3:28=A0pm, pausha <paus...@gmail.com> wrote: > Could =A0someone send me the papers or articles that gives the > differences between sas 8 and sas 9 and new function and changes in > sas 9. > > Thanks ...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively systematic way of assessing my knowledge of SAS in a short time span. For that purpose, it was worth it. Since I learn SAS by doing new tasks, or re-doing old tasks in a new way, I assume my knowledge of SAS is uneven, even though I am regarded as productive, and frequently creative in using SAS to solve our group's problems. I passed the test, with lower subscores on the components that I expected to be weakest on. I thought many of the questions made me think about some fundamental, sometimes subtle, features of the lan...

Re: search SAS data set from SAS code #3
Most O/S have a search feature, eg. Windows has search/find command off Start button, will look inside files for a string, eg. our libname / directory. Ultraedit has a handy search feature as well. On 'NIX, you'll use grep, mainframe, 3.something. Consider putting the program name in the data set label ( which shows up in CONTENTS ) at creation time to better keep track of this type of thing. data libname.mydata ( label = "Created by pgm" ); ... run; -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of Rose Sent: Tuesday, Ap...

SAS 9.1.3 on Vista, FAQ from SAS Institute
For those interested in installing 9.1.3 on Vista, the SAS Tech Report for today has a link to the SAS Tech Support Site page listing FAQs on the topic. The direct link to the FAQ is http://support.sas.com/kb/20/430.html Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds t...

Web resources about - Import Data in the SAS Folders with SAS 9.3 - comp.soft-sys.sas

Virtual folder - Wikipedia, the free encyclopedia
In computing, a virtual folder generally denotes an organizing principle for files that is not dependent on location in a hierarchical directory ...

Share Dropbox Folders With Facebook Friends
... of shared content. Dropbox differs from from other file sharing apps , or at least the ones that connect to Facebook, in using folders for ...

Facebook updates Home, adds folders
Facebook on Monday announced an update to Home , its platform for Android. Now Home users can categorize their apps into folders. A Facebook ...

Flo-Box - Private Photo + Video Folder on the App Store on iTunes
Get Flo-Box - Private Photo + Video Folder on the App Store. See screenshots and ratings, and read customer reviews.

Samsung Introduced New 2G, 3G Folder Phones for Respected Old Generations - Flickr - Photo Sharing!
Samsung Electronics said on Thursday that it will introduce user-convenient 2G and 3G folder phones under the brand name of ‘Samsung Master’ ...

New Apple TV tvOS hacked to show iOS-like app folders
... the first tvOS 9.1 beta to developers earlier this week, but it lacked the addition of one major feature many have been calling for: folder ...

OneDrive’s latest update brings 3D Touch support, scoped folder search
... owners to take advantage of Microsoft’s Intune mobile application management support. However, it’s the return of another feature, Scoped folder ...

tvOS 9.2 beta 1 adds support for app folders, Bluetooth keyboards
... update for the fourth-generation Apple TV adds a number of new capabilities for the fresh platform, including the ability to stow apps in folders ...

tvOS 9.2 beta introduces folders and restores Bluetooth keyboard support
... tvOS 9.2's new features are all versions of things that already exist in iOS 9 or in the old Apple TV operating system. The biggest is folder ...

Instantly switch to favorite folders with Quick Access Popup
It happens all the time. You’re working in Explorer, maybe opening or saving a file, but the current folder is so far away that you have to click, ...

Resources last updated: 3/7/2016 6:47:33 AM