About Newtrix

Newtrix · ‎07-10-2025

Does anyone else experience a varying time lag when cutting code and pasting onto program editor? It doesn't occur when cut/pasting from other sources, including results viewer, but the lag can be anywhere from 0 to 30 or 45 seconds, sometimes causing the app to temporarily go into 'not responding' mode. It occurred at my last job using SAS as well, but doesn't in any other app. Wondering if this is a thing, and if so if there's a way to fix it. Thanks.

Newtrix · ‎07-03-2025

Thanks!

Newtrix · ‎07-03-2025

What is wrong with this code? PROC FORMAT; VALUE IncomeB 1 = 'Do Not Know' 2 = 'Less than $25,000' 3 = '$25,000 - $49,999' 4 = '$50,000 - $74,999' 5 = '$75,000 - $99,999' 6 = '$100,000 - $124,999' 7 = '$125,000 - $149,999' 8 = '$150,000 - $174,999' 9 = '$175,000 - $199,999' 10 = '$200,000 - $224,999' 11 = '$225,000 - $249,999' 12 = '$250,000 - $274,999' 13 = '$275,000 - $299,999' 14 = '$300,000 - $324,999' 15 = '$325,000 - $349,999' 16 = '$350,000 - $374,999' 17 = '$375,000 - $399,999' 18 = '$400,000 or More'; RUN; DATA All_Data_Total; SET All_Data_Total; FORMAT CHILD_INCOME_CD IncomeB.; LOG: 283 PROC FORMAT; 284 VALUE IncomeB 285 1 = 'Do Not Know' 286 2 = 'Less than $25,000' 287 3 = '$25,000 - $49,999' 288 4 = '$50,000 - $74,999' 289 5 = '$75,000 - $99,999' 290 6 = '$100,000 - $124,999' 291 7 = '$125,000 - $149,999' 292 8 = '$150,000 - $174,999' 293 9 = '$175,000 - $199,999' 294 10 = '$200,000 - $224,999' 295 11 = '$225,000 - $249,999' 296 12 = '$250,000 - $274,999' 297 13 = '$275,000 - $299,999' 298 14 = '$300,000 - $324,999' 299 15 = '$325,000 - $349,999' 300 16 = '$350,000 - $374,999' 301 17 = '$375,000 - $399,999' 302 18 = '$400,000 or More'; NOTE: Format INCOMEB is already on the library WORK.FORMATS. NOTE: Format INCOMEB has been output. 303 RUN; NOTE: PROCEDURE FORMAT used (Total process time): real time 0.04 seconds cpu time 0.00 seconds 304 DATA ADKINS.All_Data_Total; 305 SET ADKINS.All_Data_Total; 306 FORMAT CHILD_INCOME_CD IncomeB.; /* No '$' in format reference */ -------- 48 ERROR 48-59: The format $INCOMEB was not found or could not be loaded. 307 RUN; NOTE: The SAS System stopped processing this step because of errors.

Newtrix · ‎05-21-2025

I meant "spaces" just now, not characters.

Newtrix · ‎05-21-2025

Thanks for your time on this. I did try changing to numeric (see post just above) with the same result. There are no leading or trailing characters - 3 digits, that's all. This is the first time I've ever had such issues with a merge.

Newtrix · ‎05-21-2025

I have since created a numeric variable for each set with the identical info, INFORMAT 5. Sorted by the new variable, the merge still doesn't work. One gets stacked on the other.

Newtrix · ‎05-21-2025

The variables in each dataset are 3-digit numbers ranging from 201-208 but are classified as characters, formatted $30. There are no leading or trailing spaces, no carriage returns, etc. Both were uploaded from TXT files with no ENCODING commands in the uploading Macro.

Newtrix · ‎05-21-2025

The sort key is the same on both, and is formatted identically on both as a character with idential width. The merged dataset simply stacks one on top of the other. Code: PROC SORT DATA=AE.LOG_AE; BY Subject; RUN; PROC SORT DATA=AE.Treatment; BY Subject; RUN; DATA AEListings; MERGE AE.Log_AE AE.Treatment; BY Subject; RUN; Any and all help is welcome. Thanks.

Newtrix · ‎01-30-2025

Yeah, I was trying to clarify the code and missed a spot. SubjectNumber should be Patient. Each patient has multiple records, one per day. I'm trying to count the days during which each patient was given aspirin. The dataset looks something like what I have below. Thanks. Patient Date Medication 1 Jan 1 Aspirin 1 Jan 2 1 Jan 3 Aspirin 2 Jan 5 2 Jan 6 Aspirin 2 Jan 7 3 Jan 10 Aspirin 3 Jan 11 Aspirin 3 Jan 12

Newtrix · ‎01-30-2025

Hello, I'm trying to count total aspirin dosages per patient in a dataset for which each patient has one entry per day. Code is below. As you can probably gather, I'm getting counts of 1 in each "count' cell rather than an incremental total for each patient. Any help you might provide would be appreciated. Thanks. DATA Count; SET Medications; BY Patient; IF First.Patient THEN DO; IF Medication = 'Aspirin' THEN DO; Count = 0; Count + 1; IF LAST.SubjectNumber; END; END; RUN;

Newtrix · ‎01-06-2025

To begin with, I understand the basics of 1/1/1960 as the 'base' for all dates in SAS programming, so no need to elaborate on that. What I don't understand is what my code is doing to change the dates back to that date from what I'm trying to input. Any guidance you may provide is greatly apprecated. DATA study; SET chart; IF Sequence_No_ = 'A01-02' THEN DO; Best = 2; Best_Date = 09/11/2017; Prog_Date = 09/11/2017; END; ELSE IF Sequence_No_ = 'A01-03' THEN DO; Best = 2; Best_Date = 11/28/2017; Prog_Date = 11/28/2017; END; FORMAT Best_Date MMDDYY.10 Prog_Date MMDDYY10. RUN; What I get back is: Sequence_No Best_Date Prog_Date A01-02 01-01-1960 01-01-1960 A01-03 01-01-1960 01-01-1960 Again, I get the significance of 1-1-1960. All I need is the correct code so that I get the dates I want. Thanks!

Newtrix · ‎12-19-2024

I'm trying to subset a dataset into the greatest value of a single outcome within the multiple visits of each patient, so that each patient is listed once with his/her "best response": PROC SORT DATA=Rank; BY Patient Response; RUN; DATA Best_Response; SET Rank; BY Patient; IF FIRST.Patient = 1; RUN; As written, this code changes the value of "Best_Response" for every patient to the best value possible in the code. How do I fix? Thanks.

Newtrix · ‎11-03-2020

The PROC IMPORT was how I finally got the file to read as a table. Nothing else worked to get rid of the commas. I'm on to the next issue now. Remedial help (I am a novice) is appreciated. Thanks.

Newtrix · ‎11-02-2020

Thanks, that was helpful. Now 2 issues - 1) need to increase a variable length 2) need to extract "United States" WITHOUT including "United States Virgin Islands". Code so far, which did nothing for the length - still truncated at 11. Tried to get it as early in the DATA statement as SAS would accept it but no dice: FILENAME COVID1 url 'https://github.com/owid/covid-19-data/raw/master/public/data/bsg/COVID%20Government%20Response%20(OxBSG).csv'; PROC IMPORT DATAFILE=COVID1 DBMS=CSV OUT= COVID1; DATA COVID1; LENGTH Country $25; SET COVID1; RUN;

Newtrix · ‎11-02-2020

Oh - duh. Thanks.

Online Status	Offline
Date Last Visited	‎07-10-2025 09:00 PM

Copy/paste and cut/paste time lag

Re: PROC FORMAT

PROC FORMAT

Re: sas datasets won't merge after being sorted.

Re: sas datasets won't merge after being sorted.

Re: sas datasets won't merge after being sorted.

Re: sas datasets won't merge after being sorted.

sas datasets won't merge after being sorted.

Re: Using first. and last. statements to count a sub-variable

Using first. and last. statements to count a sub-variable

Re: Code is changing the values of a variable

Re: Code is changing the values of a variable

Re: Having trouble with INFORMAT

Copy/paste and cut/paste time lag

Re: PROC FORMAT

PROC FORMAT

Re: sas datasets won't merge after being sorted.

Re: sas datasets won't merge after being sorted.

Re: sas datasets won't merge after being sorted.

Re: sas datasets won't merge after being sorted.

sas datasets won't merge after being sorted.

Re: Using first. and last. statements to count a sub-variable

Using first. and last. statements to count a sub-variable

Code returns 1/1/1960 for input dates

Code is changing the values of a variable

Re: Can one upload github database directly onto SAS, or do I need to ...

Re: Can one upload github database directly onto SAS, or do I need to ...

Re: Can one upload github database directly onto SAS, or do I need to ...