Add the dictionary table FONTS to surface as a table the registry information that is output via
proc registry export=regcheck
startat='CORE\PRINTING\FREETYPE\FONTS' ;
run ;
... View more
Hi. I recently asked a question about standardizing a proc genmod model to the total population distribution of a number of covariates (age, sex, status), regardless of variable distributions of these within each individual group.
In the course of @StatDave advising me how to query the coefficient weight by using the "e" option in an lsmeans statement to produce a "coef" output , I discovered that the weights I expected for the population when using the "om" option were not being produced by my model. They were weighting to something but I couldn't figure out what exactly.
After some proc freq testing, I realized the dataset I am using is a summarized data set, where each row has a variable representing the number of outcomes in those that meet that distribution of characteristics (numcount), and a variable representing those at risk for the outcome with those same characteristics (denomcount).
proc genmod data=imputed_data;
by _imputation_;
CLASS group (ref='A') age (ref='<25') status (ref='Jr') sex (ref='Male');
MODEL numcount = group age status sex /dist=poisson link=log offset=logdenomcount;
lsmeans group/ exp diff cl om e;
ods output ParameterEstimates=gm_fcs1 estimates=model_est lsmeans=allestimates diffs=relrisk;
run;
Since my poisson model had an offset for the denomcount (logdenomcount), I hadn't thought that weighting was necessary. However, when I looked at the "coef" output produced by e, I couldn't get the true population weights unless I added a weight=denomcount statement. Once added this produced the coefficient weight I would expect given the distribution of my sample (e.g., male =.8, female=.2, etc.).
I just want to confirm that this is appropriate (necessary) when data is summarized as described. Can someone please confirm?
This is my first time working with both imputed data and summarized data in this type of model so I appreciate your help!
(Below is a snippet of how the dataset is laid out: )
Obs
sex
age
status
group
_Imputation_
_TYPE_
_FREQ_
numcount
denomcount
num
denom
logdenomcount
1
Male
<25 years old
Jr
A
1
255
26
1
26
1
1
3.25810
2
Male
<25 years old
Jr
B
1
255
13
1
13
1
1
2.56495
3
Male
<25 years old
Jr
C
1
255
250
12
320
1
1
2.56495
... View more
Hi @XavierBizoux, yesterday I came across once again your fantastic quiz blog series. https://communities.sas.com/t5/SAS-Communities-Library/Data-Entry-in-SAS-Visual-Analytics-8-3-Part-3-Integrate-SAS-Viya/ta-p/582397
Back again in 2021 I could re-built this solution to my needs in my SAS Viya environment.
Now some years and releases later, meanwhile I'm working on Viya 4, the need arises to let the report user interact with the report, mainly giving him the functionality to add comments and save them to the underlying sashdat files.
Would you still recommend using the tools and techniques described in the quiz blog series?
... View more
Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.
The SAS Customer Recognition Awards celebrate the achievements and impact of our customers worldwide. Explore the entries and learn more about the 2025 award winners!