About ybz12003

ybz12003 · ‎10-02-2020

Super! But what is '^[^\d]*(\d+).*$/$1'? And what is '1' in front of the 'Comments'?

ybz12003 · ‎10-02-2020

Good morning, I would like to extract the numbers from the sample dataset 'Have'. I list the result I would like to get in the 'Want' dataset. data Have; infile datalines delimiter='#'; input Comments : $200. ; datalines; UGESTAGE=34 5/7 WKS # UGESTAGE=35WKS # UGESTAGE=33.4 WKS # UGESTAGE= 24 WKS ; run; data Want; infile datalines delimiter='/'; input UGESTAGE ; datalines; 34 / 35 / 33 / 24 ; run;

ybz12003 · ‎10-01-2020

Thanks much!

ybz12003 · ‎10-01-2020

Wow, this is SUPER!! What is the 's' in front of '/' used for? And what is '-1' for?

ybz12003 · ‎09-30-2020

Hello, experts, I have a sample dataset 'Have.' I would like to remove all the names shown in the dataset 'Maste_Name.' The final result is shown in the dataset 'Want.' Please help me to approach it. Thank you. data Master_Name; infile datalines dsd; input Name : $50. ; datalines; uairway, uapnea, ugastro, ugerd, uendo, uallergy ; run; data Have; infile datalines delimiter='/'; input Disease : $300. ; datalines; UGASTRO, UGERD, UALLERGY / UAIRWAY, CONGENITAL ATRESIA OF ESOPHA, UGASTRO / ECZEMA ; run; data Want; infile datalines delimiter='/';Re input Disease : $300. ; datalines; / CONGENITAL ATRESIA OF ESOPHA / ECZEMA ; run;

ybz12003 · ‎09-30-2020

Thank you so much, ChrisNZ and Gamotte. Both programs work!

ybz12003 · ‎09-29-2020

Hello, Is there a way to simplify the codes below. I have around 15 lines of Prxmatch. I list a few of them below, thanks. data want; set have; if prxmatch('/uairway/i',uothersp) then uairway=1; if prxmatch('/uapnea/i',uothersp) then uapnea=1; if prxmatch('/ugastro/i',uothersp) then ugastro=1; if prxmatch('/ugerd/i',uothersp) then ugerd=1; if prxmatch('/uendo/i',uothersp) then uendo=1; if prxmatch('/uallergy/i',uothersp) then uallergy=1; if prxmatch('/uprem/i',uothersp) then uprem=1; if prxmatch('/ugestage/i',uothersp) then ugestage=1; run;

ybz12003 · ‎09-08-2020

Hello, I wrote a program to assign a new column 'Class' corresponding to different dataset names. I found out the class is shown in '&&Y&i.', and not the individual dataset name. I have Please let me know how to fix it. Thank you. %let Y1=ulung; %let Y2=uheme; %let Y3=ucancer; %let Y4=utransplant; %let Y5=ugm; %macro assign; %do i = 1 %to 5; data &&Y&i.. (keep=Underlying_Cond class); set &&Y&i.; Underlying_Cond=strip(Upcase(Underlying_Conditions)); Class='&&Y&i..'; run; %end; %mend; %assign;

ybz12003 · ‎09-08-2020

Thank you so much! I didn't know there is a tricky way to use 'U:' to save tying my 15 dataset names one by one.

ybz12003 · ‎09-08-2020

Hello, I am trying to use DO LOOP to merge multiple datasets with different names. But the coding is not working, please help. Thanks. %let Y1=ulung; %let Y2=uheme; %let Y3=ucancer; %let Y4=utransplant; %let Y5=ugm; %macro merge; %do i = 1 %to 5; data Underlying; set &&Y&i.; run; %end; %mend; %merge;

ybz12003 · ‎08-20-2020

Hello, The typo mistake is driving me crazy. As the sample dataset is shown below, it's very easy to find out one name by misspelling one or two letters. Is there a way to put them into one name? For example, there are five spelling in 'LARYNGOMALACIA' and four spelling in 'DERMATITIS'. Could SAS figure out all of them means one thing? data datain1; infile datalines delimiter=','; input Name : $300. ; datalines; ALLERGIC RHINIT, ALLERGIC RHINITIS, ACUTE OTITIS ME, ACUTE OTITIS MEDIA, AIRWAY CLEARANCE IMPAIRMENT, AIRWAY CLEARENCE IMPAIRMENT, ATOPIC DERMATITIS, ATOPIC DERMATITS, ATOPIC DERMATITUS, ATOPIC DERMITITS, ECZEMA, ECZEMAN, EOSINOPHILIC ESOPHAGITIS, EOSINOPHILIC ESOPHAGITIS, EOSINOPHILIC ESOPHAITIS, IMPERFORATE ANUS, IMPERFORATED ANUS, LARYNGOMACLACIA, LARYNGOMALACIA, LARYNGOMALARIA, LARYNOMALACIA, LAYNGOMALACIA, SUBGLOTTIC STENOSIS, SUBLGOTTIC STENOSIS ; run;

ybz12003 · ‎08-20-2020

Thank you!

ybz12003 · ‎08-19-2020

Hello, I ran a code to change the 'forwardslash' and 'semicolon' to 'comma.' I found all of the columns are working, except one cell is '3 CRANIOTOMIES; HYPOSPADIAS.' Name=strip(compbl(translate(Disease,',','/;'))); The 'semicolon' between ''3 CRANIOTOMIES' and 'HYPOSPADIAS' didn't change to 'comma', but 'space' instead. I can't figure out why, and how to fix it. Please help, thank you.

ybz12003 · ‎08-18-2020

Hello, I have a 'datain1' list below. data datain1; infile datalines delimiter='/'; input Result1 : $100. Result2 : $100. Result3 : $100.; datalines; ACUTE OTITIS MEDIA/ASTIGMATISM/CONSTIPATION ; run; I could like to convert result1-result3 into one column 'Name.' Please help me to approach it, thanks. data dataout1; infile datalines dsd; input Name : $200. ; datalines; ACUTE OTITIS MEDIA, ASTIGMATISM, CONSTIPATION ; run;

ybz12003 · ‎08-18-2020

I have multiple prematching texts, which are not just 'ECZEMA,'

Online Status	Offline
Date Last Visited	‎12-18-2024 03:24 PM

Re: Title and Footnote could not be shown in the Output Excel file?

Title and Footnote could not be shown in the Output Excel file?

Re: Create a new 'Sub_Analyte' column?

Create a new 'Sub_Analyte' column?

Re: Count and assign descending date in Proc Report?

Count and assign descending date in Proc Report?

Re: How to create a do-loop list?

How to create a do-loop list?

Re: Creating a separated dataset for time changing?

Re: Creating a separated dataset for time changing?

Re: Create a new 'Sub_Analyte' column?

Re: Create a new 'Sub_Analyte' column?

Re: Title and Footnote could not be shown in the Output Excel file?

Re: How to create a do-loop list?

Re: How to create a do-loop list?

How to output two tabs with different names in Excel format?

Merge Multiple tables

Re: Why the command statement didn't work?

Re: Proc Univariate vs Proc Summary?

Text length question?

Re: How to extract the numbers from the text?

How to extract the numbers from the text?

Re: Remove 'Master_Names' in the text?

Re: Remove 'Master_Names' in the text?

Remove 'Master_Names' in the text?

Re: Simplify the coding - Macro? Do Loop?

Simplify the coding - Macro? Do Loop?

Macro '&&' could not be recognized?

Re: Using DO loop to merge multiple datasets

Using DO loop to merge multiple datasets

Spelling problem?

Re: Tranlate didn't work in semicolon?

Tranlate didn't work in semicolon?

How to convert the horizontal lines to vertical line?

Re: Illegal reference to the array?