Thank you for providing this! I have never used macros before as I have never earned this, but I tried following the detailed instructions and using google for a couple things. Where in my sas code should I place it? I received this error below. Also, I am unsure if you could help me with this, but I saw in my google search that some people use an .xlsx file for outdoc so I created a file and included the filepath and name in the outdoc statement. I am unsure if this was the right thing to do. 328 %tablen(data=IAT2018, by=D_biep_White_Good_all, - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 329 var=Age raceomb_002 birthSex edu politicalid_7 occupation_selfdetail_001, 330 type=1 2, pvals=5, 331 contdisplay=m sd, outdoc=\Users\tjoseph6\Documents\IAT2018.xlsx); 332 run; ... View more

Oh wow it worked!! I honestly was close to losing hope. I cannot thank you enough for your knowledge and patience with this!!! proc import out=work.IAT2016_raw datafile="C:\Users\tjoseph6\Documents\My SAS Files\IAT2016.sav" dbms=sav replace; run; data IAT2016; set work.IAT2016_raw (keep=year birthyear sex_5 raceomb D_biep_White_Good_all countrycit occupation_self politicalid_7); Age=year-birthyear; where left(countrycit)='1' & occupation_self in ('29-1000','31-1000') & sex_5 in (1,2); if D_biep_White_Good_all ne .; if politicalid_7 eq . then delete; if Age lt 16 then delete; if raceomb eq . then delete; label sex_5='Gender' raceomb='Race' D_biep_White_Good_all='Overall IAT D Score' politicalid_7='Political Ideology Spectrum' occupation_self='Occupation' countrycit='Country'; run; proc contents data=IAT2016; run; proc means data=IAT2016; class occupation_self; var D_biep_White_Good_all; output out = Summary mean = n = / autoname; run; ... View more

I know I already found the solution for my initial issue, but I do appreciate you pointing this out as well. Here is the link to the data: https://osf.io/dk8p4/, and the name is "Race.IAT.public.2020.sav". The codebook can also be found there as well. It is extremely large which is why I didn't include it initially. Also, this isn't all of my code as I am working with multiple variables, but this specific two-table was the only issue I was having so I condensed it and put it under a different data name to ask this question to avoid messing with my original data I'm working on if that makes sense. ... View more

Oh wow I messed up on that! I somehow misread the codebook for countrycit_num because it is numeric (i.e. 1= USA). The code you initially wrote worked with the correction. I cannot thank you enough!! ... View more