About data_null__

data_null__ · ‎09-18-2023

I can open a SAS program from the windows file explorer by right clicking and selecting open in EG I will get this, where the program in the process flow has the program name. I want to emulate this behavior in a VBS program. Something like Chris does here https://github.com/cjdinger/sas-eg-automation/blob/master/vbscript/BatchProject.vbs I can modify BatchProject.vbs example to copy a file and load it using code.text. strSASfile = ".....\example.sas" Const ForReading = 1 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile(strSASFile, ForReading) strContents = objFile.ReadAll objFile.Close But I need to associate the program path. I want the program (however it gets there) to have the name as it does when I open with right click. So that when I submit _SASPROGRAMFILE will have the program path name. %LET _SASPROGRAMFILE='<path-to-file>\example.sas'; I have very little experience with object oriented programing and I can't figure the syntax. I have this document Assembly: SASEGScripting (in SASEGScripting.dll) Version: 4.2.0.0 (4.2.0.0) but I don't know what I'm looking for. I'm new to EG other than the most basic Open with EG and hit RUN.

data_null__ · ‎09-12-2023

Please show example data.

data_null__ · ‎08-18-2023

You should have a WARNING that the format "benefit" is not preloadable. Look at the documentation lots of good infor there.

data_null__ · ‎08-17-2023

Why not use the same technique you use to create &DATETIME? 24 %let currdate = %sysfunc(datetime(),B8601DT19); 25 %put NOTE: &=currdate; NOTE: CURRDATE=20230817T074257

data_null__ · ‎08-11-2023

@Cristina_inet wrote: Hello everyone, we are generating some pdf reports, in them there are tables generated with proc report. We are asked if it is possible for the header columns to appear as follows: The cells above should appear blank. Right now we are displaying it as follows: The code: proc report data=VER STYLE(header)=[ backgroundcolor=#8DB4E2 ] style(header)={verticalalign=middle}; columns ('Tipo de vía' (TIPO_VIA_4F)) ("&anyo2."(muertos&anyo2.)) ("&anyo3."(muertos&anyo3.)) ('Diferencias'(FDIF_&anyo3._&anyo2. )); define TIPO_VIA_4F / order order=data '' STYLE(header)=[backgroundcolor=white] STYLE(column)=[Color=darkblue] display left; define muertos&anyo2. / order order=data 'Nº' display right; define muertos&anyo3. / order order=data 'Nº' display right; define FDIF_&anyo3._&anyo2. / order order=data "&anyo3.-&anyo2." display right; compute muertos&anyo2; if TIPO_VIA_4F = 'TOTAL' then call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp; compute TIPO_VIA_4F; if TIPO_VIA_4F = 'TOTAL' then call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp; compute muertos&anyo3; if TIPO_VIA_4F = 'TOTAL' then call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp; compute FDIF_&anyo3._&anyo2; if TIPO_VIA_4F = 'TOTAL' then call define (_col_,"style","STYLE=[fontweight=bold]"); Endcomp; run; Thank you very much for the help. Greetings. *remove header text from column statement; columns (TIPO_VIA_4F) ("&anyo2."(muertos&anyo2.)) ("&anyo3."(muertos&anyo3.)) ('Diferencias'(FDIF_&anyo3._&anyo2. )); *Add the text here; define TIPO_VIA_4F / order order=data 'Tipo de vía' STYLE(header)=[backgroundcolor=white] STYLE(column)=[Color=darkblue] display left;Th This is untested.

data_null__ · ‎08-09-2023

Make a simpler example with DATA. You are also using the wrong function to search for words use INDEXW or FINDW.

data_null__ · ‎08-04-2023

Better not to have the newline character in the first place. FLOW=<"cell-names", "DATA", "HEADERS", "ROWHEADERS", "TABLES", "TEXT" > specifies that a designated Worksheet area enables Wrap Text and disables newline character insertion. Excel wraps the text to the column width. cell-names enables Wrap Text for a single cell such as “A12” or a cell range such as “C1:E4”. DATA enables Wrap Text for table data cells. HEADERS enables Wrap Text in table column headers. Alias HEADER ROWHEADERS enables Wrap Text for table row headers. Alias ROWHEADER TABLES enables Wrap Text for all parts of a table: HEADER, ROWHEADER, and DATA. Alias TABLE TEXT makes ODS TEXT output work like titles, footnotes, PROC titles, and BY lines. The text is written into multiple merged cells and Wrap Text is enabled.

data_null__ · ‎08-03-2023

You can sort of reset SYSERRORTEXT. 101 data _null_; 102 set notfound; ERROR: File WORK.NOTFOUND.DATA does not exist. 103 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 104 %put NOTE: &=syserrortext; NOTE: SYSERRORTEXT=File WORK.NOTFOUND.DATA does not exist. 105 %put ERROR: %str( ); ERROR: 106 %put NOTE: &=syserrortext; NOTE: SYSERRORTEXT=

data_null__ · ‎07-28-2023

Seems like this issue is. offsetmin=0 offsetmax=0 Fiddle with those and see what happens.

data_null__ · ‎07-18-2023

ATRISK <(options)> <=number-list> displays the numbers of subjects at risk at the given times. You can specify the following options: ATRISKTICK ATRISKLABEL guarantees that tick values are shown on the time axis for those times when the numbers of subjects at risk are displayed. If this option is not specified, you might not be able to tell at exactly which times the number of subjects at risk are displayed. If the ATRISKTICKONLY option is also specified, it takes precedence over the ATRISKTICK option. ATRISKTICKONLY specifies that tick values on the time axis be shown only at the times that are given in the ATRISK= list. If the ATRISKTICK option is also specified, it is ignored; that is, ATRISKTICKONLY takes precedence over ATRISKTICK.

data_null__ · ‎07-12-2023

data ds_test; input k value @@; datalines; 1 100 1 . 1 . 2 . 2 200 2 . 3 . 3 . 4 150 4 . 4 200 5 . 5 . 5 150 5 . 5 200 ;;;; proc print; run; options msglevel=I; data want; update ds_test(obs=0) ds_test(in=in1); by k; merge ds_test(keep=k) ds_test(rename=(value=value0) where=(not missing(value0))); by k; if in1; value = coalesce(value,value0); output; drop value0; run; proc print; run;

data_null__ · ‎07-12-2023

define label / display "This is a header" style(column)={just=left cellwidth = 12.0 cm asis=on}; define sample / display "sample" style(column)={just=center cellwidth = 3 cm}; Try this. Remove the location qualifier (column) from your style overrides in the DEFINE statement. define label / display "This is a header" style={just=left cellwidth = 12.0 cm asis=on}; define sample / display "sample" style={just=center cellwidth = 3 cm};

data_null__ · ‎07-11-2023

The default type for numeric variables is ANALYSIS. You could have used NEW.SUM in the COMPUTE block.

data_null__ · ‎06-29-2023

Visual Analytics

data_null__ · ‎06-16-2023

Sounds like you need the FLOW option. FLOW=<"cell-names", "DATA", "HEADERS", "ROWHEADERS", "TABLES", "TEXT" > specifies that a designated Worksheet area enables Wrap Text and disables newline character insertion. Excel wraps the text to the column width. cell-names enables Wrap Text for a single cell such as “A12” or a cell range such as “C1:E4”. DATA enables Wrap Text for table data cells. HEADERS enables Wrap Text in table column headers. Alias HEADER ROWHEADERS enables Wrap Text for table row headers. Alias ROWHEADER TABLES enables Wrap Text for all parts of a table: HEADER, ROWHEADER, and DATA. Alias TABLE TEXT makes ODS TEXT output work like titles, footnotes, PROC titles, and BY lines. The text is written into multiple merged cells and Wrap Text is enabled.

Online Status	Online
Date Last Visited	58m ago