Hi,   We launch SAS Enterprise Guide from a Citrix store in our organization. I was able to access all the stuff in SAS EG all these days.. However, it started throwing the below error and am unable to access any libraries.   The 'sas.iomprovider.1' provider is not registered on the local machine.   Any help is appreciated.     Thanks, Vijay. ... View more

Hi All,   We recently have migrated SPD server tables from a Unix machine to a Linux Machine (SPD server was installed in Linux machine as well). For a specific schema (eg SCHEMA1) the user (user1) has only read access and the other user  (user2) has write access as well.  Hence we used “user2” to migrate the tables from Unix to Linux.   Now , when we access this scheme on the new linux server with the user “user1”, it says ACL read access to the dataset is required.   How to make user1 to be able to see the tables (which were migrated using user2) in schema1 on the new linux server.     Thanks, Vijay. ... View more

Hi,   I am trying to access a library and it's contents using SASSPDS engine. The libname statement is highlighted below.   16 libname tlspd05 sasspds schema='ABCDE' host='xxxxxxxxx' serv='5180' user='tuser' 16 ! password=XXXXXXXXXXXXXXXXXXXXXX IP=yes; NOTE: User tuser(ACL Group ) connected to SPD(LAX) 5.2 HF(3) server at xx.xxx.xx.xx. NOTE: Read-only access to LIBNAME domain restricted by *LIBNAM* ACL.   Though the log says that this library has read only , I still am not able to read any of the spd datasets from this library.  The program throws an error  "ERROR: ACLREAD access to existing data set required.".    My understanding is when the library has read access, all the contents of that library should also have read access.   Is there any specific reason for this conflict?   Thanks, Vijayanand. ... View more

Hi,   1)Currently we are migrating SAS Data from Unix server to Linux server. We have identified that some sas datasets  have Data Representation   as  WINDOWS_32.  The data files (.sas7bdat) are getting migrated successfully but not the index files.  For these files , the output of PROC CONTENTS shows Indexes as 0.   How to understand this and how would we migrate these index files?     2) Some catalog files (.sas7bcat) ,when tried accessing using PROC CATALOG procedure, the message in the log was " xxxxxx.catalog "was created for a different operating system. How do we handle this.   Most of these catalog files have formats in them.   Thanks, Vijayanand. ... View more

Hi,   I am migrating an indexed sasdataset from an AIX server to a Linux server , using PROC DOWNLOAD. The data file got migrated but not the index file.  Even with PROC CPORT and CIMPORT , the index file was not migrated.   The index file is physically present on the AIX server along with the data file.     On further investigation into the results of Proc Contents on this dataset, it says that Indexes 0, which means there is no index defined on this dataset.   Though the index file is physically present, is it that the index file has no connection with the data file and the index file is of no use.   Thanks, Vijayanand. ... View more

Hi ,   We recently have migrated some SAS data sets from Unix server to Linux server. The data sets which were migrated already, are growing daily (some observations are being added,some are being updated and some are being deleted) on the source server (Unix).   How do we bring all these changes alone on to the target (Linux Server).    Some of the data sets are very hugs in size, so migrating the entire data set again from source to target is very time consuming and this has to happen daily , till the target server goes live.    Thanks, Vijay. ... View more

Hi,   What are the files with the extention sas7bitm and how to migrate them from an AIX environment to LInux environment.   Thanks, Vijay. ... View more

Hi ,   We are migrting SAS  Data from AIX to Linux machine.  For this we are using different SAS procewdures like PROC CPORT , CIMPORT , PROD DOWNLOAD etc...   These procedures are able to migrated SAS datasets, index files  and catalogs but not views.   PROC DOWNLOAD can migrate the views created using PROC SQL.     How to migrate the views created using data step.      Proc migrate can migrate the views but it has some limitations that it can not handle the views created on  AIX 64 bit OS.   Thanks, Vijayanand. ... View more

Hi,   I recently have migrated some sas datasets and catalog files using SAS/CONNECT  and PROC DOWNLOAD  from AIX to Linux machines.   I was able to compare the sas datasets using PROC COMPARE and PROC CONTENTS to ensure that there are no changes in the data after migration.   How do I compare the catalogs files (sas7bcat) in this case?     Thanks, VIjay. ... View more

Hi,   Recently I had to migrate  some of the SAS CATALOGS (SAS7BCAT) and SAS VIEWS (SAS7VEW) from AIX to Linux server.   How do I ensure that these catalogs and sasviews  are same across AIX and Linux.   Can I use PROC COPARE to compare teh catalogs and sasviews.?   Thanks, Vijay. ... View more

Hi,   We are migrating SAS datasets from AIX to Linux machines.  There are many ways to do this using different sas procedures. However, we tried doing it using SFTP process between the two servers.   With SFTP, we could transfer the sas dataset from AIX to Linux and compared both the datasets using PROC COMPARE and found that both the datasets are matching.   In case of an indexed sas dataset, we transferred both files (data and index  .sas7bdat and .sas7bndx) using sftp and compared using PROC COMPARE.  Here the data is matching , but the  target dataset on Linux machine doesn't have index created in it.   We know that PROC DATASETS can be used to create the index on a sas dataset.  Is there a way in SAS to couple these two files (.sas7bdat and .sas7bndx) so that the dataset on the target would also have an index.   Thanks, Vijayanand. ... View more

Hi,   We are migrating SAS applications running on AIX to Linux. As a part of this , we are using PROC CPORT and CIMPORT to migrate the data.   However, we have sas datasets in multiple folders (close to 10000) including all the sub folders in the AIX file system. Each individual folder is considered as one sas library. With this etup, we have to run PROC CPORT / CIMPORT 10000 times. Are there any other options this can be done easily.     Can rsync be used to transfer the sas datasets between two different operating systems?     Thanks, Vijay. ... View more

Hi,   We are migrating from SAS 9.3 to SAS 9.4.    The application has SAS DI Studio , SAS EG  , SAS Management Console and SAS IDP.  How do we migrate the metadata. Can we use Metadata Package Export and Import options to do this.   Do we need to take any special care as the current version is 9.3 and new one is 9.4?     Thanks, Vijay. ... View more