Quiz
Modifying Daily Datasets
Your colleague is working with daily claims datasets for July. Each dataset contains variables for ClaimNumber and a Amount. However, Amount is stored as Character data when it should be stored as Numeric.
The data type for Amount needs to be changed, and all of the datasets need to be combined into a single dataset.
Your colleague wrote this code so far:
Data Claims_July_1 (drop=amount_char);
Set mydata.Claims_July_1 (rename=(Amount=Amount_Char));
Amount = Amount_Char + 0;
Run;
Data Claims_July_2 (drop=amount_char);
Set mydata.Claims_July_2 (rename=(Amount=Amount_Char));
Amount = Amount_Char + 0;
Run;
Your colleague obviously doesn’t know how to use macros! Develop a macro program that changes the Amount variable to Numeric, and combines all of the daily datasets into a single dataset called “Claims_July”.
1
1
1
/docProps/thumbnail.jpeg