About Jerrya00

Jerrya00 · ‎06-06-2022

Two suggestions: 1. Try PROC FEDSQL. 2. Only keep the necessary variables in your SQL.

Jerrya00 · ‎06-22-2021

Please try this: proc sort data=your_data; by ID date; run; data results; set your_data; by ID date;; retain pre_Date .; if first.ID then do; n_month=.; pre_Date=date; end; else do; n_month=intck('month', pre_Date, date, 'C'); pre_Date=date; end; drop pre_Date; run;

Jerrya00 · ‎06-18-2021

Please try this: data test_1; set test; length word $32. Observation_1 $72.; delims = " =;,.()<>/'"; /* delimiters: space, comma, period, ... */ numWords = countw(Observation, delims); /* determining how many words in the text */ Observation_1=''; do i = 1 to numWords; /* split text into words */ word = scan(Observation, i, delims); if compress(word) in ('H1', 'H2', 'H3', 'N1', 'N2') then Observation_1=trim(Observation_1)||compress(word)||','; end; Observation_1=substr(compress(Observation_1), 1, length(compress(Observation_1))-1); keep user Observation Observation_1; run;

Jerrya00 · ‎04-13-2021

Please try this: proc sort data=have; by ID ID2; run; data have_1; set have; by ID ID1; retain Mark1First Mark1Last; retain first last; if first.ID1 then do; first=.; last=.; Mark1First=.; Mark1Last=.; end; if first=. and Mark1^=. then do; first=1; Mark1First=Mark1; end; if Mark1^=. then Mark1Last=Mark1; if last.ID1 then output; keep ID ID1 Mark1First Mark1Last; run;

Jerrya00 · ‎09-14-2020

Hello folks, Recently I used DDE to populate a formatted Excel table for 70 organizations. SAS generated an error massage and got stuck there. I have to use the Task Manager to end the SAS session. Is there anyone knows the root cause of the issue? I don't think any issue with the SAS program because it ran successfully for most organizations. Thanks very much ERROR: DDE session not ready. FATAL: Unrecoverable I/O error detected in the execution of the DATA step program. Aborted during the EXECUTION phase.

Jerrya00 · ‎11-06-2016

Recently I am learning to use Proc Mixed and found it's so confusing about selecting REPEAT or RANDOM. Sometimes they both produce the same results. Is there anyone to be able to help? Thank you.

Online Status	Offline
Date Last Visited	‎03-28-2023 07:26 PM

Re: SAS big data how to make the code faster

Re: Diference Date (MONTH) by ID

Re: How to obtain some words from a variable?

Re: How can I get the first and the last NON-MISSING value from a part...

DDE session not ready

REPEAT or RANDOM in Proc Mixed?