By custom formats, do you mean the ones that are shown in the proc contents? I am not sure how to show that as I did not create them. Is there another way to show that to you apart from the proc contents? Sorry for not adding the log I missed that part of the message as I am working on the instructions again: 658 659 Proc freq data= work.IAT2016_raw; 660 tables countrycit*occupation_self*sex_5 / list missing; 661 format occupation_self sex_5; 662 run; NOTE: There were 1051105 observations read from the data set WORK.IAT2016_RAW. NOTE: PROCEDURE FREQ used (Total process time): real time 51.89 seconds cpu time 12.31 seconds The only question I think I can ask about the data2datastep is did I put it in the right place? I put it before my proc import statement. I don't really know what other specific questions to ask unfortunately because I don't really understand the code as a whole so I do apologize for my lack of knowledge with this. ... View more

I truly do appreciate your help, but I copied and pasted the exact proc freq that you posted and that was the result I received. If you think there is something I am doing wrong please let me know. Also, I previously stated to please let me know if I am doing the instructions wrong as well, and I posted the log statement of what I did to show you in hopes of you letting me know if it was in fact the incorrect way of doing it. I am by no means a SAS expert so I personally don't know exactly what the data2datastep does/did even after reading it in the instructions, but what I did is how I understood the instructions with my limited knowledge. I will try to provide the data a third time with the same instructions, but I apologize if I still do it wrong. ... View more

Does anyone have any idea as to why my WHERE and IF statements are causing it to show no observations? ... View more

I ran the proc frequency table that you provided, and these are the ones that fall under what I am looking for. I also printed the data up to 60 observations, and number 46 shows the observations that should fall under the WHERE and IF subsets I tried to run.  ... View more

I ran it with this change and it says there are no observations unfortunately: 612 proc import out=work.IAT2016_raw 613 datafile="C:\Users\tjoseph6\Documents\My SAS Files\IAT2016.sav" 614 dbms=sav replace; 615 run; NOTE: Variable Name Change. D_biep.White_Good_all -> D_biep_White_Good_all NOTE: Variable Name Change. D_biep.White_Good_36 -> D_biep_White_Good_36 NOTE: Variable Name Change. D_biep.White_Good_47 -> D_biep_White_Good_47 NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 1051105 observations and 534 variables. NOTE: WORK.IAT2016_RAW data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1:10.06 cpu time 27.01 seconds 616 data IAT2016; 617 set work.IAT2016_raw (keep=year birthyear sex_5 raceomb D_biep_White_Good_all countrycit 617! occupation_self politicalid_7); 618 Age=year-birthyear; 619 where countrycit eq 'US' & put( occupation_self,$OCCUPAA. ) in ('29-1000','31-1000') & sex_5 in 619! (1,2); 620 if D_biep_White_Good_all ne .; 621 if politicalid_7 eq . then delete; 622 if Age lt 16 then delete; 623 if raceomb eq . then delete; 624 label sex_5='Gender' 625 raceomb='Race' 626 D_biep_White_Good_all='Overall IAT D Score' 627 politicalid_7='Political Ideology Spectrum' 628 occupation_self='Occupation' 629 countrycit='Country'; 630 run; NOTE: There were 0 observations read from the data set WORK.IAT2016_RAW. WHERE (countrycit='US') and PUT(occupation_self, $OCCUPAA79.) in ('29-1000', '31-1000') and sex_5 in (1, 2); NOTE: The data set WORK.IAT2016 has 0 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 39.06 seconds cpu time 9.03 seconds 631 proc contents data=IAT2016; 632 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.03 seconds cpu time 0.04 seconds 633 proc means data=IAT2016; 634 class occupation_self; 635 var D_biep_White_Good_all; 636 output out = Summary 637 mean = 638 n = / autoname; 639 format occupation_self $OCCUPAA.; 640 run; NOTE: No observations in data set WORK.IAT2016. NOTE: The data set WORK.SUMMARY has 0 observations and 5 variables. NOTE: PROCEDURE MEANS used (Total process time): real time 0.08 seconds cpu time 0.04 seconds ... View more

  Here are the results from the frequency table! Maybe I didn't follow the steps correctly if it didn't show what you needed to see. I downloaded the data2datastep from that instruction page, and I ran it. Then, I ran my data with the variables you stated to show. I'll copy and paste what I did in a second!     Update: here is the log statement showing what I ran below 471 select memlabel ------ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 472 into :memlabel trimmed 473 from dictionary.tables 474 where libname="&lib" WARNING: Apparent symbolic reference LIB not resolved. 475 and memname="&dsn" WARNING: Apparent symbolic reference DSN not resolved. 476 ; WARNING: Apparent symbolic reference FMT not resolved. WARNING: Argument 2 to macro function %QSUBSTR is out of range. WARNING: Argument 3 to macro function %QSUBSTR is out of range. 477 %if %qsubstr(%superq(fmt),1,1)=Y %then %do; 478 select strip(catx(' ',Name,format)) 479 into :fmtlist separated by ' ' 480 from dictionary.columns 481 where libname="&lib" 482 and memname="&dsn" 483 and format is not null 484 and format not like '$%' 485 ; 486 %end; 487 %else %let fmtlist=; 488 quit; 489 490 %put _local_; 491 492 data _null_; 493 file "&file" dsd; WARNING: Apparent symbolic reference FILE not resolved. WARNING: Apparent symbolic reference FILE not resolved. 494 if _n_ =1 then do; 495 %if %superq(memlabel)= %then %do; ERROR: Nesting of %IF statements in open code is not supported. %IF ignored. ERROR: Skipping to next %END statement. 496 put "data &outlib..&dsn;"; WARNING: Apparent symbolic reference OUTLIB not resolved. WARNING: Apparent symbolic reference DSN not resolved. 497 %end; 498 %else %do; ERROR: The %ELSE statement is not valid in open code. WARNING: Apparent symbolic reference OUTLIB not resolved. WARNING: Apparent symbolic reference DSN not resolved. 499 put "data &outlib..&dsn(label=%tslit(%superq(memlabel)));"; WARNING: Apparent symbolic reference OUTLIB not resolved. WARNING: Apparent symbolic reference DSN not resolved. WARNING: Apparent symbolic reference MEMLABEL not resolved. WARNING: Apparent symbolic reference OUTLIB not resolved. WARNING: Apparent symbolic reference DSN not resolved. ERROR: The %END statement is not valid in open code. WARNING: Apparent symbolic reference INPUTLIST not resolved. 500 %end; 501 put @3 "infile datalines dsd truncover;"; 502 put @3 "input %superq(inputlist);"; 503 %if not (%superq(fmtlist)=) %then %do; 504 put @3 "format %superq(fmtlist);"; 505 %end; 506 %if not (%superq(lbllist)=) %then %do; WARNING: Apparent symbolic reference LBLLIST not resolved. 507 put @3 "label %superq(lbllist);"; 508 %end; 509 put "datalines4;"; 510 end; 511 set &lib..&dsn(obs=&obs) end=last; - 22 200 WARNING: Apparent symbolic reference LIB not resolved. WARNING: Apparent symbolic reference DSN not resolved. 511 set &lib..&dsn(obs=&obs) end=last; - 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, bitstring, INPUT, PUT. ERROR: Undeclared array referenced: dsn. WARNING: Apparent symbolic reference OBS not resolved. 511 set &lib..&dsn(obs=&obs) end=last; --- 22 ERROR 22-322: Syntax error, expecting one of the following: +, =. ERROR: Variable dsn has not been declared as an array. 512 put &varlist @; - 22 WARNING: Apparent symbolic reference VARLIST not resolved. ERROR 22-322: Expecting a name. 513 if last then do; 514 put; 515 put ';;;;'; 516 end; 517 else put; 518 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.14 seconds cpu time 0.11 seconds ERROR: No matching %MACRO statement for this %MEND statement. 519 %mend; 520 proc import out=work.IAT2016_raw 521 datafile="C:\Users\tjoseph6\Documents\My SAS Files\IAT2016.sav" 522 dbms=sav replace; 523 run; NOTE: Variable Name Change. D_biep.White_Good_all -> D_biep_White_Good_all NOTE: Variable Name Change. D_biep.White_Good_36 -> D_biep_White_Good_36 NOTE: Variable Name Change. D_biep.White_Good_47 -> D_biep_White_Good_47 NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 1051105 observations and 534 variables. NOTE: WORK.IAT2016_RAW data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1:14.25 cpu time 27.12 seconds 524 data IAT2016; 525 set work.IAT2016_raw (keep=year birthyear sex_5 raceomb D_biep_White_Good_all countrycit 525! occupation_self politicalid_7); 526 Age=year-birthyear; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 454843 at 526:9 NOTE: There were 1051105 observations read from the data set WORK.IAT2016_RAW. NOTE: The data set WORK.IAT2016 has 1051105 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 39.02 seconds cpu time 11.54 seconds 527 proc print data=IAT2016 (obs=20); 528 run; NOTE: There were 20 observations read from the data set WORK.IAT2016. NOTE: PROCEDURE PRINT used (Total process time): real time 0.07 seconds cpu time 0.03 seconds 529 proc import out=work.IAT2016_raw 530 datafile="C:\Users\tjoseph6\Documents\My SAS Files\IAT2016.sav" 531 dbms=sav replace; 532 run; NOTE: Variable Name Change. D_biep.White_Good_all -> D_biep_White_Good_all NOTE: Variable Name Change. D_biep.White_Good_36 -> D_biep_White_Good_36 NOTE: Variable Name Change. D_biep.White_Good_47 -> D_biep_White_Good_47 NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 1051105 observations and 534 variables. NOTE: WORK.IAT2016_RAW data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1:11.29 cpu time 27.11 seconds ... View more

It still says no observations. I am completely out of ideas. Please let me know if anyone has an idea or might have a clue about what is going wrong! Also, I can't compress the data further to upload here since the zip file is already at 157MB. ... View more

No not in the first 20, but I ran the frequency table that was written by @ballardw and I found the combinations in which the conditions of the WHERE (along with the IF) statement would be met. What I need are individuals that identify as Male and Female that are US Citizens (shows as 1 in the output), and are either Healthcare - Nursing and Home Health Assistants or Healthcare - Diagnosing and Treating Practitioners (MD, Dentist, etc.). I find this combination in the frequency table.   I'm going to try to run it with only the WHERE statements (so I will omit the IF statements) as I think that was the issue all along! ... View more

Thank you for your reply! I removed the quotes, and I produced the table as well. I see the combinations that I want in the table, so I guess the WHERE statement wasn't the issue like I thought. ... View more

Sorry for the delay! I had trouble with the steps. This is the output of the first 20 without the WHERE and IF statements.  I created the Age variable which is why the year and birthyear are added here as well. I posted the contents too just in case! Update: Also, I originally used raceomb_002 instead of raceomb in my original post by accident (both variables are in the dataset but there are no observations under raceomb_002). This did not change my output though when I changed it to the correct variable for Race.  ... View more

I apologize as I did not think of this, and the file downloads into a zip file but I still wasn't able to upload that because of the size. I'll try to see if compressing it myself will work somehow. I have looked at the original data multiple times. I also ran proc contents to look at the type as well. I even tried using other similar variables as well too but I still came up with the same result. The data that I tried to subset shows no observations so I can't really match it up to the original. Hopefully, I will be able to post the data somehow as I am at a complete loss. ... 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