Question about Level 2 Practice: Creating an Output Table with Custom Columns

easthill93 — Tue, 14 May 2019 02:57:06 GMT

Please help me with the Level 2 practice question in Week 5_Creating Summary Reports and Data.

I'm confused with the second question (continue with the first question).

Here are the instructions.

1. Write a PROC PRINT step to print the rainstats table.

2. Suppress the printing observation numbers, and display column labels.

3. Display the columns in the following order: Name, Year, RainDays, and TotalRain.

4. Label Name as Park Name, RainDays as Number of Days Raining, and TotalRain as Total Rain Amount(inches).

5. Use Rain Statistics by Year and Park as the report title.

6. Submit the program and review the results.

title "Rain Statistics by Year and Park";

proc print data=rainstats noobs label;
	keep Name Year RainDays TotalRain;
	label Name="Park Name" RainDays="Number of Days Raining" 
		TotalRain="Total Rain Amount(inches)";
run;

title;

title "Rain Statistics by Year and Park";

proc print data=rainstats noobs label;
	var Name Year RainDays TotalRain;
	label Name="Park Name" RainDays="Number of Days Raining" 
		TotalRain="Total Rain Amount(inches)";
run;

title;

I'm confused with the usage of keep and var statement.

According to SAS document, keep statement specifies the variables to include in output SAS data sets.

Can anyone explain the difference between keep and var statement?

Thank you very much.

Re: Question about Level 2 Practice: Creating an Output Table with Custom Columns

Tom — Tue, 14 May 2019 03:09:01 GMT

The PRINT procedure does not support the KEEP statement. That is really only used in a DATA step. Plus even if it DID work it would not have any impact on the order of the variables.

The PRINT procedure does support the VAR statement. You use it to list the variables that you want to print.

topic Re: Question about Level 2 Practice: Creating an Output Table with Custom Columns in SAS Programming

Question about Level 2 Practice: Creating an Output Table with Custom Columns

Re: Question about Level 2 Practice: Creating an Output Table with Custom Columns