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...

...DDE "Excel|&Pth.[&Doc2.]I&E inc portfolio section!R11C5"; Filename XLin2 DDE "Excel|&Pth.[&Doc2.]I&E inc portfolio section!R12C5"; Data InData2; * Account Number; Infile XLin1 dlm='09'x notab missover dsd; Informat Account 10.0; input Account; Format Account 10.0; *Date; Infile...

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...

...not in ("-rw-rw-rw-", "-rwxrwxrwx") and owner = "&sysuserid")); run; proc sql noprint; select distinct dsn into :DSETs separated by '*' from Limit_RW; select count(distinct dsn) into :DSET_Count from Limit_RW; quit; %macro Change_RW(); %if &DSET_Count. >=1 %then %do...

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...

...to the file. If you choose to use ZipGenius, there is a macro we use (code below) to zip files. %macro zip_files( filename=, add_file=*.*, password=0, working_directory=C:\Program Files\ZipGenius 6\, program_name=zg.exe, batch_location=C:\zip_batch.bat )...

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

...%if "&cur_dir" ne "" %then %do; put "cd &cur_dir"; %end; put "mkdir &new_dir"; put "close"; put "quit"; run; filename scr clear; *option xsync = 1; %sysexec ftp -s:"&script_file"; %sysexec del "&script_file"; *option xsync = 0; %mend ftp_create_folder; Thanks Robbie

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...

...a new SAS file and put in the below code:- %macro ncftp_send_files( destination = , source = , host = , username = , password = , local_files = *.*, log_file = %str(), batch_file =C:\ncftp.bat ); option xsync=1; %let src_len = %sysfunc(length(&source.)); %if...