Hello,   I have tried to use the following find command find  -maxdepth 1 -type f /dwh_operation/sasprocess/smp_production/smp_ref/sasmacro to get the file listing into that directory but without getting those from the subfolders.     Also, I have tried the ls command:   ls /dwh_operation/sasprocess/smp_production/smp_ref/sasmacro -l --time-style=long-iso so, I am getting all the information on a file that I need but I am getting also subfoldername into the listing as well as the listing of the files hosted into those subfolder.   Is there a way to use the ls command to get the listing of the file only in the specify folder not those from the subfolder Thanks in advance for you help. ... View more

Hello, I am using find command below to get the list of the subfolder that are not empty or that do not contains the name old and it works fine. find /dwh_operation/sasprocess/smp_production/smp_ref/ -not -empty -not -name old -type d   Then imagine that I obtains Path1 and Path2 as results.   What will be the unix command if I want the list of the files found in path1 and path2 , in one shot but not the files in their respective subfolder.   I though it could be something like find path1 || path2 -not -type d but I am getting all the files of their subfolder.  I just want to get the files name in Path1 and Path2   Does someone can help me with that issue.   Regards,     ... View more

Hello,   We were advise that our enterprise will update our sas version.  I wonder if there were some documentation available on some tests we could carry out to check the new version.   Help will be appreciated. Regards, ... View more

Hello,   I would like to know how to call a macro on  a Unix server (see the macro below)   %macro Transferbookibnrtodev(dev=,cie=,yyyy=,mm=); libname source spde "/dwh_actuariat/sasdata/sas2020/&cie."; libname dest spde "/dwh_actuariat/sasdata/sas2020&dev./&cie."; proc copy in=source out=dest; select &cie._bookibnr_&yyyy.&mm.;   If we need to make a ksh file , please provide an example Regards, run; libname source clear; libname dest clear; /*Example of call: %Transferbookibnrtodev(dev=5,cie=golf ,yyyy=2020,mm=10);*/ %mend Transferbookibnrtodev; ... View more

Hello,   Does someone know how many significant digits do we have using a PD.6 format. Could it be possible to get a table showing the number of significant digits for each PD.x format.   Regards,     ... View more

%macro add_new_year_in_cal; %global Path; %let Path=/dwh_operation/sasprocess/smp_production/prod_smpi2/sasmacro/; OPTIONS SASAUTOS=("&Path."); %localizepilottbl; %include "&Path.update_trigger.sas"; %put &UpdatePilotTblTrigger.; %if &UpdatePilotTblTrigger. = 'Y' %then %do; %include"&Path.copyfilefromreftosmpi2.sas"; %end; %mend add_new_year_in_cal; options mprint; %add_new_year_in_cal; ... View more

Hello,   I have two files :  SAA1FM.CPORT SAH1FM.XPORT   I have use the following code to read the above mentioned file due to the propose procedure but I get this error: CIMPORT is not able to read XPORT engine data sets.   filename entree '/.../SAH1FM.XPORT'; libname sortie '/f.../data_test/'; proc cimport library=sortie infile=entree; run;   So I believe that I should use the xport engine, but I have never use it, and the few examples I have found, the filename end by xpt while mine end by .xport.   Does someone know  how to convert those in Sas dataset? Regards,             ... View more

Hello,    Is there a way to eliminate the file extension.   %macro lastmodifiedfile2(path,string,MName); /** Change the filename below to the following to run on UNIX **/ /** filename test pipe "ls &path -rt"; **/ /** Change the filename below to the following to run on Windows **/ /** filename test pipe "dir &path /od /t:w /b"; **/ /*filename test pipe "ls &path -rt";*/ /*filename test pipe "ls &path -rt|basename |grep &string.";*/ filename test pipe "ls &path -rt|grep &string. "; data _null_; infile test; input; call symputx("&Mname.",_infile_,'g'); run; %put Last file to be modified in &path is: &Mname.; %mend lastmodifiedfile2; %lastmodifiedfile2(&soudest1.,&suffix1., FName1); %put &Fname1.  &Fname1 is equal to pilote_2017_2021_validation_v004.mdf.0.0.0.spds9   Is there an extra command I can add to get only pilote_2017_2021_validation_v004   Regards, ... View more

Hello,   I am already using the macro below to get the latest modified file. As I am not very familiar with the Unix command, is there a way to improve this search tool to get the latest modified file in a folder for a file containing for example the word validation or the word scenario ?   %macro lastmodifiedfile(path,MName); /** Change the filename below to the following to run on UNIX **/ /** filename test pipe "ls &path -rt"; **/ /** Change the filename below to the following to run on Windows **/ /** filename test pipe "dir &path /od /t:w /b"; **/ filename test pipe "ls &path -rt"; data _null_; infile test; input; call symputx("&Mname.",_infile_,'g'); run; %put Last file to be modified in &path is: &Mname.; %mend lastmodifiedfile; %lastmodifiedfile(/dwh_operation/sasdata/smp_production/prod_smpi2/pilot/,Fname);   So I would like to modified the above mentioned code to permit to add a part of the filename. ex: //.../pilote_2020_validation_v1.spde...  //.../pilote_2020_validation_v2.spde...  //.../pilote_2020_validation_v3.spde...  //.../pilote_2020_validation_v3.spde...    //.../pilote_2020_scenario_v1.spde...  //.../pilote_2020_scenario_v2.spde...  //.../pilote_2020_scenario_v3.spde...    Moreover, I can't use the version number to trace the latest modified file.  So is there a way to modified the script to specify file containing the word validation, then the word scenario and so on.   Thank in advance for your help.         ... View more