About gzr2mz39

gzr2mz39 · ‎08-05-2014

This works. Thank you.

gzr2mz39 · ‎08-05-2014

I have times that are character fields in the format x:xx PM/AM, for example, 1:30 PM and 10:30 AM. How can I convert these character fields into numeric fields that display 24-hour time? For example, change 1:00 PM to 13:00.

gzr2mz39 · ‎07-01-2014

Typically cupa_dt is greater than start_dt. However, when start_dt is greater than cupa_dt I need to switch around start_dt and cupa_dt to get the correct difference between the two dates. Is there any way to accomplish this without creating a flag (ie cc_check)? cupa_dt=dhms(TDT,0,0,TTM); start_dt=dhms(CSDAT,0,0,CSTIM); cc_check=0; if (start_dt>cupa_dt and cupa_dt ne .) then cc_check=1; if(cc_check=0) then do; cc_diff=round(((cupa_dt-start_dt)/86400),0.01); end; if(cc_check=1) then do; cc_diff=round(((start_dt-cupa_dt)/86400),0.01); end; Thank you.

gzr2mz39 · ‎06-12-2014

I'm trying to view a list of all dataset names in a library called SAPEng that begin with /BIC/ (the datasets were created in SAP). Any ideas? Thank you.

gzr2mz39 · ‎06-02-2014

Haikuo, does this SQL code ignore variables that don't begin with '/bic/ and end with 'n? I haven't been able to test it yet.

gzr2mz39 · ‎06-02-2014

My data is coming from SAP. It comes into SAS fine. However, I need to rename the variables after they come in as you stated above.

gzr2mz39 · ‎06-02-2014

I have multiple datasets with many variables that begin with '/bic/ and end with 'n. Does anyone know of a macro that will remove these characters from the beginning and end of variables with these specific characters? For example, '/bic/ZHRIMMNA'n should be ZHRIMMNA while variables without these characters would be left alone. Thank you.

gzr2mz39 · ‎05-21-2014

Thank you.

gzr2mz39 · ‎05-20-2014

Yes, I saw that. It doesn't seem to work for me. No space is added.

gzr2mz39 · ‎05-20-2014

Thank you for the protectspecialchars suggestion. However, I'm not sure what is the character(s) needed to create space(s) in Excel? Thank you.

gzr2mz39 · ‎05-20-2014

I'm using ods tagsets.excelxp to output my results. Are there any special characters I can add in front of "-Lost-Time" so that "-Lost-Time" appears indented (3-5 spaces is fine) when I output in Excel using proc report? proc format; value $oshaf "a_reg"="Reg" "b_lost"="-Lost-Time" "c_darb"="DARB" ; run;

gzr2mz39 · ‎05-15-2014

Hi PG, Do you know how resolve this error? ERROR: Closing delimiter "/" not found after regular expression "/^A?\d\/". ERROR: The regular expression passed to the function PRXMATCH contains a syntax error. Thank you.

gzr2mz39 · ‎05-15-2014

This seems to work for finding strings with numbers at the beginning. However, I'm not sure how to add in the requirement that string may also begin with the letter A. Does anyone know how to add this requirement to the regular expression below? fnd=prxmatch('/^\d\/',Test_Result_Number) So, I want to find 102, 9B101, A101, but I don't want Z10. Thank you.

gzr2mz39 · ‎05-13-2014

Does anyone have code or know a paper that describes creating box plots side-by-side when you just have the mean, median, 25th percentile, and 75th percentile for two or more variables? Thank you.

gzr2mz39 · ‎04-09-2014

An error is being generated in between the order by and outer union corr lines. I'm trying to sort dart_tot in descending order and then have 'Total' dart_tot appear on the last row. Does anyone know how to fix this? proc sql; CREATE TABLE loc_sum as SELECT loc_grp, sum(dart_new) as dart_tot FROM new_file1 where dart_new=1 group by loc_grp order by dart_tot desc outer union corr select 'Total' as loc_grp, sum(dart_new) as dart_tot from new_file1 ; QUIT; RUN; Thank you.

Online Status	Offline
Date Last Visited	‎08-23-2020 05:17 AM

Re: Combine PROC SQL code blocks that have different where statements

Combine PROC SQL code blocks that have different where statements

Re: prxparse with hyphens, numbers, and parenthesis

prxparse with hyphens, numbers, and parenthesis

extracting words from a text field based on their first 2 letters

proc sql from dictionary.columns where column names begin with "CDD_"?

Re: change the values of multiple variables with same prefix

change the values of multiple variables with same prefix

regular expression (prxparse) question

Re: reading records from a file into macro

Re: Combine PROC SQL code blocks that have different where statements

Re: Combine PROC SQL code blocks that have different where statements

Re: improving the efficiency of regex with a long list of patterns and...

Re: improving the efficiency of regex with a long list of patterns and...

Re: improving the efficiency of regex with a long list of patterns and...

forward slash (/)

proc sql from dictionary.columns where column names begin with "CDD_"?

VBScript error: could not locate automation class

Re: converting times from character to 24-hour

converting times from character to 24-hour

difference between dates

List all dataset names in a library

Re: macro for renaming many variables?

Re: macro for renaming many variables?

macro for renaming many variables?

Re: tagsets.excelxp: special characters to create indentation?

Re: tagsets.excelxp: special characters to create indentation?

Re: tagsets.excelxp: special characters to create indentation?

tagsets.excelxp: special characters to create indentation?

Re: regular expression for beginning of a string

regular expression for beginning of a string

side-by-side box plots

proc sql: order by and outer union corr