Howdy!   I am trying to use the PRESORTED option of PROC SORT to avoid multiple, very lengthy (~10 minutes) sorts.  However, I am finding that SAS sometimes does not accept that a sorted dataset is truly sorted when also using NoDupRec.   My dataset, labs, I have already sorted by all variables.  When I sort it with no options, SAS tells me it's already sorted.  When I add PRESORTED, it tells me it's already sorted.  But when I add PRESORTED and NoDupRec, it tells me the data is not sorted.  However, the meta data does show the data sorted (of course).  Does anyone know what's going on? 1125 proc sort data = labs; 1126 by _all_; 1127 run; NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1456.12k OS Memory 26644.00k Timestamp 03/26/2025 10:21:41 PM Step Count 50 Switch Count 0 1128 proc sort data = labs presorted; 1129 by _all_; 1130 run; NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 1456.12k OS Memory 26644.00k Timestamp 03/26/2025 10:21:41 PM Step Count 51 Switch Count 0 1131 proc sort data = labs presorted noDupRec; 1132 by _all_; 1133 run; NOTE: Input data set is not in sorted order. When I tried a super simple example, it works fine. 1143 proc sort data = sasHelp.class out = class; 1144 by _all_; 1145 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: SAS sort was used. NOTE: The data set WORK.CLASS has 19 observations and 5 variables. NOTE: Compressing data set WORK.CLASS increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 1213.43k OS Memory 26636.00k Timestamp 03/26/2025 10:23:46 PM Step Count 56 Switch Count 0 1146 proc sort data = class presorted; 1147 by _all_; 1148 run; NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 328.28k OS Memory 25860.00k Timestamp 03/26/2025 10:23:46 PM Step Count 57 Switch Count 0 1149 proc sort data = class presorted noDupRec; 1150 by _all_; 1151 run; NOTE: Sort order of input data set has been verified. NOTE: There were 19 observations read from the data set WORK.CLASS. NOTE: Input data set is already sorted, no sorting done. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 328.28k OS Memory 25860.00k Timestamp 03/26/2025 10:23:46 PM Step Count 58 Switch Count 0 Thanks, Michael   ... View more

proc freq data = sasHelp.class;     tables Sex*Age / list out = ___temp outCum; run; WARNING: The OUTCUM option is available only for one-way and LIST tables. Should this warning say WARNING: The OUTCUM option is available only for one-way tables. or have I misunderstood the list option?   The output dataset does not have the cumulative variables, although the ODS output does.  The same happens on colleagues' machines.   SAS 9.4 TS Level 1M6 X64_10PRO platform Windows Version 1.0.19041 ... View more

Hello!   IT just updated my Enterprise Guide, and this commandeered all my file type associations in Windows.  For example, if I double-click on class.sas7bdat from Windows Explorer, it opens in Enterprise Guide, and I want it to open in base SAS 9.4.   Windows 10 Enterprise Version 21H2 SAS for Windows SAS 9.4 TS Level 1M6 X64_10Pro platform   I tried right-clicking and selecting "Open with..." and then navigating to C:\Program Files\SASHome\SASFoundation\9.4 and selecting sas.exe.  This does not work.  SAS starts to open with the splash screen, but then it disappears and a log file is created in the folder with the dataset.  The log is attached and pasted below as well.  Also, the icon on the file no longer looks like a little database, but instead is the blue SAS shortcut icon.   In the past, when I've double-checked on a SAS dataset, it would open SAS first, if needed, then assign a library like TMP1, TMP2, TMP3, etc. for the Windows folder, and then open the dataset from that library.  I would like to get that functionality back.   Thanks!   Here's that log that was created, called class.sas7bdat.log (I had to append .txt to the attachment to get the website to upload it).   1 The SAS System 12:58 Tuesday, July 18, 2023 NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead. NOTE: All registry changes will be lost at the end of the session. WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M6) Licensed to MOUNT SINAI SCHOOL OF MEDICINE - SFA T&R, Site 70100937. NOTE: This session is executing on the X64_10PRO platform. NOTE: Analytical products: SAS/STAT 15.1 SAS/ETS 15.1 SAS/OR 15.1 SAS/IML 15.1 SAS/QC 15.1 NOTE: Additional host information: X64_10PRO WIN 10.0.19041 Workstation NOTE: SAS initialization used: real time 1.02 seconds cpu time 0.31 seconds WARNING: Truncated record. WARNING: A line of input contains one or more null (hexadecimal 00) characters, which might cause the SAS System to ignore part of the line. The line, with null characters printed as question marks, is: 1 Âê`³Ͻ’ Ç1Œ"" 33
2 
"" 33
23
#3  
SAS __ 180 1 ! FILECLASS DATA 1 ! Ñ"«^جÛAÑ"«^جÛA ”ÑÀ ”ÑÀ


9.0401M6X64_SR12R2 1 ! Ñ"«^lÄ;lÄ;lÄ; 1 ! 8Žp³ Ñ"«^جÛA 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 2 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 3 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 4 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 5 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 6 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 7 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 8 The SAS System 12:58 Tuesday, July 18, 2023 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! 1 ! ERROR 180-322: Statement is not valid or it is used out of proper order. 217: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 217-322: Invalid statement due to first character being unprintable (hexadecimal representation: 9D). 217: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 217-322: Invalid statement due to first character being unprintable (hexadecimal representation: 9D). 180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: Errors printed on pages 1,8. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 1.02 seconds cpu time 0.31 seconds   ... View more

Hello, everyone!   I have a model that incorporates race as (Whites vs other) and ethnicity as (Hispanic vs not).  The PI wants to look at non-Hispanic Whites vs all others as a contrast.  This is easily enough done by including the interaction in the model and writing: lSMestimate race2*hispanic2 'All Others vs. Non-Hispanic White' 1 -3 1 1 / divisor = 3; It turns out that this interaction is very not significant (Type 3 p = 0.70).  I realize that the interaction staying in the model while not significant is not likely to affect my results much.  But if I did want to remove the interaction from the model and rerun, could I still do the same comparison: non-Hispanic Whites vs all others?  I've written this code, and it's estimable, but my hunch is that theoretically, the model can no longer say anything about a combination of the two groups, even though I technically can form the estimates and compare their difference. *estimate 'Hispanic Non-White' intercept 1 race2 0 1 hispanic2 1 0; *estimate 'Non-Hispanic Non-White' intercept 1 race2 0 1 hispanic2 0 1; *estimate 'Hispanic White' intercept 1 race2 1 0 hispanic2 1 0; estimate 'Avg. of All Others' intercept 3 race2 1 2 hispanic2 2 1 (divisor = 3), 'Non-Hispanic White' intercept 1 race2 1 0 hispanic2 0 1, 'Avg. of All Others vs. Non-Hispanic White' race2 -2 2 hispanic2 2 -2 (divisor = 3); This does give an answer in the same ballpark as the model with the interaction, which might be expected since the interaction was not significant.   My reason for asking is because my real model has 8 racial groups and 3 ethnicity groups, and running the model with an interaction is not possible (quasi-complete separation in logistic).  I dichotomized race and ethnicity to get an answer to the study question, but I am just curious if I could have kept the full responses, omitted the interaction, and still answer the question.  The answer I get when I do that is very different from either of the dichotomized answers above.  I want to understand if that difference is likely because what I did is invalid or if keeping all the detail about the other racial and ethnic categories might really have changed the result a lot.   Warm regards, Michael     ... View more

Howdy!   Could someone explain to me why the first datastep can read the date correctly with no length specified on the format (yymmdd.), but the second datastep using input() function cannot?  And why the behavior changes for mmddyy. but only if there are no leading zeros?   data _____1; informat x yymmdd.; input x; format x e8601Da.; cards; 2001-05-05 2001/5/5 ; run; data _____2; input x $ 10.; y = input(x, yymmdd.); z = input(x, yymmdd10.); format y z e8601Da.; cards; 2001-05-05 2001/5/5 ; run; proc print data = _____1; run; proc print data = _____2; run; data _____1; informat x mmddyy.; input x; format x e8601Da.; cards; 05/05/2001 5/5/2001 ; run; data _____2; input x $ 10.; y = input(x, mmddyy.); z = input(x, mmddyy10.); format y z e8601Da.; cards; 05/05/2001 5/5/2001 ; run; proc print data = _____1; run; proc print data = _____2; run; Output Obs x 1 2001-05-05 2 2001-05-05  Obs x y z 1 2001-05-05 . 2001-05-05 2 2001/5/5 . 2001-05-05  Obs x 1 2001-05-05 2 2001-05-05  Obs x y z 1 05/05/2001 . 2001-05-05 2 5/5/2001 2020-05-05 2001-05-05 Warm regards, Michael ... View more