Hi, Thank you Cynthia for your help and clearing my doubt. Regards Aakarshan ... View more

Hi Cynthia,    I have provided the further details for the clarification.But my question is not with the coding as I wrote the code right and got the result as mentioned in the solutions only. However my question is that How we will find the invalid values. Like in the result we got three invalid values, So, my question is how are they invalid. Thanks  Aakarshan ... View more

Level 2 Practice: Using Procedures to Validate Data The pg1.np_summary table contains information about US national parks, monuments, preserves, rivers, and seashores. Valid values and descriptions for the columns Reg and Type are as follows: Reg Description Type Description A Alaska NM National Monument IM Intermountain NP National Park MW Midwest NS National Seashore NC National Capital PRE National Preserve NE Northeast RVR National River PW Pacific West     SE Southeast     Reminder: If you restarted your SAS session,you must recreate the PG1 library so you can access your practice files. In SAS Studio, open and submit the libname.sas program in the EPG194 folder. In Enterprise Guide, run the Autoexec process flow. Create a new program.  Write a PROC FREQ step to produce frequency tables for the Reg and Type columns in the pg1.np_summary table. Submit the step and look for invalid values. What invalid values exist for Reg? What invalid values exist for Type? Write a PROC UNIVARIATE step to generate statistics for the Acres column in the pg1.np_summary table. Submit the step.  What are the observation numbers for the smallest park and the largest park? View the pg1.np_summary table to identify the name and size of the smallest and largest parks.   In the above highlighted and underlined point 2 and point 3. I need an explanation on that. Coding is understood but Need an explanation as why and how "NPRE, PRESERVE, and RIVERWAYS are invalid values for Type." I hope I have made myself clear for the community people to understand my query now. Also attaching the codes used /*NPRE, PRESERVE, and RIVERWAYS are invalid values for Type. and No invalid values exist for Reg.*/ proc freq data= pg1.np_summary; tables reg type ; run; /*Smallest: Observation 78 Largest: Observation 6*/ proc univariate data= pg1.np_summary; var Acres ; run; /*Smallest: African Burial Ground Monument, .35 acres Largest: Noatak National Preserve, 6,587,071.39 acres*/ proc print data=pg1.np_summary; run;   Thanks for your detailed information with the steps. Aakarshan ... View more

Sorry for the assumption , will post the new and detailed question. Thanks for your response. ... View more