@SASKiwi  - thanks for your reply - yes, using DATA step for this.  I actually haven't tried adjusting the INSERTBUFF at all - good idea - will try! ... View more

@SASKiwi Why would one use SAS/ACCESS Interface to Amazon Redshift if it relies on ODBC? Why not use SAS/ACCESS Interface to ODBC? Amazon provides  ODBC drivers for linux and Windows. ... View more

@RobertWF1 wrote: Great, that solved it! Thank you for the quick response.   I see the problem now -- there's no need to include biomarkerstatus with the count and pct_row variables under the year headers since the biomarkerstatus values are repeated in 2017 and 2018.  So better to move biomarkerstatus outside the parentheses in the column statement & include as a separate group variable. Also if one or more years have different values of biomarkerstatus, such as "not collected yet" or change in values collected the biomarkers will still align within biomarkername and show missing values for the other variables related to that biomarkerstatus value. ... View more

The OUTPCT option is what I'm looking for, thank you! ... View more

Just having some fun for posting a PROC SQL solution:   data test; input id $ x y; cards; a1 1 2 a1 1 4 a1 2 8 a1 2 16 b1 2 2 b1 2 4 b1 2 8 b1 3 16 b1 4 32 ; run; proc sql; create table want as select * from test group by id having x=min(x); quit; ... View more

Hi @kevin_stanford - I understand you are frustrated with the lags you are experiencing with EG 8.  Did you open a tech support track? If you do that, and provide tech support with logs for an EG session that shows the lag, I will be able to analyze the log to see if I can determine the cause of the delays.   It is best if a matching set of an EG log and the corresponding Workspace Server log are included.   After the track is opened, I will take a look at the logs.   Mark Allemang ... View more

Can you please post a solution to this question sif you found any? ... View more

I'm adjusting the text cursor color in Settings, but not changing in my SAS editor. ... View more

If you'd like the "point and click" ability to edit formats in a catalog, you are welcome to try out this tool (built by my team):  https://docs.datacontroller.io/formats/ It's free for up to 5 users, you can edit formats directly, upload from excel, download in various formats, run filters, and even configure jobs to run after a format is updated. ... View more

When you use a single name like that in the FMTSEARCH option list then means you want the FORMATS catalog in that libref.  So OUT is the name of the LIBREF that points to the location where the format catalog is stored.  If you do not see the LIBNAME statement that created the OUT libref then you can ask SAS to show you be using the LIST option of the LIBNAME statement. libname out list; The Physical Name= line will show you the name of the directory where to find the formats.sas7bcat file.   If you cannot find the source code then save the format definition out as a SAS dataset and then the format(s) will be more portable.      For example this code will create a dataset named FORMATS in the OUT libref that contains the information needed to recreate the catalog OUT.FORMATS. proc format library=out.formats cntlout=out.formats noprint; run; Later if you move to a different version of SAS you could re-create the format catalog by reversing the process: proc format library=out.formats cntlin=out.formats noprint; run; ... View more

Select the makes, then extract the sample:   proc sql; create table makes as select unique make from sashelp.cars; quit; proc surveyselect data=makes n=5 out=makes_5 seed=123; run; proc sql; create table cars_samp as select * from sashelp.cars where make in (select make from makes_5); drop table makes_5; quit; ... View more

Almost there - if I run the following proc report the header and subheaders are correct, but I'm seeing duplicate cylinder rows in the table: proc report data=chisq_freqpct; column cylinders origin,(count pct_row) N P_PCHI; define cylinders / display /*group*/; define origin / across; define count / display; define pct_row / display; define N / group; define P_PCHI / group; run; ... View more

Yes the following worked, thanks Reeza: proc tabulate data=test; class gender class; table gender,class*(n='N'*F=6.0 colpctn='%'*F=6.2); run; ... View more

I like this workaround.   I'll have to see if I end up with unmatched treatments, but my matching datasets have several thousand treatment records compared to several *million* controls so I suspect it'll be ok. ... View more