topic Should the new column be "EstSum", not "EstPct", Practice Q2, p237, SQL1:Essential PDF in Advanced Programming

Should the new column be "EstSum", not "EstPct", Practice Q2, p237, SQL1:Essential PDF

dxiao2017 — Tue, 18 Mar 2025 14:35:55 GMT

(SQL1: Essential course note PDF, p237 and p245 s104s10)

I think the newly created column name should be "EstSum", not "EstPct", because it is the sum of the estimated population of the countries, not a percent (see below).

The code and results are as follows:

proc sql;
select * from sq.globalfull(obs=1);
quit;
proc sql outobs=3;
select distinct countrycode,
       estyear1pop
   from sq.globalfull;
quit;
proc sql;
select sum(estyear1pop) format comma20.
   from (select distinct countrycode,
                estyear1pop
            from sq.globalfull);
quit;

Re: Should the new column be "EstSum", not "EstPct", Practice Q2, p237, SQL1:Ess

StaceySyphus — Tue, 25 Mar 2025 15:02:52 GMT

Thanks for the feedback. We'll get this fixed in our next revision.

Re: Should the new column be "EstSum", not "EstPct", Practice Q2, p237, SQL1:Ess

dxiao2017 — Tue, 25 Mar 2025 15:14:40 GMT

Hi Stacey! Thanks a lot for your attention and your reply! This is the second time I get feedback from you, I am really so happy about this. I learnt a lot from PG1 and PG2 and PG3, MACRO1 and SQL1 training materials, really good and helpful.

All the best!

Re: Should the new column be "EstSum", not "EstPct", Practice Q2, p237, SQL1:Ess

StaceySyphus — Tue, 25 Mar 2025 15:16:49 GMT

I'm so glad to hear the training has been helpful! Clearly you are paying attention to the details, which we appreciate. 🙂

Re: Should the new column be "EstSum", not "EstPct", Practice Q2, p237, SQL1:Ess

dxiao2017 — Tue, 25 Mar 2025 16:30:08 GMT

The materials (for learn SAS as well as the cert. exam preparation) I depend on, refer to, practice many times, and feel most helpful are 1) the "Base SAS 9.4 Procedures Guide" one can find through the SAS Help and Documentation in SAS 9.4 windowing environment and 2) the training materials including pg1, pg2, pg3, macro1, sql1 essentials. Learning these materials is fun and as a learner I really appreciate all this materials 😀😀