When I do a PROC PRINT... why do all of the variables print in Upper-Case? How can I ensure that what's printed, is EXACTLY as the data exists? Tnanks.
Variable names? That's because that's how they were created, SAS doesn't really care about the case of variable names.
If you want control over the names, you can use variable labels instead which have less restrictions than SAS names.
data demo; MyVar=1; MYVAR2=2; MyVAr3=3; run; title 'Mixed Case Example'; proc print data=demo label;run; title; proc datasets lib=work nodetails nolist; modify demo; rename MYVAR2=MyVar2 myvar3=MyVar3; run;quit; title 'Camel Case Example'; proc print data=demo ; run; title;
1) Please show the exact code submitted.
2) was the variable that you searched for the text "Last Cycle" the variable printed? (would not have to ask the question if you had shown the Proc print code submitted).
3) Ensure that the set you printed is the one that shows a format of $char175.
What happens if you run the following? Does it work as expected?
Also, check your own data with the ANYLOWER function applied to the variable of interest.
data test; input Var_Test $Char20.; cards; ABCDE abcde ABcde This is my test hello world HELLO WORLD ; run; title 'Raw data'; proc print data=test; run; title 'Upcase formatted'; proc print data=test; format var_test $upcase.; run; title 'Only with lowercase'; proc print data=test; where anylower(var_test)>0; run;
If you can't provide a reproducible example or such, you may be better off working with tech support so they can see your confidential data and such.
And verify if you really need NOFMTERR option, if you do, I suspect that could be causing some issues, since it's expecting formats.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.