I am not sure still if file type is not supported.  https://documentation.sas.com/doc/en/itechcdc/9.4/wbsvcdg/n0e44v8zffokk6n1b5uu2alusw8p.htm  if we use multi part when sending the request, it should be able to retrieve the attachment but I am not able to do that. on the other side I am thinking what could be option if I use rest instead of json.  ... View more

I think it should be set in the SQL Server itself. I have experience with a weired situation where the issue related to table name cases, it was not case insensitive and we resolved with setting collation.  What I can remember as well there are some options in the SAS Management Console as well, we need to  check.  ... View more

I did not understand. Could you please just tell me which SAS client are you using ? Are you connected to correct metadata sas server ? Where is the file located ? If it is located on Windows machine then try ftp client to transfer it on server and then try again. If still you are not able to access it. Please write the procedure with screenshot. I will assist you. ... View more

if you follow the link it will provide you more information. I have been using it frequently when I need to write data or read data from excel file. a  typical libname ( I am copying it again from the link I have mentioned above. )   libname mylib XLSX '/folders/myfolders/sas_tech_talks_15.xlsx';    If there is any specific requirement let me know. following link can help you more :  http://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/ ... View more

did you try libname statement with XLS engine, there is one more engine I guess available.  It will be very easy to deal with excel sheets.  may be the following link could be helpful. http://blogs.sas.com/content/sasdummy/2015/05/20/using-libname-xlsx-to-read-and-write-excel-files/ ... View more

The Error you have reported is coming when you are comipiling the macro or after calling the macro ??  if possible can you please provide full log for the same ?  ... View more

@Aditi24Can you please write your requirement again please ?  if you can give the following a try may be it will help you.  https://www.mwsug.org/proceedings/2011/appdev/MWSUG-2011-AD09.pdf   ... View more

%macro _lets_compare(lib1=,lib2=, lib3=); /*count the datasets and check if number of datasets are equal*/ proc sql ; select count(*) into : cnt_lib1_dtst from dictionary.tables where libname = upcase("&lib1"); quit; proc sql ; select count(*) into : cnt_lib2_dtst from dictionary.tables where libname = upcase("&lib2"); quit; %if &cnt_lib1_dtst ne &cnt_lib2_dtst %then %do ; %put %str("the count of datasets not matched"); title "datasets in &lib1 but not in &lib2"; proc sql ; select memname from dictionary.tables where libname = upcase("&lib1") except select memname from dictionary.tables where libname = upcase("&lib2"); quit; title "datasets in &lib2 but not in &lib1"; proc sql ; select memname from dictionary.tables where libname = upcase("&lib2") except select memname from dictionary.tables where libname = upcase("&lib1"); quit; %end; %else %do ; %put %str("the count of datasets matched"); %end; /* copy the datasets into third library */ proc copy in = &lib2 out= &lib3 ; run; %mend _lets_compare ; ... View more

I have been always thinking to create a custom task. It is possible in SAS Stuido.  By any chance can we use the same in enterprise guide ??  ... View more

The calculation of last month can be modified, I mean what will happen if cu_month = 1, then the la_month and year will change.  also If proc_dt is compared with macro variables it should be date constant.  Like  call symput('start',put(start_date,date9.)); call symput('end',put(end_date,date9.)); and where condition should be :  where proc_dt between "&start."d and "&end."d;   the calculation of start and end can be modified using sas date functions. ... View more

Hi Santosh You can use ORACLE LIBNAME Engine to reduce the time. Hope following will work for you - please set options correctly. ( path, schema, user , orapw ) LIBNAME oradbms ORACLE PATH=  SCHEMA=  USER=  ORAPW=   ACCESS = READONLY DBINDEX = YES ; Best Regards Chandra Prakash ... View more