@novinosrin How can I read in 2018 as a numeric date. I've tried: DATA import_file; INFILE "K:\DATA\academic.file18.txt" INPUT @ 10 year year4.;
... View more
On my txt file the data in position 1 is formatted as 20020408.(yyyymmdd) I want to import the academic_date in the same format (yyyymmdd) but as a date value in sas. How can I do this? DATA import_file; INFILE "K:\DATA\academic.file18.txt" INPUT @1 ACADEMIC_DATE $8.; RUN;
... View more
Thank you! I created an array and it worked. ARRAY TSA_RESULT {4} TSA_1-TSA_4; TSA_COUNT_A = COUNTC(CATS(OF TSA_1-TSA_4), 'A'); TSA_COUNT_T = COUNTC(CATS(OF TSA_1-TSA_4), 'T');
... View more
How do I count the number of times the value A or T appears for each record. I want to enter the count into either column TSA_Count_A or TSA_Count_T as applicable? ID TSA_1 TSA_2 TSA_3 TSA_4 TSA_COUNT_ A TSA_COUNT_T 123 A T A T 456 T T N A 789 T N A T
... View more
That worked to remove the NULL values and the 6 digit code string that is also in the column. I want to maintain the code string but just remove any instances of the word NULL in the same field. How can I do this? TSA_CODE_1 NULL 061002 071004 101002 NULL NULL
... View more
I have a dataset that has the word NULL as a value and I am trying to replace it with a blank space but it doesn't work with the below IF statement. How can I overwrite/replace the word NULL? IF TSA_CODE_1 = 'NULL' THEN TSA_CODE_1 = '';
... View more
