Jim,
Thanks for referring to Carpenter's paper.
I tried his program using SAS University Edition. The final lookup brought missing values for HEIGHT, WEIGHT, AGE for name = 'Barbara98765'
Anybody tried the program on SUE?
DATASP
Edited:
There are two versions of %callgetstats. The second version works perfectly in SUE.
DATASP
Interesting @KachiM. I haven't had a chance to play with the revised program yet (the trip home from the conference proved to be something of a lengthy pain-in-the-hindquarters). I have both 9.4 M5 (Univ. Ed.) and 9.4 M4 (UNIX) available to me, so it will be interesting to see if there is any difference. I know when Univ. Ed. was 9.4 M4 and I was running 9.4 M3 at work, things like DOSUBL responded in *wildly* divergent ways. I suspect that M4 and M5 are much closer on such things, but it will be interesting to see if your missing values are a Univ. Ed. issue or something along those lines.
Jim
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.