Why do you want to change a working process into a possible POS. If it works leave it alone.  Why make a sports car run like a VW. ... View more

As @RW9 wrote put noprints on procedures ... View more

this is one way I keep my log clear.   *-------------------------------------------------* * Clear Results Viewer *-------------------------------------------------*; ods html close; DM log "OUT;CLEAR;LOG;CLEAR;" log continue ; DM log 'next results; clear; cancel;' whostedit continue ; ods html newfile=none; ... View more

you might need to re-download and re-install.  Others have had an issue much like yours.  See if this link helps.   https://communities.sas.com/t5/SAS-Studio/The-connection-was-reset/m-p/428806#M4343   ... View more

does your condition have a table that it is coming from is it table a or table b? ... View more

replace the 5 with 300 if you have 300 columns and the 4 with your number of columns -1.  When new_var{I} = 1 then the dates being compared are 6 months apart.   data labs; input ID $ test_date1: mmddyy8. test_date2: mmddyy8. test_date3: mmddyy8. test_date4: mmddyy8. test_date5: mmddyy8.; datalines; 101 08192010 . . . . . 102 01192010 01192010 11272014 07262016 09272016 103 02192011 02192013 12272014 . . 104 01012010 04012010 07012010 01052013 . 105 01012010 07102010 07012010 01052011 . ; run; data want; array test_date(5); array tmonth(5); array new_var(5); set labs; do j = 1 to 4; do i = j+1 to 5; tmonth{i} = (test_date{i}-test_date{j})/182.5; if tmonth{i} >= 1 then do; new_var{i} = 1; end; if i = 5 and test_date{j} ne . then output; end; end; run;       ... View more

this link may assist you with your wants http://support.sas.com/documentation/cdl/en/etsug/66100/HTML/default/viewer.htm#etsug_tsdata_sect057.htm   you might want to place a do loop in the code to advance the lag date if you want to move the starting date value from date1 to date2... date299.   ... View more

you have posted the same question twice. ... View more

in you example you have ID 101 with only 1 date, but @lstockman wrote I could have 300 dates.  Will there be missing dates in the possible arrayed date-columns for an ID where date1 is not null but maybe date2-299 are null and then date300 has a date value? is the first found date1-300 in the array the start-date and the last date found the records to be evaluated?   Can you please provide a few more datalines representing what you may have coming in. Please post a sample of your wants related to the datalines you post. Thank you.   ... View more

here is another way but you get all SAS datasets so beware   libname myin "SAS/sas1/sas_sub1/all_datasets"; proc sql ; select trim(libname) || '.' || memname into :dataset_vars separated by ' ' from dictionary.tables where upcase(libname)="MYIN" and upcase(memname) like '%' ; quit; data myin.want; set &dataset_vars; run; ... View more

  %let mystr =AA BB CC;   data want;  set &mystr.; run;     ... View more

you might want to look at proc transpose here are two links to get you started   https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/   https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000063663.htm ... View more

are you sure that it is SAS and not SQL that is changing your char(7) or char(149) into this -> ... View more