Hello,   We're trying to solve a problem related to the security of the data within a sas dataset (.sas7bdat file), we have a bunch of tables on a directory on a linux system, and we have different bussines segregation info in the datafiles, we would like to know if there is a solution to allow sas to restrict the access to this data for different users, for example: dataset clients, has information about clients from different geographies and i need to let user1 to get data from french clients and user2 spanish clients.   Data is segregated by a column with the nacionality of the client. without separating the dataset into 2 datasets, is there a way to restrict this dataset access?   thanks ... View more

Hello all,   i'm trying to figure out if it's possible to convert a dataset file, for example, like this:   Example.sas7bdat col1      |  col 2 a           |      b a1          |     b1     into a description file, like you do with oracle, that would look like a datastep proces;   data example; attrib col1 format=$4.; attrib col2 format $4.;   col1=a; col2=b; output;   col1=a1; col2=b1; output;   run;     is it possible to create this kind of description file form a dataset with a procedure?   thanks! ... View more

Hello,   i'm currently in a migration moving from AIX to UNIX (RHEL) and we need to migrate our sas dataset files from source to new server, since there is an incopatibility between filesystems, and we're using PROC MIGRATE mapping source libraries on new server RHEL, PROC MIGRATE runs about an average of 150GB per PROC running ( i've seen i can run more than 5 PROCs at the same time without problem) and this tooks arround 10-20% of the cpu consumption, my question, is there any posibility to increase the ratio or the resurces the PROC takes to increase the performance and get better migration rates? my goal would be 300GB/h in order to have all the data migrated in 1 day.   If any one has encounter this situation during a migration may can help!   Thanks ... View more