Hi Everyone,    I am still a beginner in SAS, and I would like to know what books that you can recommend to me that are more focused on SAS use for economics and finance, as well as good data management strategies. So far I have read The Little SAS Book, SAS by Example, and Cody's Data Cleaning Using SAS.   Also for those who work with finance, what are other software that you consider important to learn for financial data analysis?      ... View more

I am trying to run a macro, but I am getting this message: "Array subscript out of range at line 12 column 31". What am I doing wrong? I am attaching the program, and the data to this post. I have already checked if the number of variables match my array and do definitions.    This is the part of the macro that I am having problems (please see files for the entire macro, and note that this section is inside of a macro).   array change {11} Adjusted_gross_income_category Number_of_returns Adjusted_gross_income Wages_Number_of_returns Wages_Amount UE_comp_number_of_returns UE_comp_amount SS_number_benefits_AGI SS_amount_benefits_AGI Taxable_inc_number_returns Taxable_amount ; %do i = 1 %to 11; %if change{i} = "**" %then change{i}=" "; %end; array numeric_change {10} Number_of_returns Adjusted_gross_income Wages_Number_of_returns Wages_Amount UE_comp_number_of_returns UE_comp_amount SS_number_benefits_AGI SS_amount_benefits_AGI Taxable_inc_number_returns Taxable_amount ; array new_numeric {10} Number_of_returns_2 Adjusted_gross_income_2 Wages_Number_of_returns_2 Wages_Amount_2 UE_comp_number_of_returns_2 UE_comp_amount_2 SS_number_benefits_AGI_2 SS_amount_benefits_AGI_2 Taxable_inc_number_returns_2 Taxable_amount_2 ; %do i = 1 %to 10; new_numeric{i}=input(numeric_change{i},comma12.); %end;     ... View more

I would like to know how I can create a dual axis bar chart with different categories using SAS commands. I am attaching an image that is an example of what I need to do. The example is very accurate, except that I do not need the line graph. Since I am using private data, I cannot upload the data set or my commands. I would truly appreciate any help.  ... View more

I am trying to import a CSV file that has a date variable. Some of the dates are in the yyyy-mm-dd format and others are in mm/dd/yyyy format. How can I import using infile without getting an error? ... View more