There are a number of ways to control what gets uploaded using dataset options for example OBS= Data Set Option WHERE= Data Set Option  Although I'm not sure that's the question you are asking. I suspect that you only want to upload observations from the large dataset that match observations (student_id) in the smaller dataset. If that's the case then why not do a match-merge and upload the resulting dataset? ... View more

Untested, because you didn't post test data.  If you want the NOTES variable to have, say a pipe-delimited list of all the missing value notes that apply for a record, you could play with stuff like: if missing(student_id) then notes=catx("|",notes,"Student ID Missing") ; if missing(session_startdt) then notes=catx("|",notes,"Session Start Date Missing") ;   Or if you want more "human readable" it could be an AND-delimited list: if missing(student_id) then notes=catx(" and ",notes,"Student ID Missing"); if missing(session_startdt) then notes=catx(" and ",notes,"Session Start Date Missing"); If you've got a lot of these, you could use an array, and if the variables have labels you could use the label to generate the text for the note, rather than hard-coding it. ... View more

@Tom, Yes, I copied and pasted the code where I made a mistake (that you pointed out in your response). I was referring to the place where the problem lies in my code. The code you provided is the perfect solution😄. Thanks, ... View more

@Cynthia_sas , Thank you Cynthia.  It worked well. ... View more

Probably, which is why the NOT is much easier 😄 ... View more

Concur with @ballardw . Save to a text file, and read it with a DATA step where you have control. ... View more

It should be doing that already.  Did you run proc contents on the dataset?  What does it show as the variable name? What does it show as the label?   You can use a RENAME statement to change the name of a variable. You can use a LABEL statement to change the label attached to a variable.   You can fix it after the fact. proc contents data=have noprint out=contents; run; data fixes ; set have; where indexc(name||label,'0A0D'x); length newname $32 newlabel $256 ; newname = left(compbl(translate(name,' ','0A0D'x))); newlabel = left(compbl(translate(label,' ','0A0D'x))); run; proc sql noprint; select case when (upcase(name) ne upcase(newname)) then catx(' ',nliteral(name),nliteral(newname)) else ' ' end , catx('=',nliteral(newname),quote(trim(label),"'")) into :rename separated by ' ' , :label separated by ' ' from fixed ; quit; data want ; set have; rename &rename ; label &label; run; ... View more

Just want to second the recommendation of Ron Cody's book. It will teach you a ton about data cleaning, and also a ton about SAS programming in general. I think this book should be required reading for SAS programmers. ... View more

Try option BRIEF TRANSPOSE. proc compare base= grad brief transpose compare= postgrad out= comparison outnoequal outbase outcomp outdif; run; ... View more

@Reeza , I very much  appreciate your kind support.  You are an inspirational mentor  who can read between the words and provide very useful tips, hints & codes without being too demanding (to show the actual logs or programs, which often are company's proprietary data, and hence not to be shared publicly.) once the scenario is well explained.  Thanks, Babu  ... View more

Thanks, I have description length set as $ 100.Your code and shared by others above are okay and run fine on standalone basis. But the variable is part of a larger program that has to handle with various dirty data issues and is not helping in totality although everything else is cleaned up but this monster string is not cooperating at all. Thank you all though. ... View more

Thanks for pointing out. I had immediately rectified that but made difference. ... View more

Figure out what is actually in the variable since it is NOT the string you tried in the IF statement. Most likely there are some invisible characters in there.  Things to check for are things like  '09'x - Tab '0A'x - Line Feed '0D'x - Carrriage Return '00'x - Null 'FF'x - ?? 'A0'x - Non breaking space.   Do the strings have any non standard characters, like accented characters or strange graphical symbols?  Perhaps you just want to change all of the weird characters into spaces? comment = compbl(translate(comment,' ',compress(comment,collate(32,126)))); Use TRANSLATE to convert any character in the string that is not in the ASCII codes between a space and a tilde. Use COMPBL to convert multiple adjacent spaces into one space.   ... View more