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

[dxiao2017]

(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;

[StaceySyphus · Accepted solution]

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

[dxiao2017]

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!

[StaceySyphus]

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

[dxiao2017]

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 😀😀