data lemon; input food $ fooder $; datalines; apple applepie run; data test output=test1; set lemon; y=index(fooder,"pie"); run; proc print data=test1; run;
how can I also have y in my output table test1?
The correct syntax for this is:
data test test1;
set lemon;
y=index(fooder,"pie");
run;
Test and Test1 will be identical and both contain y.
if index(segment, "QHKG") then total = total _bad_count
originally I thought this statement is about if we can look for QHKG in segment, however if it exist QHKG will be a positive interger indicating its position, if not found, I will get a zero, so how does this statement work? when does total=total_bad_count? when it is not zero?
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.