About BrunoMueller

BrunoMueller · ‎12-12-2013

Hi Have a look at this blog entry Implement BY processing for your entire SAS program - The SAS Dummy by https://communities.sas.com/people/Chris%40SAS it provides excellent explanation on a programming pattern how to approach this. Bruno

BrunoMueller · ‎12-03-2013

Hi Kelly Have a look at this blog entry Implement BY processing for your entire SAS program - The SAS Dummy by https://communities.sas.com/people/Chris%40SAS it provides excellent explanation on how to approach this. Bruno

BrunoMueller · ‎11-07-2013

Hi Scott Have a look at the code below. As mentioned all the integrity constraints are copied, but not the audit information. options obs=0; proc datasets lib=work; append base=_class data=class; exchange class = _class; delete _class; run; quit; options obs=max;

BrunoMueller · ‎10-31-2013

Hi PGStats One can use arrays in a compute block. You can also change the sequence of across and analysis vars to make the headers look nicer See sample code below: data test; input grp across $ value @@; datalines; 1 a 1.1 1 b 1.3 1 c 1.2 2 a 2.1 2 b 2.3 2 c 2.2 3 a 3.1 3 b 3.2 3 c 3.3 ; proc report data=test nowd; column grp value, across _dummy; define grp / group; define across / "" across; define value / "" mean; define _dummy / computed /* noprint */; compute _dummy; * define array for across values; array _xacross{*} _c2_ _c3_ _c4_; acrossOffset = 1; maxRowValue = max(OF _xacross{*}); * for checking; _dummy = maxRowValue; * find the colum equal to max ; do i = 1 to dim(_xacross); if _xacross{i} = maxRowValue then do; call define(cats("_C", i + acrossOffset, "_"), "STYLE", "style={textdecoration=underline}"); end; end; endcomp; run; Bruno

BrunoMueller · ‎10-30-2013

Hi angorwat You might be able to use the TERMSTR option to get what you want. If your field 3 also contains the separator character (,) then the value for field 3 is usually in quotes. See also this discussion The following code will read a CSV file created in excel as outline by you data test; infile "c:\temp\csv_cr.csv" dsd dlm="," missover termstr=cr ; input emp_id : $8. dept_id : $8. free_text : $1024. Product_code : $8. country_code : $8. ; run;

BrunoMueller · ‎10-28-2013

You can use the query builder to achieve this. Brief steps: you have two tables that share a key which is used to identify the accounts start your query with the table (called A from now on) that contains the accounts you are interested in join the second table (called B from now on) in the query using a left join on the select tab, get the columns from table A your are interested in add the the key column from table B to the select tab now define a filter on the key column from table B, all rows where this value is missing are only present in table A but not in table B Have a go

BrunoMueller · ‎10-25-2013

Hi Iramesh What exactly do you want to achieve? If you write a macro you do have the source code for it. For compiled stored macros, you can use the %COPY statement if the developer did not use the SECURE option on the %MACRO statement Bruno

BrunoMueller · ‎09-27-2013

Hi Have a look at the following discussion SAS Enterprise Guide has a Rank Task to find in the Daata category

BrunoMueller · ‎09-19-2013

SAS allows you to build custom date formats using Proc FORMAT, see an example below. Have a look at the doc for the PICTURE statement in Proc FORMAT for more information on other directives possible in a picture format. data have; do month = 1 to 12; myDate = mdy(month, 1, year(today())); output; end; format myDate date9.; run; proc format; picture x_yyyy_mm (default=7) low - high = '%Y_%0m' (datatype=date) ; run; proc sql; select myDate , myDate as mydate2 format=yymmd. , myDate as mydate3 format=x_yyyy_mm. from have ; quit;

BrunoMueller · ‎09-18-2013

Proc REPORT can only work with one SAS Data Set, but you may use macro logic to run Proc REPORT several times with different SAS Data Sets

BrunoMueller · ‎09-18-2013

Hi Bruce123 One step to approach this is to use Proc TRANSPOSE to restructure your data, and then use some macro logic to build the Proc REPORT code, see sample below. data have; do group = "A", "B", "C"; do year = 2000 to 2013; toDate = mdy(1, 1, year); performance = ceil( rand("uniform") * 1000 ); output; end; end; format toDate date9.; run; %macro myReport(startYear=2009, endYear=2012); %local i; proc transpose data=have out=want prefix=performance_ ; where year between &startYear and &endYear; by group; id year; var performance; run; title "Performance from &startYear to &endYear"; proc report data=want nowindows; column group performance_&endYear %do i = &startYear %to (&endYear -1); performance_&i %end; ; define group / display; define performance_&endYear / display "Performance"; %do i = &startYear %to (&endYear -1); define performance_&i / display /* "Performance &i" */; %end; run; title; %mend; %myReport()

BrunoMueller · ‎08-29-2013

Have a look at the sample below data have_201201; infile cards ; input var1 $ var2 $ flag_1 $ ; cards; a d y b e y c f n ; data have_201202; infile cards ; input var1 $ var2 $ flag_2 $ ; cards; d a n e b y f c n ; data have_201203; infile cards ; input var1 $ var2 $ flag_3 $ ; cards; p a n q b y r c n ; %macro myloop; proc sql; drop table want; quit; %local tempTable; %do year = 2012 %to 2012; %do month = 1 %to 3; %let tempTable = have_&year%sysfunc(putn(&month, z2.)); Proc sql feedback; create table want_temp as select var1, var2, flag_&month as flag from &tempTable where flag_&month = 'y' ; quit; proc append base=want data=want_temp ; run; %end; %end; %mend; %myLoop

BrunoMueller · ‎08-29-2013

Hi suvi107 Did you find a solution for the task you had?

BrunoMueller · ‎08-29-2013

Hi You can use the COMPUTE BEFORE with a LINE statement to do something like this, see sample code below. For the grouping you need a new variable which is not shown in the report but needed to have "break lines". Proc Format; value $category "VAR" = "Other PT Variables" "AGEGR" = "Age Group" "RACE" = "Race" "REGION" = "Geographical Region" ; run; data have; input Variable $; category = put(upcase(compress(variable, "0123456789")), $category.); N1 = ranuni(0); N2 = ranuni(0); Group1 = put(ranuni(0),8.2); Group2 = put(ranuni(0),8.2); PVal= ranuni(0); cards; Var1 Var2 Var3 Var4 AgeGr1 AgeGr2 AgeGr3 Race1 Race2 Race3 Region1 Region2 Region3 Region4 ; run; proc report data=have; column category ('Predictor' Variable) ('Number of Patients' N1 N2) ('Mean/STD' Group1 Group2) ('p-value' PVal) ; define category / group order=data noprint; define Variable / display ''; define N1 / display center; define N2 / display center; define Group1 / display center; define Group2 / display center; define Pval / display center ''; compute before category / style={just=left background=bibg}; l = length(category); line category $varying254. l; endcomp; run;

BrunoMueller · ‎08-27-2013

Hi JohnT You can not copy a SAS Data Set within the same library. However you can use other statements from Proc DATASETS to achieve the same. Have a look at the code below. It will delete an existing CLS2 data set. It then uses the APPEND statement, if the base table is not found, then append will make a copy of the data table and preserve index etc. data cls (index = (name) label="Original CLS"); set sashelp.class; run; proc datasets library = work; delete cls2; run; append data=cls base=cls2; run; quit;

Online Status	Offline
Date Last Visited	3 weeks ago