Search results for query: *

Wrong number of arguments or invalid property assignment: 'Parameter' When i use Parameter.Count

Hi All, I need a little bit of scripting help here. Within OBIEE (web based Business Intelligence tool) we send a file to a VBscript with a list of Arguments/Parameters. Now generally i know you can use the below code to count the number of arguments passed: Set objArgs = Wscript.Arguments...

Hi, I've pulled a list of about 3k Excel Documents in a folder on our network drive. I want to loop through those documents and DDE in some information (there are about 200+ values in the document but will only list 2 of them below) The problem im having is when there is an & or a ' in the...

Hi All, Need a little bit of help/info. I'm trying to setup some automation with the reports in my new workplace which uses Excel and DDE quite heavily. Now using DDE to enter data into a worksheet isn't a problem when using the triplet, but the problem I've bumped into is Saving and closing...

Hey, Sorry for late reply, but i managed to get it soretd, code will scan through library and find all tables crated by current user logged on, and change tables to 777. Code below:- rsubmit; %global DSETs DSET_Count; filename lsinfo pipe 'cd /sas/data/techtm; ls -l'; data techtm_files...

Hi All, Need a bit of help. Is there a way to list all tables that I own in a Library? The reason for this is because our SAS admin have decided to make it so that only the people who created the table, can make changes to it.. So.. I want to make a little program that looks in a Library and...

I'm not sure if winzip has the command to add password/encryption on command line. If you open a dos wnidow and type winzip -? (or whatever the exe is -?) it will give you all the options you can use with the exe. We use ZipGenius in work which gives us the option to add a password to the file...

You can use First.Variable to do this. But this will only work if the Names are all together (e.g sorted by name). Data Results; set Dataset; by name; retain prev_result; If first.name then do; prev_result = result; end; Else do; If Result = "" then do; Result =...

Just about to finish work (Yay for half days). But i think the below is along the right lines of what you want (although its very quick and dirty):- Basically the difference in values between the Pre and Post time.. 101 D-01 025:00 PRE 105 101 D001 025:00...

Hi Shelby, Take a look at the below link :- http://www.tek-tips.com/viewthread.cfm?qid=1423346&page=1 Robbie

Hi All, Need a little bit of help... Im trying to connect to a MySQL database though SAS, apparenly the MySQL connect Engine isnt installed, but the ODBC engine is. So the connection would need to be done though that.. I've tried to connect using the below:- libname tastedb ODBC...

Hi, Is there a way of doing this in the code? I have a report that outputs about 1000+ HTML pages, which i want to dissable the "view output as generated". But when im writing new scripts, i want to view the output. So would be easier to just put some code at top of report to dissable the...

Hi, You could use TranWrd to remove them. e.g TranWrd(trim(Left(Variable_Name)), ","," ") Basically it searches the variable for a commer and replaces it with whatever you want.. (in this case a space) Robbie

Hi all, Need a little bit of help. In my dataset i have a variable called comments, i want to search that variable for a specific text string. I've done the below if index(Concat_Comments, "1091") then Error = "Y"; Else Error = "N"; But the only problem is its bringing back customers...

without tabs as the forum dont like tabs.... entry_date_time=sum((input(scan(entry_date_time_orig,1,' '),ddmmyy10.)*60*60*24),input(scan(entry_date_time_orig,2,' '),time8.));

Hi ymercier, Try the below:- entry_date_time=sum((input(scan(entry_date_time_orig,1,' '),ddmmyy10.)*60*60*24), input(scan(entry_date_time_orig,2,' '),time8.)); Robbie

Hi all, At the moment we are running all our programs on our local machine (Rsubmit-ing them). But due to increased workload we planning on scheduling some of them on the SAS server. So the FTP script were using wont work, as the script is meant for windows... and i've no idea about unix...

Im managed to sort it out.. There is a hotfix for the above error, but was still getting a problem. Its to do with the max length of the "Mac_String" variable, the max length of a string on the unix box was set to 255. So i split the string into 2 and then joined it. Works fine now :) Robbie

Hi All, Need a little bit of help here... Think i have everyone baffled in work regarding this... Im trying to run the below code remotely:- filename Runcode "Drill_Hod.SAS"; Data Franchise_Output_Macro; file runcode; set Drill_Hod; Length Mac_String $500...

Hi jameshopper, I upload a lot of my SAS reports to our intranet site, but i think the method your using above wont work as you might need FTP access to the remote site (from the looks of things, its probably an intranet site rarther than a shared network drive). There are x2 methods of...