About ybz12003

ybz12003 · ‎03-02-2022

Hello, I would like to inquire about the length of the text ' EC1R0000' and 'ER3R00053', why did the result come back showing the same? I expect the first one is 8 and the second one is 9. Please help. ID_cat=length(ID);

ybz12003 · ‎02-23-2022

Because the actual data contain numbers and charater.

ybz12003 · ‎02-23-2022

So, it seems like the code below works for the result I want, which needs to have three arguments instead of two. ID_=compress(strip(upcase(ID_)), , 'A'); But I still don't understand why two arguments are not working. ID_=compress(strip(upcase(ID_)), 'A');

ybz12003 · ‎02-23-2022

I got the code from the someone else.

ybz12003 · ‎02-23-2022

What's X for?

ybz12003 · ‎02-23-2022

Page Not Found

ybz12003 · ‎02-23-2022

The link is not working...

ybz12003 · ‎02-23-2022

Hello, I try to use "compress" to remove the letter or number from the string. Somehow it didn't work. Please let me know how to fix it. ID_=compress(strip(upcase(ID)),'A0'x); Below is some sample strings: BIPAP (BIPHASIC POSITIVE AIRWAY PRESSURE) DEPENDENCE, CHRONIC RESPIRATORY FAILURE CHRONIC RESPIRATORY FAILURE & VENT/TRACH DEPENDENT I expect the result is shown below. (), & /

ybz12003 · ‎02-23-2022

I didn't use your code but would like to try the 'Update' statement to compare mine to see if there is any difference. Although my codes had ten more steps, I feel safer getting a dataset I want.

ybz12003 · ‎02-18-2022

Also, the final combined dataset C = 1001 columns = 1950 old columns (A) + 49 updated infor. columns (B) + 1 'Record_updated' column (B)

ybz12003 · ‎02-18-2022

I expect the final combined dataset C = 20000 IDs (A) = 5000 IDs (B) + 15000 extra IDs

ybz12003 · ‎02-18-2022

The A's 20000 IDs have B's 5000 IDs.

ybz12003 · ‎02-18-2022

Hello, I am trying to find a way to combine two datasets efficiently. Dataset A contains around 1000 variables (Numeric and Characters) and 20000 obs. Dataset B contains around 50 variables (Numeric and Characters) and 5000 obs. Both A and B have the same 5000 IDs. B has 49 columns with the same names as A, and one extra 'Record_updated' column. In addition, B has all the updated records in those 49 columns. I would like to combine A and B with a result, that contains 1001 columns and 20000 obs, including 49 updated B dataset columns, and a new 'Record_updated' column. Please advise how to approach it, thanks.

ybz12003 · ‎02-18-2022

Thanks for your help, though I have figured out some functions I could use from previous questions.

ybz12003 · ‎02-17-2022

I generated a code below, not sure whether it's correct. How to list numbers from highest to the lowest? Thanks. proc freq data=underly1621_nodup; tables X1-X10 / out=FreqCount; run; proc print data=FreqCount noobs; title2 'ARI2016-2021 Underlying Condition count table'; run;

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?

Text length question?

Re: Remove letter or number from string by using compress?

Re: Remove letter or number from string by using compress?

Re: Remove letter or number from string by using compress?

Re: Remove letter or number from string by using compress?

Re: Remove letter or number from string by using compress?

Re: Remove letter or number from string by using compress?

Remove letter or number from string by using compress?

Re: Combine dataset question?

Re: Combine dataset question?

Re: Combine dataset question?

Re: Combine dataset question?

Combine dataset question?

Re: How to create a table with count/percent/accumulated percent?

Re: How to create a table with count/percent/accumulated percent?