Have a nice weekend - looking forward to read about your experience on performance. /Gert ... View more

Hi @jmic_nyk   Have you tried to use proc copy ?   The data step and sql will perform 'twice' as much work, as they also put the data into the Program Data Vector.   Perhaps CLONE, BUFSIZE= or COMPRESS the data before Proc Copy.   /Gert ... View more

Hi Thomas   I guess that your customers are not defined in the SAS metadata server, so Row-level security is not an option, as they do not logon to the reports ? That's why you want to publish pdf versions instead of having the uses access the reports directly themself.   SAS Visual Analytcs is build for interactive reporting, and not so much for batch producing static pdf files.   I don't have a solution, but the resources below might contain some hints and tips, that may be helpful.   Have you had a look at calling the reports with parameters ? http://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p12ka7e26e9sz3n16utqdf2iz702.htm   And/or looking at Distributed scheduling of reports as PDF http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#n19vlwe5kw1e88n1dzpkxyq020i9.htm (will also contain link to the report - guess that is not what you want)   Your other challenges with the individual content in each report. You could make an new tabel containing the 2 columns - Filter-value and text. And show the content in ordinary tabel just containing the text column and then suppress the headings.   Perhaps in SAS for MS Office Add-in your can get "Selected Element > Convert to Snapshot" to work with VBA http://support.sas.com/resources/papers/proceedings16/SAS3500-2016.pdf (Will "break" the link between Excel and SAS)   More on VBA and SAS Add-in. http://support.sas.com/resources/papers/proceedings11/012-2011.pdf   And hidden at the very bottom - How about building the reports directly in SAS Add-in using the Add-in Tasks (no VA) and then designing your to-be-pdf report that way directly in Excel, Powerpoint or Word? ... View more

proc FREQ and proc MEANS are very good and proc UNIVARIATE can also be usefull providing different statistics in the same way. PROC UNIVARIATE DATA=sashelp.class; VAR _numeric_; OUTPUT OUT=WORK.output N=N NMISS=NMiss MEAN=Mean MIN=Min MAX=Max MEDIAN=Median STDMEAN=StdMean SUM=Total; RUN; ... View more

If you using Enterprise Guide (or Add-in for MS Office) try the Characterize Data Task.       Or you might find Explorer data useful.     ... View more

Hi all   One of the benefits with a community is that everyone can ask questions and/or comment on topics - In SAS there is always several ways to acheive the same goal, so here is 2 alternatives to do the same as Tor describes.   Finding info in sashelp.voptions (or dictonary.options) More info: Accessing SAS System Information by Using DICTIONARY Tables   Or click through to the same information in Enterprise Guide 7.1 ... View more

The quick solution is to sort your data by id and date AND add an index - try that and see how that performs. ... View more

Not sure if I get it correct, but I think your looking for a merge (or SQL join). Have a look at this sample. [pre] data Def_Total; input BatterID; datalines; 1 3 4 6 ; run; data PlayerIDs; input PlayerID Bats; datalines; 1 11 2 22 3 33 4 44 5 55 6 66 7 77 8 88 9 99 ; run; data Def_Total; merge Def_Total(in=in_Def_Total keep=BatterID) PlayerIDs(in=in_PlayerIDs keep=PlayerID Bats rename=(PlayerID=BatterID bats=BatterHand)); by BatterID; if in_PlayerIDs and in_Def_Total then output; run; [/pre] ... View more

Perhaps something like this ? [pre]data sample_input; input ID Date X; datalines; 1 10000 0 1 10000 1 1 10010 0 1 10119 1 1 10121 1 1 10125 0 1 10131 1 2 90000 0 2 90001 1 2 90150 1 ; run; proc sql; create table sample_output as select ID , date , x , (select sum(b.x) from sample_input b where a.id=b.id and b.date between a.date and a.date+120) as y from sample_input a ; quit; [/pre] ... View more

Must it be by using the do loop ? Or perhaps you can use the following data a; input id 8.; id2=put(id,z5.); cards; 1 01 001 ; run; ... View more

Consider adding an index on column "col_ins_id" on your 3 input tables. In your example you will always be reading first 3 tables + 1 table, another approach would in worst case only read through max 3 tables. If you first query the most likely table, then the other 2 tables might not be used that often. Or you could change the order, so the smallest table is first. Perhaps adding a KEEP statement, when reading would improve the performance (depending on your data) /* See which type of data it is - in which EDC table do i find it */ %macro getData; %let type=; data out_table; set RF300L3.edc_cd end=theend; where col_ins_id = "&sel_col_ins_id"; if theend then CALL SYMPUT('TYPE', 'EDC_CD - Format'); run; %if "&type" ne "" %then %do; data out_table; set RF300L3.edc_thick end=theend; where col_ins_id = "&sel_col_ins_id"; if theend then CALL SYMPUT('TYPE', 'THICK - Format'); run; %end; %else %if "&type" ne "" %then %do; data out_table; set RF300L3.edc_txrf end=theend; where col_ins_id = "&sel_col_ins_id"; if theend then CALL SYMPUT('TYPE', 'TXRF - Format'); run; %end; %else %do; data _null_; CALL SYMPUT('TYPE', 'General - Format'); run; %extract_edc_full(pInProcess WaferId User_id State Slot ROW_ID ProcessRecipe ProcessPlan PmProcedure MeasRecipe MeasKey MainTool LotId LimitsKey InspectionTool Facility DuploWaferId Datim CustomKey ChecklistActivityId CSIM_TIMESTAMP COL_INS_ID, out_table); %end; %mend; %getData; ... View more

Is your month a SAS date column or a value describing the month number ? My guess is that you should join by a SAS date column containing i.e. the last day of the month. This way your data will not be 30 timer higher. Make a new column containing the date of the last day in the month - instead of your currently column that contains the month number - you will get the month from your calender table. ... View more

Hi _null_ A big Tx to you 😉 I got it to work with $32767., if I use $256. I can't open the new copy (Excel reports that its damaged). I don't know why ? [pre] filename FT33F001 'D:\temp\test.xls' recfm=N; filename FT34F001 'D:\temp\testcopy.xls' recfm=N; data _null_; infile FT33F001 lrecl=32767; file FT34F001 lrecl=32767; input str $32767.; put str $32767.; run; [/pre] ... View more

Yes, Excel files are binary files. I will not read the Excel file to extract data With DATA _null_; You can read/write everything with infile/file and I was hoping thath RECFM=S and nbyte= could be used, in combination with put _infile_ $varying. len; like below.... I Have found these resources, but no breakthrough yet. Usage Note 6588: Serving binary files when running the IntrNet Application Server - http://support.sas.com/kb/6/588.html Problem Note 3404: The "_INFILE_" INPUT/PUT statement option is inconsistent with binary mode I/O - http://support.sas.com/kb/3/404.html Writing MS Office and other binary files - http://support.sas.com/forums/thread.jspa?threadID=5735 [pre] data _null_; length char $1; infile dav length=len lrecl=32767 nbyte=nbyt; nbyt = -1; input; file target lrecl=32767; do i = 1 to len; char = substr(_infile_,i,1); put char $char1. @@; end; run; [pre] ... View more