topic Re: How to print a variable containing capital letter X? in SAS Programming

How to print a variable containing capital letter X?

elaine00 — Sun, 29 Apr 2018 00:55:38 GMT

How do I print a variable containing capital letter X?

I have no idea how to write the code, please help.

Re: How to print a variable containing capital letter X?

Shmuel — Sun, 29 Apr 2018 01:09:49 GMT

Having a char type variable you can use either of next functions:

- UPCASE will change all charcters into upper case (capital) letters

- LOCASE will change all characters into low case letters

syntax: var = upcase(var); same with locase.

You can change 1st letter only by:

substr(var,1,1) = upcase(substr(var,1,1));

Re: How to print a variable containing capital letter X?

elaine00 — Sun, 29 Apr 2018 01:17:38 GMT

How do I print it if the letter I selected is not in the first position?

Re: How to print a variable containing capital letter X?

novinosrin — Sun, 29 Apr 2018 01:19:17 GMT

@elaine00wrote:
How do I print a variable containing capital letter X?
I have no idea how to write the code, please help.

Do you mean

data example;

length var $50;

var='Xgjhhkj';

output;

var='iuyuiuioX';

output;

var='trt';

output;

run;



data wanted_output;

set example;

if index(var,'X')>0;
 put var=;

run;

Re: How to print a variable containing capital letter X?

elaine00 — Sun, 29 Apr 2018 01:25:24 GMT

It is a dataset, I am supposed to print all the obs that containing the capital letter X of a variable (there are many variable and obs).

Re: How to print a variable containing capital letter X?

novinosrin — Sun, 29 Apr 2018 01:36:06 GMT

Ok, Can you please post a sample of your dataset like 10 obs/vars with values and your expected output. Also, when you say "print" , please let the community know whether you want the output in a sas dataset or ods or printed values in the log. This will help the community to not assume your requirement. Thank you!

Re: How to print a variable containing capital letter X?

elaine00 — Sun, 29 Apr 2018 01:56:59 GMT

Thank you. The question says, Print the population of the states containing the letter C (Capital C, case sensitive) in their GEO_display_label. and I attached the csv file

Re: How to print a variable containing capital letter X?

art297 — Sun, 29 Apr 2018 03:23:09 GMT

Assuming respop72015 represents the population in 2015, then here is one way to do it:

data have;
  infile '/folders/myfolders/USPOP.csv' dlm=',' dsd lrecl=200 firstobs=2;
  informat GEO_id $12.;
  informat GEO_display_label $40.;
  input GEO_id GEO_display_label respop72010-respop72015;
run;

proc print data=have (where=(index(GEO_display_label,'C') and
                      GEO_id ne '0400000US11'));
  var GEO_display_label respop72015;
run;

Art, CEO, AnalystFinder.com

Re: How to print a variable containing capital letter X?

elaine00 — Sun, 29 Apr 2018 03:41:04 GMT

Thank you! It really helps!