topic Re: Propcase not working in SAS Programming

Propcase not working

manish_1 — Mon, 08 May 2017 12:04:51 GMT

I am attaching the snapshot of Data, Program and Log. Kindly tell me why the propcase is not working.

Re: Propcase not working

RW9 — Mon, 08 May 2017 12:14:33 GMT

A picture is useless to us. Post test data in the form of a datastep so we can run something. This works fine:

data want;
  abc=propcase("hello world");
run;

So the question is what are you running/doing that doesn't work. We cannot tell this from what you post, test data and your code so we can run it would help.

Re: Propcase not working

PeterClemmensen — Mon, 08 May 2017 12:14:38 GMT

Are you able to run this bit of code or does it give you the same error?

data test;
	var = Propcase('hello');
	put var;
run;

Re: Propcase not working

manish_1 — Mon, 08 May 2017 12:21:37 GMT

My Program

data sasdata.charfuntion;
infile "F:\Char function.txt" firstobs=2;
input Fname $ Lname $ Number;
Name1=Upcase(Fname);
Name2=Lowcase(Lname);
Name3=Propcase(Name2);
run;

------------------------------------------------

Attaching the data also.

Re: Propcase not working

Kurt_Bremser — Mon, 08 May 2017 12:22:46 GMT

That is a consequence of using stone-age software. SAS 9.0 stems from 2004(!), propcase() was introduced in SAS 9.1.

Upgrade to the current version ASAP.

Re: Propcase not working

RW9 — Mon, 08 May 2017 12:24:21 GMT

Works fine for me:

data want;
  input fname $ lname $ number;
  name1=upcase(fname);
  name2=lowcase(lname);
  name3=propcase(name2);
datalines;
Amit Singh 4132
Rahul Kumar 9166
Saurabh Sharma 9354
;
run;

Try starting a new session and just running the above. Also, please specify what software you are using, it looks like Version 8 of SAS, and also you don't seem to have activated your Windows - which arouses my suspicions of what software (legal or otherwise) you are using.