You can delete rows this way. proc sql; delete from students where name='Krishna' and marks=65; quit; or proc sql; delete from students where name='Krishna'; quit; To specify multiple conditions, use And, Or, etc. to connect them. ... View more

The sheet name should be quoted as follows sheet="&year."; ... View more

Is it possible to specify one of those full paths and delete it with the following code? filename fname 'specify fullpath'; data _null_; rc=fdelete('fname'); put rc=; run; If rc is 0, then the file has been deleted. Could you try setting the return value of the filename function to "rc0" instead of "rc" and check if the filename function is being handled correctly? ... View more

Is the original data in hexadecimal? I think you can input it as a character type and then process it.   Would the following sample code be helpful? data sample; length n 8 c $8; n=12;c='12';output; n=255;c='0A';output; n=65535;c='FF';output; run; data _null_; set sample; bin_n=put(n,binary16.); bin_c=put(c,binary16.); hex_n=put(n,hex4.); hex_c=put(c,hex4.); dec_c=input(c,hex4.); put _all_; run; results: n= 12 c=12 bin_n=0000000000001100 bin_c=0011000100110010 hex_n=000C hex_c=3132 dec_c= 18 _ERROR_=0 _N_=1 n=255 c=0A bin_n=0000000011111111 bin_c=0011000001000001 hex_n=00FF hex_c=3041 dec_c= 10 _ERROR_=0 _N_=2 n=65535 c=FF bin_n=1111111111111111 bin_c=0100011001000110 hex_n=FFFF hex_c=4646 dec_c=255 _ERROR_=0 _N_=3 ... View more

I think it would be difficult to implement this in code unless the criteria for determining what is considered the same and what is considered a different diagnosis is clear. Therefore, I think it is necessary to take a step such as storing the replacement of w/ with/ in a temporary variable for matching. In my experience, I think it is best to repeat the following steps and gradually build up the conversion pattern for the data that does not match. For example, first exclude the matches without conversion. Next, eliminate the matches by converting "w/" to "with/" and "with /" to "with/", and memorize this conversion pattern. Next, eliminate matches by converting "&" to "and", and memorize this conversion pattern. Next... And so on. Then, when you have some replacement patterns, you may want to create a list of the ones that match the first X characters, while removing spaces from the remaining ones using compress or something. ... View more