topic Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy in SAS Programming

How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

djbateman — Thu, 01 May 2025 19:12:23 GMT

I have written a lot of macros over the past that utilize pipe commands as in the code box below. The date from the dir commands has always been in MM/DD/YYYY for me. This has worked fine for quite some time because everyone that uses my code is either in the US or India, and we have all had our computers set to this format. However, we have been bringing in users from the UK, and they all set their systems to be DD/MM/YYYY. When they run my code, this pipe command swaps the day and month, and then I get invalid notes in my log because they don't consider 29/04/2025 to be a valid date. Visually, I can tell that this is April 29, but since my code is set up to read it as MM/DD/YYYY, it doesn't know what the 29th month is.

With all that background, is there a way to easily tell which format the value is in? I can set up some IF statements such that if the first 2 digits are greater than 12, then I know it's in DD/MM/YYYY format, or if the second 2 digits are greater than 12, then I know it's in MM/DD/YYYY format. However, if both are less than or equal to 12, I won't know. 04/03/2025 could be March 4 or April 3. Has anyone dealt with this scenario before?

filename SASlist pipe "dir /t:w &datapath.\*.sas7bdat";

data datadir;
	infile SASlist dlm="¬";
	length buff $2000;
	input buff;
	if _n_>3 & index(buff,"File")=0 & index(buff,"Dir")=0 then do;
		date=input(scan(buff,1,''),mmddyy10.);
		file=scan(buff,-1,'');
		dset=upcase(scan(file,1,'.'));
	end;
	format date date9.;
run;

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Kurt_Bremser — Thu, 01 May 2025 21:20:44 GMT

What do you get when you check the LOCALE system option in the environments?

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

quickbluefish — Thu, 01 May 2025 23:56:34 GMT

Yeah, as @Kurt_Bremser suggests, I think you might want to make this a two step process where you first pipe this command to the shell:

Get-WinSystemLocale

...read in the output, and make your determination based on that. You can try this in Powershell just to see the output.

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Ksharp — Fri, 02 May 2025 06:07:11 GMT

You could try option datastyle= and using informat anydtdte32. in input() function.

option datestyle=dmy;
.........
date=input(scan(buff,1,''),anydtdte32.);

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Tom — Fri, 02 May 2025 13:47:45 GMT

Sounds like a question for a Windows forum.

You could skip the PIPE and just use SAS code to get the filenames.

You might try this macro https://github.com/sasutils/macros/blob/master/dirtree.sas

It might not have your problem since it uses the NLDATM informat to read the lastmod timestamp.

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

djbateman — Fri, 02 May 2025 13:56:06 GMT

@Ksharp , I didn't have much luck with that method. You can see below that it properly got March 31, but I changed Feb 6 and May 2 to June 2 and Feb 5, respectively.

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

Tom — Fri, 02 May 2025 14:24:06 GMT

The DATESTYLE= option will control how the ANYDT... informats handle the ambiguous date strings.

Try it yourself.

data have;
  input name $ string :$10. ;
cards;
MDY 1/31/2025
DMY 31/1/2025
??? 2/6/2025
;

%let datestyle=%sysfunc(getoption(datestyle));
%put &=datestyle;

options datestyle=MDY;
data mdy;
  set have;
  mdy = input(string,anydtdte10.);
  format mdy date9.;
run;

options datestyle=DMY;
data dmy;
  set have;
  dmy = input(string,anydtdte10.);
  format dmy date9.;
run;

options datastyle=&datestyle;

data both;
  merge mdy dmy ;
run;

proc print;
run;

The trick is know which setting to use. That is a Windows question, not a SAS question.

Although if your SAS session is using a similar locale as your Windows system (or is it the Windows file system that controls how DIR formats its output?) then using DATESTYLE=LOCALE might help.

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

data_null__ — Fri, 02 May 2025 14:41:43 GMT

Maybe this would work for you

reg query "HKCU\Control Panel\International" /v sShortDate

HKEY_CURRENT_USER\Control Panel\International
    sShortDate    REG_SZ    M/d/yyyy

You can use INFILE statement option FILEVAR to execute multiple PIPEed commands.

Re: How to know if a date from a pipe command is ddmmyyyy or mmddyyyy

djbateman — Fri, 02 May 2025 15:46:58 GMT

I think I can work with this. Thank you for the direction!