I am downloading some data from a European data page (Eurostat).  There is a date field with an unusual format and I cannot get SAS to understand it and then, to set it to standard US date format.  Here is the data: "23DEC15:13:47:00".  SAS thinks this is December 23, 2015 (plus the time - DATETIME19.), but it should be December 15, 2023.  Over two hours of reading threads and testing several "solutions" and no luck.  Help 🙂 ... View more

I have a working macro, that substitutes a code value on each iteration. The following example has three codes/iterations   %macro imp (code); various data tasks %mend imp; %imp(44123310) %imp(44123320) %imp(44123390) However, the reality is that I have hundreds of codes/iterations to run, which can be tedious (and lead to human error).  Instead of hardcoding each value and tailoring the number of iterations by hand, I'd like to automate it from a list of values for the code variable.  Perhaps the list of code values is in a spreadsheet.   I'd appreciate any tips.  SAS 9.4 M6 ... View more

After days of working out some code, I had the unfortunate luck of getting the Windows blue screen of death.  This happened before I could save the SAS file.  Unfortunately, there is no saved log file either.  I can see that the SAS temporary folder is still on the drive (E:\SAS Temporary Files\_TD2656_DESKTOP-575EP3T_).  Inside I see a macro catalog (sasmac2.sas7bcat) and inside that I can see the macro I need (Doit3).  If only I could open or view the contents, it would save me a day at least.  However, when I click on it I get a pop up box that says "No Default action for the macro data type".  Is there any way to see the contents?  If not, is there any other place that SAS or Windows may have saved a temporary file which may contain the code?   Thanks, Base SAS 9.4 in Windows ... View more

I work with a government agency's SAS program that ranks a series of choices.  Everything works great when there are differences.  However, I have observed that when sorting/ranking the choices, where two choices have identical values for all values, it nevertheless splits ties using some unknown mechanism that appears to go outside of the variables in the sort/rank by language.  It appears that the unknown mechanism is to look for differences in a variable that is defined by taking the absolute value of a difference and choosing the naturally positive value over the naturally negative value (i.e., the value before wiping away the sign).  For example, take a pair where the only difference is the LOTDIFF a variable which is defined as an absolute value of the difference between two values.  Even though the absolute values of the two choices are equal (in my case =1), if you remove the ABS from the variable calculation, the natural values of the two choices would be +1 and -1.  SAS consistently sorts/ranks the +1 observation over the -1 observation.  Does this ring a bell and is this mystery sorting mechanism  documented anywhere?     LOTDIFF = ABS(USLOT - HMLOT); PROC SORT DATA = P2PMODELS OUT = P2PMODELS; BY &USMANF &USPRIM USLOT &US_TIME_PERIOD &YEARMONTHU &USMON &USCONNUM NVMATCH &DIFCHAR LOTDIFF WNDORDER COSTDIFF; RUN; DATA P2PMODS P2PTOP5; SET P2PMODELS; BY &USMANF &USPRIM USLOT &US_TIME_PERIOD &YEARMONTHU &USMON &USCONNUM NVMATCH &DIFCHAR LOTDIFF WNDORDER COSTDIFF; IF FIRST.&USCONNUM THEN CHOICE = 0; CHOICE + 1; IF CHOICE = 1 THEN OUTPUT P2PMODS; IF CHOICE LE 5 THEN OUTPUT P2PTOP5; RUN;   ... View more

Is it possible to insert a macro variable into  CARDS lines.  For example, suppose I have a date variable (MO_YEAR) with a value of "08-2023' that I want to insert into the pdf file names to make the filename dynamic each month data W47XXFM; input file_name $ : 20.; cards; test.pdf test1.pdf test2.pdf ; run; such that when run, the file names in data W47XXFM resolve to: 08-2023 test.pdf 08-2023 test1.pdf 08-2023 test2.pdf Thanks ... View more

Each month I create roughly 200 Excel files, 100 files are the old school "XLS" Excel files, then those files are turned into new "XLSX" files. So there are two files with identical names, but with different extensions.  I want to delete all of the "XLS" files but not the "XLSX" files.   Each month the file names are different.   ... View more