cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jakarman
Saturday
  • 3,222 Posts
  • 153 Likes Given
  • 16 Solutions
  • 1,184 Likes Received
About
- implementing a secure environment with SAS. Skills form uinderstanding high level policies to OS-level options. - Helping users to get SAS working for them in a secure environment and with all technical and content questions.

Re: PROC GEE

by Barite | Level 11 in Statistical Procedures
‎08-20-2015 02:55 PM
‎08-20-2015 02:55 PM
See  SAS/STAT(R) 13.2 User's Guide  you need SAS/Stat 13.2 The experimental note is gone SAS/STAT(R) 14.1 User's Guide Versions is a challenge: http://blogs.sas.com/content/sasdummy/2013/08/02/sas94-eg-versions/ ... View more

Re: SAS and Encrypted Data

by Barite | Level 11 in Administration and Deployment
‎08-20-2015 11:25 AM
‎08-20-2015 11:25 AM
As it is Windows you could run bitlocker as it is coming with the professional license. This wil encrypt harddisks a mitigation for the physical attacks. You need a third party tool with Unix for this. It wil not protect any data for abuse by admins eg with their backup/dr operations. - SAS datasets can be encrypted using SAS  AES is possible wiht 9.4. That will mitiaget sensitive data in sas type datasets. - The temporaries (work/util) should be emptied cleaned. Having those in backup or DR is not very smart. - Any data access at OS level should be monitored when it is highly sensitive. Should be no issue as a standard mititagation.   Wiht those acttions the need for a third party tool encrypting data on personal access is less necessary.   ... View more

Re: prompt will only fire up when RUN BRANCH FROM is executed and not ...

by Barite | Level 11 in SAS Enterprise Guide
‎08-20-2015 09:55 AM
‎08-20-2015 09:55 AM
I checked eguide behavior (5.1) with:  code  1 middle pane - 2cleft pane   flow /3  middle pane and 4 right pane several wasy to start. Prompts are never being missed. ... View more

Re: SAS and Encrypted Data

by Barite | Level 11 in Administration and Deployment
‎08-19-2015 02:43 PM
‎08-19-2015 02:43 PM
Rebooting the server is looking something went terrible wrong. I found: https://www.sophos.com/en-us/medialibrary/pdfs/manuals/sglc_38_aheng.pdf  There is note on word renaming files (4.4) could be a problem. SAS is also doing things like that. Some others: - Another one when processing SAS files you will notice it will be written out in bigger chunks like 20Mb due to caching and other optimization like a RDBMS is doing.   - As Sophos has hacked the IO interface maybe SAS has also hacked some things. http://downloads.sophos.com/readmes/readsglc_39_ceng.html just try and validate some processing with bigger datasets (including sorting). Review whit is known and how it should work.  ... View more

Re: Unable to update more than one fields using PROC SQL:

by Barite | Level 11 in SAS Programming
‎08-17-2015 12:52 AM
‎08-17-2015 12:52 AM
Ok reading and processing flat files not databases or sas-datasets. That is an important pre-req. Processing a flat file (searching) is possible when you define a view to that SAS(R) 9.4 Language Reference: Concepts, Fifth Edition Updating flat-files in place (record oriented) is possible. 24782 - Update an external file in place Dropping records however is not possible with flat file processing. You can read it all and create a new one.  PDSE or using a GDG - batch processing. What environment are you? Is that a/ Mainframe and which b/ sas release you are using c/ using classical bound data set or a HFS approach? What is the sizing of those flat files (no records/vars) , should it run interactively or only in batch When rewriting the flat files and performance is not a problem you can read/convert them to SAS sort as you like with an ordering indicator (making  _n_  permanent) reorder back (sort) before writing out. That is the most easy understandable coding. ... View more

Re: Unable to update more than one fields using PROC SQL:

by Barite | Level 11 in SAS Programming
‎08-16-2015 11:46 AM
‎08-16-2015 11:46 AM
I do not get the concepts of DYL-280. It looks to the question on file-record processing. The @ usage in the samples is looking for me to be  on mainframe fixed records processing. I that correct?   The remark as the files are used for other projects is pointing in that direction.is In that case use data-step views to describe the records so you can process them afterwards.    This will avoid as much of the IO as possible. A direct search with proc SQL on a datastep view can behave rather well. As the SAS approach is normally updating complete tables I want to know about that binary search with DYL-280 and updating one record. What are all used techniques used in for us understandable words?  ... View more

Re: LIBNAME ODBC with NOPROMPT option on Unix

by Barite | Level 11 in SAS Procedures
‎08-16-2015 02:23 AM
‎08-16-2015 02:23 AM
Sorry to react that soon....  https://documentation.progress.com/output/DataDirect/preview/odbcmongohelp80/index.html#page/mongodbodbc/dsn-less-connections.html   About the Driver : Using the Driver : Configuring and Connecting to Data Sources : Configuring the Product on UNIX/Linux : DSN-less Connections There are the names of the drivers being mentioned in the odbcinst file. "At the beginning of the file is a section named [ODBC Drivers] that lists installed drivers, for example,            DataDirect 8.0 MongoDB=Installed" The sample are giving more details on the complete list: DRIVER=<ODBC Driver Name>;HOST=<Hostname>; PORT=<Port>;DB=<DatabaseName>;UID=<Username>;PWD=<Password>;DIL=<DEFAULT ISOLATION LEVEL> Progress KB - How to setup the connection string for an ODBC DSN-less connection to a Progress database? How to setup the connection string for an ODBC DSN-less connection to a Progress database? ... View more

Re: How to end sas session conditionally in Batch mode (UNIX)

by Barite | Level 11 in SAS Programming
‎08-16-2015 02:09 AM
‎08-16-2015 02:09 AM
Statements endsas and errorabend are doable in batch, developping in Eguide (and others) it is a bad approach.  https://communities.sas.com/message/148347 see CH In structures programming it is better to validate all conditions at the first steps. Than only whan all input is valid to proceed With a bathc approach don't make the program too big. smaller pieces are easily connected. Restarting / recovering will become more easy. ... View more

Re: RE: SAS 9.4 Security Administration

by Barite | Level 11 in Administration and Deployment
‎08-15-2015 02:24 PM
‎08-15-2015 02:24 PM
SAS Metadatasecurity in control over Oracle security who has told sold that idea? Opening on Oracle with shared generic user is bypassing overruling Oracle. Orcale has his own security you could connect that to LDAP and than defnining a trust. Still needing to define the user into Oracle in the same way as at the OS level. With the indentities present in Oracle the DBA can define the roles access and logging as Oracle security is meant to be. ... View more

Re: LIBNAME ODBC with NOPROMPT option on Unix

by Barite | Level 11 in SAS Procedures
‎08-15-2015 09:54 AM
‎08-15-2015 09:54 AM
AlanC,, I mentioned the JDBC approach as it using a connection string bypassing the odbc.ini on the same ODBC client installation. Conclusion: It should be technically possible to have a DBMS ODBC connection in SAS not needing that ini file.  We do not know whether and how SAS would do this. JDBC is java code you can run java code from within SAS. SAS(R) 9.4 Language Reference: Concepts, Fifth Edition Conclusion: when nothing as libname is workable that could be a way out. The major point could be: Which SAS version you are running and which ODBC software is installed on the Unix. You didn't mention anything about that. The remarks are rather cumbersome that those  choice is having much impact on the coding with ODBC interfaces. "see your odbc client installation manual". Yup which one?     When you have that and a jdbc sample is given put that in the noprompt area. Reviewing that approach to jdbc-oracle it is the same string going into the path option. Any error  message should help. A firewall or other one could be a blocking one. First try something easy that is working. There must be a connectionstring like MySQL Connector/ODBC 5.1 Connection Strings - ConnectionStrings.com Different coding as of the odbdc.ini file like MySQL :: MySQL Connector/ODBC Developer Guide :: 5.2 Connector/ODBC Connection Parameters ... View more

Re: LIBNAME ODBC with NOPROMPT option on Unix

by Barite | Level 11 in SAS Procedures
‎08-15-2015 03:56 AM
‎08-15-2015 03:56 AM
For most database types the connections you should be able to be done in a easy jdbc way leaving it all to the programmer. It are ICT departments blocking that and wanting to be in control of those definitions. The new threat is having that all done by ICT staff in SAS metadata. Let us see to get rid of that.   I know with TD there is a machine (DNS) connection, then only a schema/database is needed. The oracle example is more easy for me as it is documented now SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Seventh Edition See the path settings. Those are the settings found in the tnsnames.ora. Ergo: You don not need that file tnsname.ora .    With ODBC the Libname states SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Seventh Edition  required prompt complete are not supported with Unix but noprompt is. There is dependency with the ODBC driver as you have many (Unix) and not just one (Windows) that is preinstalled. SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Seventh Edition For the necessary confusion http://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf look how often dedicated drivers are using the odbc.ini almost everybody is using that.  This progress one is mentioned for MS-SQL Unix Linux ODBC Driver from Progress DataDirect  The jdbc has a connection object not using the odb.ini (server port etc) but is different for each type of dbms. SAS has documented the wasy how to connect th SAS/Share SAS(R) 9.4 Drivers for JDBC: Cookbook (wrong direction you want from SAS to others ) this one are some examples 52777 - Examples of SAS/ACCESS® Interface to ODBC LIBNAME code used to access a Microsoft SQL Server database without configuring an ODBC data source name but not complete to your question ... View more

Re: How do I code my Enterprise Guide (server version) to upload and r...

by Barite | Level 11 in SAS Enterprise Guide
‎08-13-2015 02:24 PM
‎08-13-2015 02:24 PM
The SAN is an external environment your local server is connected to. It hides all hardware and delivers some virtualized image.  You can imagine the complaints as lack of options into that pool of hardware. Just found one. Joe Chang : SAN Configuration Performance Problems There must be more (Same kind of experiences myself). The SPD Server is designed to benefit from segregation in those physical spinning (rotating) hdd's. There are nit physical anymore. I like to look at DBMS guidelines a they are mostly IO bound alos a blog like this http://www.brentozar.com/sql/sql-server-san-best-practices/ could help in the thinking on a server approach.  ... View more

Re: How do I code my Enterprise Guide (server version) to upload and r...

by Barite | Level 11 in SAS Enterprise Guide
‎08-12-2015 04:23 PM
3 Likes
‎08-12-2015 04:23 PM
3 Likes
Just drag and drop to an area with a file-tab. behind that there is binary transfer. Would you use the upload task, all data is converted to a datastep using datalines and that one is transmitted. SPDE on a Server? Makes only sense when having spread over several physical volumes. With a SAN behind there you have a different IO behavior. ... View more

Re: Issues with running DI studio jobs in SAS 9.4

by Barite | Level 11 in Administration and Deployment
‎08-12-2015 03:02 PM
‎08-12-2015 03:02 PM
Look at you SQL what is happening. Is it this one? SAS(R) Data Integration Studio 4.9: User's Guide "About the Table Loader Transformation" Or this one SAS(R) Data Integration Studio 4.9: User's Guide (Creating a Table That Appends Two or More Source Tables) Anyway the processing can be done in several ways in SAS base generated code SAS(R) Data Integration Studio 4.9: User's Guide Selecting a Load Technique in the Table Loader.   I would expect the table to be copied to saswork first and than going to a final destination or staging one. That can be and usually are several different file-systems. The error and root cause can sometimes be misleading. Do you have any logs / messages to share?       As you are saying the temporary (sas work?) is fine where is the destination dataset to be appended going to? What technique SAS-base code is used for that appending? ... View more

Re: Help with tunning - sas disk space

by Barite | Level 11 in SAS Procedures
‎08-12-2015 01:21 AM
‎08-12-2015 01:21 AM
Augusto,    your list is looking like some chosen checkpoint made by an auditor. 1/  data  without access by users *) Needed: List identifying the sas data file with  no access.. This is monitoring of all activity on all data on the OS level. With Arm log4j being  active SAS can do a lot of this.    You only can get a list if data that is used. Unused ones will cause no events.  Use the list of all data that is present  with that. (3,4,5)   2) Unused space / Filesystems *) Needed: List with identification of unused Filesystems. This is an OS task (xcmd usage)  the df command woll show all filesystems. With a decent setup you should see what is stores where and how much is free. The du command will make a list of the space in use.       3) Existence of compacted sas data file *) Needed:List with identification of compacted sas data files and processes that use them. Make a list of all directories with sas-datasets. The attributes off all datasets can be gathered as a new datasets. One of the elements is compress http://support.sas.com/documentation/cdl/en/proc/67916/HTML/default/viewer.htm#p1sy9ca8n2tv03n1savk4p9cmeq0.htm#p17vojw133aeyfn1u8modmp2mig9 Also available as a SASHELP.v----- view member.  The files that are compacted using zip or another to be analyzed  at OS elvel. Make a list at OS level (ls command using xmcd) of all OS files (recursive option is there)      4) Existence of sas data file with the same name * ) Needed: List identifying the sas data files with the same name but in different directories Having a list of all OS files have that on split in path name and filename.  Just ordering will give you an answer      5)  Compression sas data file *) Needed: A list of sas data file which may be compressed   Having a list of all SAS datasets with all their attributes. look for the ones that are not compressed and having long records/many variables many observations   6) Shared filesystems *b) Needed: A list of Shared filesystems Shared filesystems is an OS task. At Windows it is very common usage to propagate to a desktop.  Within in a –Nix system it is a “no  done” situation as of too many possible security holes. (mostly forbidden) With a SAS grid approach it could be there. Check with the storage admin / system admin. ... View more
Contact Me
Online Status
Offline
Date Last Visited
Saturday
Likes given to
Likes from
Quick links