Hello,   How to keep the significant digit (numerical variable) while copy the data set into an Excel File.   %let testing1=/f..../me; libname report xlsx "&testing1./Temp7.xlsx";   data report.today; set test; run;   Does someone know if there is something to do to avoid to lose my  significant digits for var5 et var6   Regards,       ... View more

Hello,    I am using SAS EG 7.13 , and I need to create an Excel file with two different sheets containing title (see the provided worksheet). I the first sheet will be filled-up first then close.  The data will be bring into the second sheet using another sas program ( it is why , I am looking for an append option).   Can we do this task with ods or with another one.     ... View more

Hello, I am using SAS EG 7.13 on a unix server.  I was able to put the list of all the folders in a macro variable. (see the code below).   %let home = %sysget(HOME); filename _folder_ "%bquote(/)"; data filenames(keep=memname); handle=dopen( '_folder_' ); if handle > 0 then do; count=dnum(handle); do i=1 to count; memname=dread(handle,i); output filenames; end; end; rc=dclose(handle); run; filename _folder_ clear; proc sort data=filenames out=FolderList; by memname; run; data FolderList; set FolderList; where memname not contains '.log'; run; proc sql noprint; select memname into :list separated by ' ' from work.FolderList; quit; %put &list;   From there, I would like to make a macro tha will search for a specific file type in each subfolder (those of the &list) and give me the name and the path of a file having the extension .sas or .log or .spds9   For example,  %macro Path_Name (path=&list, FileName=.sas); ?????????????? %mend; %Path_Name (path=&list, FileName=.sas);   So If I execute the above mentionned macro which is not complete, I would like to get a listing of all the file ending by .sas as well as there location.   We could execute the same macro to find the file ending by .log or .spd9 and so on as well as there path. Does someone know how to get this info on a unix server. regards   ... View more

data shoerange; set sashelp.shoes; run; proc format; value salegrp 0 - < 100000 = 'Lower' 100000 - 200000= 'Middle' other ='Upper' ; run; proc freq data=shoerange; format sales salegrp.; table sales;   Does someone know what I should add to that code to get the mean value of the middle sale group? ... View more

Hello,   I would like to convert SAS dataset into xml file using parallel processing and instead of using a do loop statement in a project, it was recommended to use a call execute statement (see the code below as well as the attaché log file).   However, when I execute the code, the xml file are generated but I receive the error message shown in the subject section. I made many tests to eliminate this error but without success.   Does someone could help me with that issue. Regards,   %macro test3(param1= );   /*Telling to SAS we want to start a parallel process*/      options sascmd="!SASCMD";      /*Assigining a Thread to a CPU*/        SIGNON sess&param1.; /*Declaring local variable*/        %let FileName1=data_2_500000;      %let FileName2=data_5_500000;      %let FileName3=data_10_500000;      %let FileName4=data_20_500000;        %let mylib=\\SFPFI4335.PROD.MRQ\Usagers-DGTT\RLEA109\Documents\Test\Parallel Processing\XML\&&FileName&param1...xml;      /*Transfering local variable to remote host*/        %syslput _LOCAL_ /REMOTE=sess&param1.;      rsubmit sess&param1. wait=no;    /*Checking global variable*/                %put &param1.;           %put &FileName1;           %put &FileName2;           %put &FileName3;           %put &FileName4;           %put &mylib;   /*Declaring the libraries  ******/ libname mydata "\\SFPFI4335.PROD.MRQ\Usagers-DGTT\RLEA109\Documents\Test\Parallel Processing\Data";   data _null_;      rc=libname("lib&param1.","&mylib.",'xml','xmltype=oracle'); run;                 /*Converting the dataset to XML file*/                %put lib&param1.||"after the libname call";           %put &&FileName&param1.||"after the libname call";             data lib&param1..&&Filename&param1.;           set mydata.&&Filename&param1.;           run;           libname mylib clear; libname lib&param1. clear;           /*********************************************/          endrsubmit; /*End of the session*/ %mend test3; /* %test3(param1=1); %test3(param1=2); %test3(param1=3); %test3(param1=4); */   Data _null_; do j=1 to 4;      call execute(cats('%test3(param1=',put(j,best.),');')); end; run; ... View more

Hello,   I am using a do loop statement to call a macro function which need the variable k to be passed as below   %macro mymacro; %do k=1 %to 1000; some instructions... %end; %mend mymacro; %mymacro;   How can I replace the do loop statement by call execute. Could you please provide me a simple example. regards,   ... View more