Hello, I have a macro code that shows an error message in the log window.  Please let me know how to fix it. PROC EXPORT DATA=underlyspecify&year. outfile="Underly_Con_&bdate..xlsx" dbms=xlsx replace; sheet=&year.; run;  sheet=&year; NOTE: Line generated by the macro variable "YEAR". 1 1819     ---- 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string. ERROR 200-322: The symbol is not recognized and will be ignored. ... View more

Hello experts, I have a sample dataset with 10 columns, all of them are text characters, and each column has over 400 rows.   I would like to search any rows that are over 50 characters in those 10 columns.   Please advise how to approach it.  Thank you. ... View more

Hello experts, I would like to remove extra comma in different locations of the text.  Sometimes, front, back, and in the middle.   In addition, there might be a double at the front or in the end.   Is there a way to do that?  Thank you.   data Have; infile datalines delimiter='#'; input Comments : $200. ; datalines; , , FAILURE TO THRIVE # CHOLESTASIS, , ANEMIA# UGESTAGE=33.4 WKS , ROP # ASD, , # , NON VERBAL, ; run; data want; infile datalines delimiter='#'; input Comments : $200. ; datalines; FAILURE TO THRIVE # CHOLESTASIS, ANEMIA# UGESTAGE=33.4 WKS , ROP # ASD# NON VERBAL ; run; ... View more

Hello, I would like to extract numbers after text 'UGESTAGE'. Please advice, thank you. BTW, I haven't visited the community for a while, why I couldn't use the insert SAS code function. I apologize if the codes are not shown properly below. data Have; infile datalines delimiter='#'; input Comments : $200. ; datalines; UGESTAGE=34 5/7 WKS # UPREM, UGESTAGE = 32WKS # UGESTAGE =33.4 WKS # GASTROJEJUNOSTOMY DEPENDENCE, BILATERAL GRADE 4 VU ; run; data Want; infile datalines delimiter='/'; input UGESTAGE ; datalines; 34 / 32 / 33 / ; run; ... View more

Hello, I have macro coding below.  %let X1=ulungothsp; %let X2=uairwayothsp; %let X3=uhdefectsp; %let X4=uheartothsp; %let X5=ugastroothsp; %let folder="Designed pathway.xlsx"; %macro export; %do i = 1 %to 5; data &&X&i.; set test (keep=&&X&i.); if &&X&i. ^= ' '; &&X&i.=upcase(&&X&i.); run; proc sort data=&&X&i. nodupkey out=&&X&i._; by &&X&i.; run; PROC EXPORT DATA=&&X&i._ outfile=&folder dbms=xlsx replace; sheet=&&X&i.; run; %end; %mend; %export;   The log window showed error messages below when running. NOTE: Line generated by the macro variable "I". 1 &X1_ - 22 200 WARNING: Apparent symbolic reference X1_ not resolved. ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.X1_ may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.03 seconds 　 NOTE: Line generated by the macro variable "I". 1 &X1_ - 22 200 WARNING: Apparent symbolic reference X1_ not resolved. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. . . .   Please let me know how to fix it, thank you. ... View more

Hello,   I have dataset Test list below.    I would like to get the smallest date and the largest date from the each site.  For example, the result for Site 1 should be:  Starting Date 2016-12-01;  Ending Date 2020--5-29.      Please let me know how to approach it, thank you.   data test; format Sites 1. ScreenDate YYMMDD10.; infile datalines dsd; input Sites ScreenDate : yymmdd10.; datalines;   1, 2016-12-01, 1, 2016-12-21, 1, 2018-08-15, 1, 2020-05-29, 2, 2017-12-03, 2, 2015-10-23, 2, 2016-09-14, 3, 2019-12-10, 3, 2004-12-09, 3, 2006-08-20, 3, 2016-12-10, 4, 2000-05-06, 4, 2007-12-06, 4, 2016-09-27, ; Proc sort data=test; by sites ScreenDate; run;   ... View more