Hi all,   my colleague has a problem with following statement :  libname dbacc Access Path="C:\test.accdb";   in my sasstudio environment it works without a problem. I can even use following statements to achieve the same:    libname dbacc Access "C:\test.accdb"; libname dbacc "C:\test.accdb";   With him it causes a peer exception and it shuts down the sas studio.   Does anyone can tell me what i can do. We both use the same server location.       ... View more

Hi all ,   i have the following Excel   0116 01161 01161A 01161A1 01161A2 01161B 01161B1   and so on. How can i manipulate my data to only keep the lowest sublevel meaning for this case :    01161A1 01161A2 01161B1   The file contains 1000+ . ... View more

I would like to know how one can insert data into an excell files using sas studio.   I can export into a new sheet without any problem, but inserting between some rows, i cant find it.    Some programs i have to use to load data , are using excell with a standard.    So i would like to know, how can i insert data between A2:A750 in a sheet named sas_output   ... View more

Hi,   im fairly new to tasks. I tried a few things and the basics go pretty well. But i have a question .   I want to populate a combobox in sas studio tasks. And the values have to be a distinced list from a table in a database.   How can i achieve that   Thank you very much ... View more

We have to start to work in SAS Studio. I have programmed almost 15 years in SAS 9.4 and i wonder if there is an alternative for the following issue i have.   I use the following macro : %macro copydb(in=, out=);   options noxwait; data _null_; rc2 = system("del /q &out..accdb"); rc= system("copy &in..accdb &out..accdb");   put rc=; run; %mend copydb; It gives me the oppartunity to create a base database for my users where they can add standard data tables and queries, in my program i create a copy and add results to the new database. So the users can use their queries and dont have to do anything.   Is it still possible in SAS Studio to use this. If Not , is there an alternative ? ... View more

Dear all,   our company recently moved from sas 9.3 to sas 9.4 so we moved from 32bit to 64bit. Now i have performance issues. Some programs ran for 30 mins now turned into 5-6 hours.... And the main issue is Microsoft office.   Loading data into accdb (300k records and 8 variables takes approx 40 minutes... it used to be like 5 minutes).   Is it possible that issue is : SAS 9.4 = 64 bits, Microsoft Office 2010 : 32 bits.   Is there a workaround? I use libname odbc to access accdb files We have following licenses :   ---Base SAS Software       ---SAS/STAT       ---SAS/GRAPH       ---SAS/ETS       ---SAS/FSP       ---SAS/OR       ---SAS/AF       ---SAS/IML       ---SAS/CONNECT       ---SAS/Secure 168-bit       ---SAS/Secure Windows       ---SAS Enterprise Guide       ---OR OPT       ---OR PRS       ---OR IVS       ---OR LSO       ---SAS/ACCESS Interface to ODBC       ---SAS/IML Studio       ---SAS Workspace Server for Local Access       ---High Performance Suite       ... View more