It worked. Thank you Sir. ... View more

Seems like you might want some "fuzzy matching", maybe. See https://blogs.sas.com/content/sgf/2021/09/21/fuzzy-matching/ ... View more

In order to get the best help with your question, I would post your data as a working data step and use full English sentences to explain the problem and desired output.  ... View more

Also could try MONYY. informat. data Want; Enrollment_month = 'FEB2022'; Enrollment_date = input(Enrollment_month, monyy9.); format Enrollment_date yymmddn8.; put _all_; run; ... View more

thanks for your help 1)any one of the Status value should be "completed" other two status values could be "cancelled" or blank 2)none of the 3 status variables should have "completed" 3)need out put data set    Thanks again ... View more

Hi:   ODS EXCEL has some options that set document properties, as shown below: Hope this helps, Cynthia ... View more

@cm3 wrote: Hi    I’ve data like below   accno.  Var1 var2 var3  111.       Y.     Y.     N 112.       Y.     Y.     Y 113.       N.    Y.      Y 114.       Y.     N      N 115.       Y.     Y.      Y 116.       Y.     Y.     Y 117.       Y.     Y.     N 118.       Y.     Y.     Y 119.       Y.     Y.     Y 120.      N.     Y.     Y   i need output as below by considering only Y values for Var1,... tot.   %var1.   %var2. %var3 10.     80.          90.       70     please advise. Thank you   Are the values "Y"  or "Y."  That is two different values. Similar with "N." and "N". So do you want percent of "Y" or "Y."?   I  you use 1/0 numeric coding instead of Y/N character coding (or read external data of Y/N into 1/0) this becomes a trivial exercise. The SUM of 1/0 codes values becomes the number of 1 (or Yes or Y or True or what have you responses) and the mean is a percentage. ... View more

Green     PDF is not intended for data interchange so reading is very problematic. And there you provide absolutely no context for "item number".   Could you at least attach an example of the PDF you are want to get this information from? ... View more

@cm3 wrote: Correction typo mistake below E031000. 4 2 5 E03. 303 303 312 E03100S. 1 1 4 E03. 309 300 304 Get your text, in a plain text editor like the SAS editor or Notepad. The paste into a code box using the forum's {I} to preserve the format. Otherwise the forum strips a lot of blanks, tabs and such. I am guessing that you intended something like: E031000. 4 2 5 E03. 303 303 312 E03100S. 1 1 4 E03. 309 300 304 which would indeed be a bad structure for an actual data set. If you are wanting a REPORT that is read by people and not data fed into other procedures then say so.     The reason this would be bad as a data set is that the value of the variable userformid is no longer available for grouping for any purpose on most records. So summarizations and such are likely to be off. ... View more

@cm3 wrote: sorry, did not work "Did not work" is awful vague. Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages. No output? Post any log in a code box. Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.   Since you did not provide any actual data other than a string that by face value is invalid in SAS, to have imbedded ' as you you use the definition would have to have " " around the entire value, I provided a guess. ... View more