Question: Changing Variable Types Run the code below to create a table named bad: data bad; input date $10. zip; datalines; 2019/11/06 47906 2019/11/13 47907 I

 Changing Variable Types Run the code below to create a table

Changing Variable Types Run the code below to create a table named bad: data bad; input date $10. zip; datalines; 2019/11/06 47906 2019/11/13 47907 I Write a new DATA step (don't edit the one above) using bad as the input table to create a new table named better which has the same two columns (same names too) as bad, but with date saved as a numeric SAS date column and with zip saved as a character column. Write steps to display both the descriptor portion and the data portion of better. Show all your new code and a screenshot of both the last table from the descriptor portion and the data portion. Creating Custom Permanent Formats Write a PROC FORMAT step to create two new permanent formats in the pg2.hwformats catalog: o The HIGHREG format should format character values as follows: 0 1M => Intermountain 0 PW => Pacific West 0 SE => Southeast 0 other codes => All Other Regions 0 The PSIZE format should format numeric values as follows: 0 Less than 10,000 => Small 0 10,000 through less than 500,000 => Average 0 500,000 and more => Large Write a PROC FREQ step to create a two-way table comparing the columns Reg and Acres from pg2.np_summary. Apply the HIGHREG format to the Reg column and the PSIZE format to the Acres column. Chnlnf n\" Unlrr r-nrio and n cnroonchnf (1? H10 DDnF EDP\" nllrnnr

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!