@christinagting0 Do you want/need this free text data for futher analysis or could you just skip it?   There are always ways to read such free text fields. What works will depend how your source data really looks like. Post an example if you're after actual code.   The easiest case is, if your free text field is at the very end of a record as then the code could be as simple as below. data test; infile datalines4 dlm=',' truncover; input (varA varB varC) ($) FreeText $200.; datalines4; aa,bb,cc,free text, can be anything, aa's,|[]OOP!@#$%^&*()_ ;;;; run; Above works because once VarC is mapped, the input pointer is at the position+1 of the comma after the data for VarC.   The format $200. then instructs SAS to just read the next 200 characters - as a Format and not an Informat gets used, the commas are no more treated as field delimiters.  TRUNCOVER in the infile statement ensures that SAS also maps data against FreeText if the remaining input string is shorter than 200 characters.   ... View more

It may help to show those actual Proc Contents results.   also if you want the result to LOOK like a date like 10/16/2016 instead of 27123 you need to assign a format:   format Discharge_doc mmddyy10.;   SAS does not automatically assign an informat just because you use a date informat in an input function unlike and INPUT statement with a format option. ... View more

The FIND() function with the 'i' switch for case insensitive search would eventually suffice.   You can certainly use a RegEx which matches all the strings - you just must know what the pattern is you're searching for. Can you provide some sample data with the different cases?     ... View more

I got it! just add n="you total title here"   this is the code I used:   proc print data=omrswork noobs n="site count="; where count_carf1 >0 and count_carf2=0 and count_carf3=0 and count_carf4=0 and dc_fiscal_year=3 and dc_fiscal_year^=99; var dc_fiscal_year count_nscx omrs_num_visits obs; sum count_nscx denominator; by site; format dc_fiscal_year fiscalyear. site site.; run; ... View more

Search your online documentation for SAS functions involving Date and time. There are many functions to extract and manipulate the data. And sometimes you don't need to "extract" at all. If you data is a date then you can display and use only the year value for most analyis by assigning a format   proc print data =yourdatasetname;    var orp_tx_start;    format orp_tx_start year4.; run;   will display the value as a 4 digit year.   Other formats can display week of the year, year and quarter, year and month, day of the week, calendar quarter, month. ... View more

In many SQL implementations, such as Oracle or MS SQL, the query would be invalid.  They require every item in select clause to either 1) be an aggregate function, such as max/min/mean or 2) be part of the group by clause. SAS doesn't follow this restriction. This means that if you have items not in your group by clause you may have unique records and then the summarized data from the group by clause is merged with requested data and you get your end result. I'm not sure why SAS explicitly warns you, possibly because of the difference between the SQL or so you know it's using two passes of the data anyways.    Its a Note, you don't need to do anything about it. If the results are what you want, to remove the note, you would need to manually calculate your stats per MRN in a summary table and then manually merge this with your original data.    ... View more