Search results for query: *

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

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

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

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

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 All, Not 100% sure about this question as only know a little bit about what happens when you rsubmit things... Below code:- rsubmit; filename Runcode "Macro_Runs.SAS"; Data t1; set Product_Links; File Runcode; Length SubStr $200; If Franchise NE "All" Then SubStr =...

Hi All, Need some help with the intck('weekday' statement... I have the below code. Data Test; DateDiff = intck('weekday', '01JUN2007'd, '12JUN2007'd); run; Now there should be 8 weekdays between those two dates, but when i run the code i only get 7... I want to see how many weekdays...

Hi all, Need some help with the below statement:- if run_day = 1 then sunday=&last_rundate-7; else sunday = intnx('week.2',&last_rundate,-2,'end'); Last_rundate is today()-1; run_day = weekday(&last_rundate); I've been trying to figure out what the above does for the past day now, i...

When sending an E-mail through SAS, is there a way to Embed an ODS HTML report in that E-mail instead of sending it as an attachment?? Thanks in advance Robbie

Is there any way that i can find out when a Dataset Was Created and Last Modified with SAS Code? Im trying to write a Data Check Macro to Check all of our Datasets (provided by another department), to see if and when they were updated. So the macro will check when it was created, when it was...

Hi, Need some help from you guys... Im using SAS to auto send an e-mail when my SAS report has finished using the below code:- filename mymail email ("Name1") subject="Please find attached Potential Saves for &yest." attach=("T:\TRAC\Robbie\Failed_Trucks\saves.zip"); data _null_...

Hi Guys need a little help again, I've noticed that when using ODS HTML it auto inserts some JavaScript:- <SCRIPT LANGUAGE="JavaScript"> <!-- // This script is to load all object onLoad() functions function startup(){ } function shutdown(){ } //--> </SCRIPT> into the HTML files, which is...

Hi Guys need some help, Have the following code below:- proc sql noprint; select count (Holiday) into :count_Line from Merged Where Holiday ne ""; quit; %if (&count_Line ne 0) %then %do; %ChkHolidays(); %end; Which does a count on the holiday Field in the Merged Table and puts...

Hi, Need some help.. Ive got a Dataset with a few variables, one of them being a Date field, and another one being a Temperature. What i want to do is combine the Date and the temp field in a text variable.. So at the moment the Date field is shown as Date9. (02Jul2005) So when i try...

Hi all, Need some help again, I've a macro setup to export a series of CSV files for each region we have, and this report will be ran monthly. But what i would like it to do is export the CSV files to its own folder depenging on the Month/Year... E.g Running this report now, it should create...

Hi, Having a little problem with a Macro. Every time i run the macro, my SAS session will hang at the very end.. %Macro Region(FTitle=,Franchise=); Data &FTitle.; set rwork.Restoration_data; Where Franchise = "&Franchise."; Keep Franchise Account_No Workorder Problem_Code Problem_Desc...

Hi guys, Need some of your expert wisdom! :) This is the first time im using the First. and Last. and im having a little trouble... Ive the following code below:- Data Telco_Features_By; set Telco_Features_Raw; By Workorder; retain last_Act_date MyCount; if (first.Workorder) then...