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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.