About Anthony_eng

Anthony_eng · ‎03-23-2022

I tried using concatValue = cats(column1, ' ', column2); and it wasn't creating spaces between the concatenated values. I also tried to use an IF-THEN-DO statement to retain the value, set the concatValue to blank space (= ' ') when needed, but I did it all in the IFTHEN statement. I am guessing that was causing the issue. I tried multiple iterations/changes and failed over and over. Thanks for the help.

Anthony_eng · ‎03-23-2022

Hello, I am trying to concatenate values from the same column in sas. I have tried multiple versions of the cat function and am not able to get this to work properly. There are blanks that I would like to use to cause the concatenation column to delete its previous values and start again with the current value. I have an example below. The Conc Column is my desired goal. Any and all help would be greatly appreciated. Thank you. Column 1 Column2 Conc Column a x1 x1 b x2 x1 x2 c x3 x1 x2 x3 d e x5 x5 f x6 x5 x6

Anthony_eng · ‎03-21-2022

Good Morning Patrick, Thank you so much for your help! Your code is wonderful, I had hit a wall trying to figure out how to compile this last group of data. Thank you again, I truly appreciate it.

Anthony_eng · ‎03-18-2022

Good Afternoon, I am trying to pull specific information based on a pattern shown below. The code is shown below. I have tested my regular expressions in other environments and they worked without issue. I believe the issue has something to do with my lack of understanding in SAS. My idea was to pull the required information from the end of each line (that is the reason I am using an end of line marker in RegEx) for each applicable observation and then concatenate as needed. However, when I tried to use that method outside of my loops it would always pull the first observation and then continue adding data onto the end of the string. When I used this RegEx inside the loops it pulled the very last piece of data that I wanted, but it wouldn't pull earlier iterations (In the example data I posted at the bottom of this message it would pull the 2nd highlighted portion of line 3, but nothing from line 2). data test; length text $32767; retain text ''; infile msghtml flowover dlmstr='//' end=last; input; text=cats(text,'~',_infile_); patternID1 = prxparse("/,Trans,.*?,Trans,/s"); patternID2 = prxparse('/^(~)([0-9]*\.[0-9]+),(Trans),(\w+),(\w+)/'); patternID3 = prxparse('/(?<=\d{2}\.\d{4},Rec,DATATYPE,(\w){8}\s(\w){2})(\s\w\w)+\s+$/'); if prxmatch(patternID1, text) then do; text = substr(text,1,length(text)-length(_infile_)-1); /* Tried placing RegEx here with end of line anchors, did not give desired result */ if prxmatch(patternID2, text) then do; Match_2=prxmatch(patternID2, text); Match_3=prxmatch(patternID3, text); Buffer_Msg_Trans = prxposn(patternID2, 0, text); Buffer_Msg_Trans1 = prxposn(patternID2, 2, text); Buffer_Msg_Trans2 = prxposn(patternID2, 3, text); Buffer_Msg_Trans3 = prxposn(patternID2, 4, text); Buffer_Msg_Trans4 = prxposn(patternID2, 5, text); Buffer_Msg_3 = prxposn(patternID3, 0, text); end; text=cats('~',_infile_); end; /* Tried placing code here with end of line anchors, did not give desired results */ run; I would like the following string to be the end result: 37 46 01 80 11 00 01 02 7A 00 4F FF OR 1) 37 46 01 80 11 00 2) 01 02 7A 00 4F FF (So then I can easily concatenate afterwards) String that is currently in my 'text' column (bold portions contain the data that I want to keep: 1) ~68.1626,Trans,DATATYPE,0601 2) ~68.1626,Trans,DATATYPE,0601~68.1809,Rec,DATATYPE,29EEF98A 10 37 46 01 80 11 00 6A 3) ~68.1626,Trans,DATATYPE,0601~68.1809,Rec,DATATYPE,29EEF98A 10 37 46 01 80 11 00 6A~68.1855,Rec,DATATYPE,29EEF98A 27 01 02 7A 00 4F FF FF 4) ~69.2385,Trans,DATATYPE,0602 Any help or advice would be greatly appreciated. Thank you for your time.

Anthony_eng · ‎02-28-2022

Hi Reeza, Thank you for the reply. I have attached a picture of the plots with circles indicating the points that I am trying to anchor/join. I would like to shift the data to the data plotted on the far right, but am open to any method that allows me to anchor/join the data at the requested points. Want the circled areas to be shifted horizontally so that each data group 'rises' at the same point on the x-axis. My data follows: EXPERIMENTKEY Translated TIMESTAMP TransitionLowToHigh 72040654 788 330 N 72040654 793 677 N 72040654 795 1015 N 72040654 796 1380 N 72040654 795 1765 N 72040654 808 8168 N 72040654 802 14608 N 72040654 801 21049 N 72040654 802 21408 N 72040654 803 21763 N 72040654 809 22115 N 72040654 804 22468 N 72040654 805 22822 N 72040654 804 23181 N 72040654 826 23536 N 72040654 989 23886 Y 72040654 1212 24238 Y 72040654 1372 24588 Y 72040654 1457 24943 N 72040654 1498 25318 N 72040654 1516 25715 N 72040654 1523 26079 N 72040654 1709 32480 Y 72040654 1682 38861 N 72040802 669 338 N 72040802 670 696 N 72040802 675 1073 N 72040802 674 1433 N 72040802 664 1788 N 72040802 692 49776 N 72040802 689 50135 N 72040802 700 50500 N 72040802 698 50850 N 72040802 692 51215 N 72040802 691 51573 N 72040802 688 51930 N 72040802 693 52292 N 72040802 686 52655 N 72040802 688 53013 N 72040802 679 53386 N 72040802 676 53748 N 72040802 668 54094 N 72040802 686 54469 N 72040802 684 54826 N 72040802 678 55202 N 72040802 683 55552 N 72040802 686 55904 N 72040802 694 56257 N 72040802 684 56609 N 72040802 687 56955 N 72040802 708 57342 N 72040802 1292 57707 Y 72040802 2600 58082 Y 72040802 3292 58453 Y 72040802 2830 58833 N 72040802 2220 59209 N 72040802 1644 59588 N 72040802 1833 59949 Y 72040802 2010 60323 Y 72040802 2151 60673 Y 72040802 2193 67135 N 72040802 2272 73605 N 72041266 697 338 N 72041266 706 702 N 72041266 704 1100 N 72041266 701 1506 N 72041266 696 1875 N 72041266 701 8320 N 72041266 703 14740 N 72041266 2039 21201 Y 72041266 2044 21602 N 72041266 2046 21961 N 72041266 2066 22325 N 72041266 2088 22693 N 72041266 2129 29113 N 72041266 2119 35532 N 72041296 809 805 N 72041296 807 1719 N 72041296 815 2613 N 72041296 826 3468 N 72041296 828 4347 N 72041296 805 5971 N 72041296 831 7608 N 72041296 823 9259 N 72041296 821 10954 N 72041296 823 12587 N 72041296 806 14268 N 72041296 847 15922 N 72041296 800 17572 N 72041296 817 19207 N 72041296 838 20852 N 72041296 796 21710 N 72041296 808 22550 N 72041296 831 23393 N 72041296 813 24356 N 72041296 833 25257 N 72041296 836 26071 N 72041296 829 26910 N 72041296 826 27769 N 72041296 813 28644 N 72041296 839 29464 N 72041296 834 30306 N 72041296 825 31155 N 72041296 820 31996 N 72041296 844 32840 N 72041296 840 33684 N 72041296 815 34560 N 72041296 811 35378 N 72041296 811 36219 N 72041296 821 37077 N 72041296 810 37948 N 72041296 835 38764 N 72041296 831 39604 N 72041296 811 40450 N 72041296 842 41296 N 72041296 830 42140 N 72041296 825 42985 N 72041296 847 43844 N 72041296 816 44667 N 72041296 807 45505 N 72041296 835 46342 N 72041296 809 47162 N 72041296 831 48000 N 72041296 827 48842 N 72041296 836 49685 N 72041296 822 50556 N 72041296 817 51457 N 72041296 821 52332 N 72041296 847 53175 N 72041296 813 54021 N 72041296 829 54899 N 72041296 807 55768 N 72041296 837 56582 N 72041296 809 57424 N 72041296 848 58281 N 72041296 828 59157 N 72041296 818 59987 N 72041296 841 60851 N 72041296 821 61706 N 72041296 819 62565 N 72041296 784 63429 N 72041296 837 64289 N 72041296 840 65107 N 72041296 789 65942 N 72041296 803 66804 N 72041296 814 67641 N 72041296 853 68487 N 72041296 833 69336 N 72041296 814 70162 N 72041296 806 70989 N 72041296 838 71859 N 72041296 817 72723 N 72041296 830 73537 N 72041296 827 74378 N 72041296 844 75252 N 72041296 838 76127 N 72041296 821 76940 N 72041296 800 77779 N 72041296 822 78637 N 72041296 836 79557 N 72041296 807 80377 N 72041296 854 81214 N 72041296 788 82055 N 72041296 812 82864 N 72041296 827 83701 N 72041296 815 84567 N 72041296 838 85404 N 72041296 821 86249 N 72041296 824 87092 N 72041296 828 87966 N 72041296 821 88783 N 72041296 830 89627 N 72041296 852 90455 N 72041296 827 91280 N 72041296 796 92145 N 72041296 828 93003 N 72041296 810 93862 N 72041296 817 94739 N 72041296 829 95556 N 72041296 819 96412 N 72041296 803 97249 N 72041296 812 98093 N 72041296 821 98904 N 72041296 810 99749 N 72041296 796 100616 N 72041296 831 101437 N 72041296 810 102274 N 72041296 818 103121 N 72041296 837 103978 N 72041296 823 104802 N 72041296 848 105646 N 72041296 827 106539 N 72041296 1597 107432 Y 72041296 2145 108274 Y 72041296 1426 109117 N 72041296 2140 109934 Y 72041296 2523 110780 Y 72041296 2313 112418 N 72041296 2367 114055 N 72041296 2385 115717 N 72041296 2406 117369 N 72041296 2427 119005 N 72041296 2367 120654 N 72041296 2310 122354 N 72041296 2291 124047 N 72041296 2310 125666 N

Anthony_eng · ‎02-25-2022

Hello, I am trying to create a graph that has multiple plots. The data should all have the same general behavior, but over different timeframes. I have uploaded an example similar to what I will be plotting. My data currently has time on the x-axis rather than the synchrony level shown above. I want all plots to be anchored or joined at the data point indicated by the number 3 in the image above (once the Y-values begin rising significantly). The reason for this is because the data has different timeframes for the overall experiment (the rise in values does not always occur at the same time), but I need to analyze outliers based on differences between the plots and linking them when the y-value increases will be instrumental in doing this. DATA WORK.VALUE; FORMAT EXPERIMENTKEY Description TIMESTAMP Translated; SET WORK.TRANSLATED; ResponseTimeMS = dif(TIMESTAMP); ValueDifference = dif(Translated); ResponseTime=ifn(first.EXPERIMENTKEY, ., dif(TIMESTAMP)); difValue=ifn(first.EXPERIMENTKEY, ., dif(Translated)); IF (difValue < 100) THEN DO; TransitionLowToHigh = 'N'; END; ELSE TransitionLowToHigh = 'Y'; BY EXPERIMENTKEY TIMESTAMP; RUN; My idea was to use the first TransitionLowToHigh with a Y value as a way to join the plots at that time. Unfortunately I don't know that it is possible. Is there a way to do this in SAS?

Anthony_eng · ‎01-11-2022

One of my variables is made up of long strings. Similar to the following: CODE 01|02|03|04|07|0A|0B|0C 01|02|03|04|05|0A|0B I have tried using % wildcard operator, which works in SQL, but I couldn't get it to work in SAS. I also tried using * which I had seen used in another similar question. I would like to use an IF THEN statement to do the following: IF CODE CONTAINS '03' THEN DO; Unfortunately only arithmetic operators can be used with IF THEN statements. I considered using the SUBSTR function, but I don't know the starting position of the codes, they can change for each observation. Any advice or ideas on how I can solve this issue?

Anthony_eng · ‎01-07-2022

Thank you I will review that. I will review the documentation and add the VAR as required. As for your question, yes. I wanted a separate table for each Year/Model combination.

Anthony_eng · ‎01-07-2022

Hello All, I am using SAS EG 8.3. I have provided my code below. I want to add the MEAN and MODE for each of the columns, but I receive the error shown below when I try to include MEAN and/or MODE. The code works fine if I take out the 'MODE' shown below on the TABLE line. The total for each column generate without error when using 'ALL'. I thought maybe my data was in the wrong format, but the totals are added correctly. Thank you for your time. PROC TABULATE DATA=WORK.DYNAMIC; CLASS YEAR MODEL EXPERIMENTID CODE; TABLE YEAR*MODEL, EXPERIMENTID ALL MODE, CODE; ODS OUTPUT Table = WORK.COUNTSTUFF; RUN; ERROR: Statistic other than N was requested without analysis variable in the following nesting : YEAR * MODEL * Mode * CODE.

Anthony_eng · ‎12-29-2021

I am using SAS EG Version 8.3. I would like to create an SG Plot based on two separate values within the same variable (column). Is this possible or do I need to create a dataset for each of the value types that I want? I have posted example data below. I want to have the values for type AC and type A42 to show as separate sets of data on the same plot if possible. My goal is to depict how the two values relate during the experiment. data contains ExperimentID TimeStamp Value Type 1 50 14 AC 1 85 14.4 AC 1 100 12.7 A42 1 105 14.1 AC 1 115 12.5 A42 PROC SGPLOT DATA=WORK.SORTED_ID; FORMAT ExperimentID BEST10.; BY ExperimentID; SCATTER X=TIMESTAMP Y=Value / NOMISSINGGROUP GROUP=Type; XAXIS LABEL='Time Elapsed (ms)'; YAXIS LABEL='Value'; RUN;

Anthony_eng · ‎12-27-2021

Hello everyone. I have included my SAS program below. The code is working at this point, but I need to add a step that will only keep the ExperimentIDs that contain both experiment types (A42 and AC). So if I have 100 observations for ExperimentID '1' but they all contain only type A42, I don't want that ExperimentID in my data. If there are 100 observations for ExperimentID '2' with some being of type A42 and others being type AC, then I would like all of those observations to show. Is this something that can be done in PROC SQL? Any advice/help regarding how I can make this happen? Thank you. PROC SQL; CREATE TABLE WORK.Experiment_VOLT AS SELECT t1.ExperimentID, t1.STATION, t2.TYPE, t2.TIMESTAMP, t2.VALUE, t1.TESTRESULT, t2.ADDRESS FROM WORK.Experiment t1 INNER JOIN WORK.DATA_FILTERED t2 ON (t1.ExperimentID = t2.ExperimentID) WHERE TYPE = 'A42' OR TYPE ='AC' ORDER BY t1.ExperimentID, t2.TIMESTAMP; QUIT;

Anthony_eng · ‎12-20-2021

Thank you, I will try the methods you mentioned.

Anthony_eng · ‎12-20-2021

Hello, I am trying to determine the best way to isolate data that is above or below certain thresholds. I am using SAS EG. I am not sure on the best method to isolate the desired data. I am trying to isolate all ExperimentSKeys where are all of the data in each is outside of the 4.5 to 14.5 range. For example, ExperimentID number 1 has 10 pieces of data. I want to create a table that shows this data only if all 10 observations were outside of the range. My end goal is to depict the data using a scatter plot once isolated. PROC SQL; CREATE TABLE WORK.AVGTRANSLATED AS SELECT EXPERIMENTID, TRIALKEY, LOCATIONID, AVG(TRANSLATED) AS AvgOfTranslated format=comma12.2, MIN(TRANSLATED) AS MinTranslated format=comma12.2, MAX(TRANSLATED) AS MaxTranslated format=comma12.2, COUNT(EXPERIMENTID) AS KeyCounts format=comma12.2, /*WHERE (MaxTranslated LE 12) OR (MinTranslated GE 14.95)*/ CASE /* Should I just use an if-then statement here instead? */ WHEN MaxTranslated <= 4.5 OR MinTranslated >= 14.5 THEN COUNT(EXPERIMENTID) AS OutCount format=comma12.2, END FROM WORK.QUERY_FOR_VOLTAGE_TRANSLATED GROUP BY EXPERIMENTID, TRIALKEY, LOCATIONID ORDER BY TRIALKEY; QUIT;

Anthony_eng · ‎12-20-2021

1 The SAS System 13:02 Thursday, December 16, 2021 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET SYSLAST=WORK.QUERY_FOR_VOLTAGE_TRANSLATED; 4 %LET _CLIENTTASKLABEL='FindAvgTranslated'; 5 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 6 %LET _CLIENTPROJECTPATH='/Shared Data/Shared Projects/dVoltage.egp'; 7 %LET _CLIENTPROJECTPATHHOST=''; 8 %LET _CLIENTPROJECTNAME='dVoltage.egp'; 9 %LET _SASPROGRAMFILE=''; 10 %LET _SASPROGRAMFILEHOST=''; 11 12 ODS _ALL_ CLOSE; 13 OPTIONS DEV=SVG; 14 GOPTIONS XPIXELS=0 YPIXELS=0; 15 %macro HTML5AccessibleGraphSupported; 16 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 17 %mend; 18 FILENAME EGHTML TEMP; 19 ODS HTML5(ID=EGHTML) FILE=EGHTML 20 OPTIONS(BITMAP_MODE='INLINE') 21 %HTML5AccessibleGraphSupported 22 ENCODING='utf-8' 23 STYLE=HtmlBlue 24 NOGTITLE 25 NOGFOOTNOTE 26 GPATH=&sasworklocation 27 ; NOTE: Writing HTML5(EGHTML) Body file: EGHTML 28 29 DATA ; 30 31 RUN; NOTE: Compression was disabled for data set WORK.DATA1 because compression overhead would increase the size of the data set. NOTE: The data set WORK.DATA1 has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 32 33 PROC SQL; 34 CREATE TABLE WORK.AVGTRANSLATED AS 35 SELECT EXPERIMENTID, TRIALKEY, LOCATIONID, 36 AVG(TRANSLATED) AS AvgOfTranslated format=comma12.2, 37 MIN(TRANSLATED) AS MinTranslated format=comma12.2, 38 MAX(TRANSLATED) AS MaxTranslated format=comma12.2, 39 COUNT(EXPERIMENTID) AS KeyCounts format=comma12.2 40 /*WHERE (MaxTranslated LE 12) OR (MinTranslated GE 14.95)*/ 41 CASE ____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE. ERROR 76-322: Syntax error, statement will be ignored. 2 The SAS System 13:02 Thursday, December 16, 2021 42 WHEN MaxTranslated <= 4.5 OR MinTranslated >= 14.5 THEN COUNT(EXPERIMENTID) AS OutCount format=comma12.2 43 END AS OutlierCount 44 FROM WORK.QUERY_FOR_VOLTAGE_TRANSLATED 45 GROUP BY EXPERIMENTID, TRIALKEY, LOCATIONID 46 ORDER BY TRIALKEY; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 47 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 48 49 %LET _CLIENTTASKLABEL=; 50 %LET _CLIENTPROCESSFLOWNAME=; 51 %LET _CLIENTPROJECTPATH=; 52 %LET _CLIENTPROJECTPATHHOST=; 53 %LET _CLIENTPROJECTNAME=; 54 %LET _SASPROGRAMFILE=; 55 %LET _SASPROGRAMFILEHOST=; 56 57 ;*';*";*/;quit;run; 58 ODS _ALL_ CLOSE; 59 60 61 QUIT; RUN; 62

Anthony_eng · ‎12-20-2021

Hello, I am trying to identify outliers in my data and then create a table using only the outlier data (data below 4 and above 15). I have included a sample of the code that I am trying to use. I intend on displaying the outlier data graphically once I am able to correct the code. I commented out the case statement that I was trying to use to identify data, I keep receiving the following syntax error when applying it. ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE. ERROR 76-322: Syntax error, statement will be ignored. PROC SQL; CREATE TABLE WORK.AVGTRANSLATED AS SELECT EXPERIMENTID, TRIALKEY, LOCATIONID, AVG(TRANSLATED) AS AvgOfTranslated format=comma12.2, MIN(TRANSLATED) AS MinTranslated format=comma12.2, MAX(TRANSLATED) AS MaxTranslated format=comma12.2, COUNT(EXPERIMENTID) AS KeyCounts format=comma12.2 /*CASE WHEN MinTranslated <= 14.5 OR MaxTranslated >= 4.5 THEN COUNT(EXPERIMENTID) AS OutCount format=comma12.2 END AS OutlierCount*/ FROM WORK.QUERY_FOR_VOLTAGE_TRANSLATED GROUP BY EXPERIMENTID, TRIALKEY, LOCATIONID ORDER BY TRIALKEY; QUIT; Thank you.

Online Status	Offline
Date Last Visited	‎05-20-2022 05:29 PM

Re: Concatenate consecutive column values

Concatenate consecutive column values

Re: Regular Expression in SAS Question

Regular Expression in SAS Question

Re: Is it possible to create an anchor point value for multiple plots?

Is it possible to create an anchor point value for multiple plots?

Using IF Then with wildcards

Re: Trying to determine MODE in PROC TABULATE

Trying to determine MODE in PROC TABULATE

How do I create an SGPLOT based on 2 values within the same variable?

Re: Concatenate consecutive column values

Re: Regular Expression in SAS Question

Re: Trying to determine MODE in PROC TABULATE

Re: Variable subsetting

Re: Identifying and Isolating Outliers in large dataset

Re: Concatenate consecutive column values

Concatenate consecutive column values

Re: Regular Expression in SAS Question

Regular Expression in SAS Question

Re: Is it possible to create an anchor point value for multiple plots?

Is it possible to create an anchor point value for multiple plots?

Using IF Then with wildcards

Re: Trying to determine MODE in PROC TABULATE

Trying to determine MODE in PROC TABULATE

How do I create an SGPLOT based on 2 values within the same variable?

Variable subsetting

Re: Identifying and Isolating Outliers in large dataset

Isolating Data using Case statements or IfThen statements

Re: Identifying and Isolating Outliers in large dataset

Identifying and Isolating Outliers in large dataset