May I know how do go from 'have' to 'want' using proc sql?
Thanks a lot.
studyid test abc110 1 abc110 2 abc110 3 abc201 1 abc201 2 abc405 1 abc405 2
studyid test n abc110 1 1 abc110 2 1 abc110 3 1 abc201 1 2 abc201 2 2 abc405 1 3 abc405 2 3
The task defines the tool, so you use the data step for this:
data want; set have; by studyid; if first.studyid then n + 1; run;
No need to code yourself to insanity when there's such a simple solution.
I try to use proc sql more for my work now.
Mastery of a tool also means knowing when not to use it.
SQL is very useful for a lot of things, but using it here, and in a production environment(!), would simply be stupid. The next one to maintain that code will come after you with murder in their eyes.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.