Hi --    My stored procedures that return data to the _WEBOUT pane of the stored process web app are missing horizontal scroll bars when the report returns data that is too wide to fit in the existing pane. I've tried to use several browsers (chrome, firefox, IE) and still have the same issue across browsers. The vertical scroll bar automatically comes up and is not an issue.   I'm using the following options on the stored process URL:   https://zzzz.zzzzz.zzzzz/SASStoredProcess/do?_ACTION=properties&_ACTION=INDEX   Code for delivering my report to the user:   ods tagsets.tableeditor file=_WEBOUT options(frozen_headers="yes" data_type="String,String,String,String,String,String,String,String,String,String,String" sort="yes" sort_underline="yes"); options missing='0' label; proc print data=work.t3 noobs;run; title; footnote; ods tagsets.tableeditor close; Any ideas on what the issue might be?   Thanks! ... View more

Sorry for the poor subject line.    I'm reading in a data set that is very odd and has a lot of missing data. I'll try to illustrate below:   data have; input ID val comment $; datalines; 1 6 start . 12 adjust . 15 adjust . 6 final 2 12 start 2 15 final 3 6 start . 12 adjust 3 15 final ; data want; input ID val comment $; datalines; 1 6 start 1 6 final 2 12 start 2 15 final 3 6 start 3 15 final ; In order to get my "want" data set, I would normally sort by ID and use first/last processing to extract the records needed. However, in this case I don't always have a value in the ID field for the records that I want to capture. I'm not exactly sure if a retain or a lag statement would work in this case.   Any ideas on an approach? ... View more

Hi --   I'm trying to run a macro which will loop through each value of a date in a dataset. In the below example I have 6 dates that I want to pass through a loop. I want the macro to output 6 datasets with the SAS date value added to the end of the dataset name.    For example - the dates table looks like this: 21185 21216 21244 21275 21305 21336   I want output datasets called: test_21185 test_21216 ..etc   For some reason I cannot pass the date value to the dataset name highlighted in red text below. I do not want to use a call execute for this -- has to do with some compilation time/execution time nuances for my actual application.   /*Create a dataset with dates to be used for a loop*/ data work.t0; LOOK_AT_MTH="01JAN2018"d; do while (LOOK_AT_MTH<="01JUN2018"d); output; LOOK_AT_MTH=intnx('month', LOOK_AT_MTH, 1, 's'); end; run; /*put dates into a macro variable pipe delimited*/ proc sql noprint; select distinct LOOK_AT_MTH into :dates separated by '|' from work.t0; quit; /*macro to loop throgh each date value -- I want the output to be test_21185, test_21216, etc...*/ %macro runloop; %do i=1 %to %sysfunc(countw(%superq(dates),|)); %let dsname=%qscan(%superq(dates),&i,|); data test_&dsname.; date=%qscan(%superq(dates),&i,|); run; %end; %mend runloop; %runloop; ... View more