Hi,  I need to execute a sql using like condition, That means i need to add % signs to the condition string. I having a hard time figure out how to do it.  I have a macrovariable that has the value  "tablename" what i want to do is to put % chars before and in the end of the string. I have tried using %str,%nrquote and %quote    %let tb="tablername"; %let likecondition=%str(%&tb%); %put likecondition; I have also tried compress but it seems that i cannot mask the % as string.  have  "tablername" want  "%tablename%"   How do i do this in sas macro or data step if that is preferred.        ... View more

Hi,  Im trying to read a dataset "application_data" created in sas 9.2 from my sas 9.4 env,  when running this  libname old "s:\work";     data read_old;           set old.application_data;     run; I gives me the error  ERROR: File OLD.APPLICATION_DATA DATA not compatible with this SAS Version    I am able to read the dataset in SASEG 7.1  by open the dataset from the file menu     But i need to do this in code because im running in batch mode.  I have been looking at cport cimport but that did not solve my issue,    Any ideas        ... View more

Hi Sas,  when running delete from table thought SQL Passthrough on mssql from OPC batch it errors out  with ERROR: No data found/modified.    CONNECT TO ODBC AS PASSTHRU (noprompt="DRIVER={SQL SERVER};DATABASE=&_DB;Trusted_Connection=Yes;SERVER=&_INC;ansiNPW=yes;ansi_null=YES;autotranslate=yes"); &SQLINI from connection to passThru ( DELETE FROM SQL.TESTTABLE ); DISCONNECT FROM passThru; i have notice that it has been mensioned in the past and there should be a hotfix  https://support.sas.com/kb/42/537.html But as for now this is not an option. Does anybody know of any workound to avoid this.        ... View more

Hi,  I need to  scan a string separated by comma where column text sometime contains a comma itself  here i have extracted som text from a view definition on mssql and in that  def there is an expression  create view x as select Column1 as Column1, Column2 as Column2, ISNULL(Column3,' ') as Column3 from y    When i try to split the string into word separated by comma it doesn't work well      data teststep; i=3; res ="Column1 as Column1, Column2 as Column2, ISNULL(Column3,' ') as Column3"; coldef = scan(res, i, ','); run; Gives the result  ISNULL(Column3 i want it to result in  ISNULL(Column3,' ') as Column3       ... View more

Hi,  I have been looking on how to include sas files in my program to a parent directory regardless from where it is executed    if i check my sas progrtam out to c:\temp then c:\temp is my current folder  in my code i include some macro sas files i want to have access to in my programs      filename mmacros "..\macros\*.sas"; %include mmacros/source2; That doent work  then i tried to look id i could use    %put %sysget(SAS_EXECFILEPATH); This only runs in batch mode, so i will assume this will work when i run from OPC/Tivoli Scheduler    Then i tried to refer to  %put &_SASPROGRAMFILE; This macro is not initialized or look empty.    i am on SAS 9.2 with SAS-EG 4.3 logged into a metadata server also  windows.    ism it possible to get the current path where the file i execute is located from SAS-EG program.  nb: i only use SAS-EG as an IDE my code will run as base sas code.          ... View more

Hi  I am trying to add '% before and at the end of a macro variable  it does the job but i cannot avoid the warning.    it seems that it has something to do with the % that sas try to resolve in a certain way.    my code    %MACRO squote(value); %unquote(%str(%')%qsysfunc(tranwrd(%superq(value),%str(%'),''))%str(%')) %MEND squote; %MACRO GET_VIEWS(TABLENAME); DATA _NULL_; CALL SYMPUTX ('TABLE', &TABLENAME); RUN; %PUT table=&TABLE; %LET TEST=%squote(%SYSFUNC(CAT(%,&TABLE,%))); %PUT TEST=&TEST; %MEND; %GET_VIEWS('MYTABLE'); Is there a way to escape  % and single quotes and add them dynamically  ... View more

Hi,  i am trying to substr myu macro variable,  %macro runit; data _null_; call symputx('control_tb','sqldlz.mytable'); run; data _null_; put substr(&control_tb,6,length(&control_tb)); run; %mend; %runit; 20 ! data _null_; 21 put substr(&control_tb,6,length(&control_tb)); _ 22 76 ERROR: Invalid variable specification, sqldlz.mytable. Variable names of the form X.X must be either FIRST.X or LAST.X. ERROR 22-322: Syntax error, expecting one of the following: [, {. ERROR 76-322: Syntax error, statement will be ignored. it errors out with    what is wrong    ... View more

Hi,  I am trying to create a datastep thats compares values some dates back in time  what i am looking for is to identify which name where the amount changes every day and which only change every 5 or 7 days      my data are like this  name , date, amount  ann, 2020-05-11, 1200 ann, 2020-05-12, 1200  ann, 2020-05-13, 1300 pete, 2020-05-11, 1200 pete, 2020-05-12, 1200 pete, 2020-05-13, 1200 simon, 2020-05-11, 200 simon, 2020-05-12, 1200 simon, 2020-05-13, 1200 Hope someone an help            ... View more