Not getting the table* I meant ... View more

I'm getting a full table or results I want. It may be me interpreting your directions. However, I can't seem to find a way to regress my above varible on three different conditions fused together. I would like to see state and year to be regressed on. I did make a difference column with a lag function and subtracting that from the row however, I haven't found a way it's useful. ... View more

Do you mean a snapshot of my data or just a random sample? Columns are Week, ProductID, Age, TotRev, Treatment, HasVideo, and group. I'm looking to find the difference of TotRev in the years labeled as 'After' in group, deducting those labeled as 'Before' in group categorized by Age.   I provided pictures of data below.   ... View more

So here's the code under the data: PROC SQL; CREATE TABLE WORK.query AS SELECT 'year'n , id , statefips , male , raceethnic , ed , marst , nchild , occ , ind , wkswork , age , income FROM _TEMP0.db1; RUN; QUIT; PROC DATASETS NOLIST NODETAILS; CONTENTS DATA=WORK.query OUT=WORK.details; RUN; PROC PRINT DATA=WORK.details; RUN; data work.details; set work.query (drop='year'n); run; Attached is what the data looks like  ... View more

It's just called income if interpretted your question right ... View more

Okay so this is what I have as of now: ods output ConfLimits=MeanVals ttests=PValue ; proc ttest data=work.details; Var raceethnic male; Class male; run; quit; data MergedResults; set work.details; merge MeanVals PValue; length Star $3; if probt=. then Star=""; else if Probt le 0.01 then Star="***"; else if probt le 0.05 then Star="**"; else if probt le 0.1 then Star="*"; else Star=""; format Mean dollar.2; MeanEdited=Cats(put(mean,dollar.2),Star); length ColumnName $30; if class="1" then ColumnName="Avg. AHE for Men"; else if class="2" then ColumnName="Avg. AHE for Women"; else ColumnName="Diff. in Avg. AHE"; run; proc print data=MergedResults; run; And heres' the prompt for the best context: "...should have one row for each race and columns should be the average income for men, average income for women, and the difference in average income. In the last column, in addition to the size of the difference in average income, you should include the result of a t-test (i.e., Proc TTest) that checks whether the difference in average income between men and women of any given race is statistically significant. Use the “star” system to report the result of your test." **Also to note race and gender are numerical categories if that changes anything ... View more

1.) So I'm trying to get the top/bottom 5 states in regards to how many observations are in each state and the percentage out of the whole in regards to observations as well. I.e. STATES OBSVERATIONS PERCENTAGES NY 2378 2% TX 45678 3.8% CA 100 .0008% Or something like that. (These aren't my actual numbers, I tried to make them as proportional as possible if that matters) 2.) When I used the code in the initial post, it gave me relationship data but it was in a way that didn't make it possible for me to download it to excel or use excel to find a relationship chart. I'm pretty certain it's the code I used. I'll attach the question I'm studying for: Use a graph of your choice (i.e., not a table) to display (and compare) the average income of individuals with different level of education. You may use Excel to create your graph once you extracted the necessary information from SAS. Include this graph in your write-up and discuss it. ... View more

More so like variables (frequency etc) overlapping so just one big chart overall ... View more