topic Re: proc means in SAS Programming

proc means

mona4u — Thu, 15 Feb 2018 19:56:47 GMT

I have a numeric variable which includes some written characteristics parts like the following

the problem is I need to calculate some statistics for the variable by proc mean and it doesn't let me bc of the written characteristic part. this is the error that I got

Variable site_number in list does not match type prescribed for this list

I need a way to ask sas to ignore the written part and just calculate the numeric

or substr the numeric part

1453
1500
1600
1601
1602
1700
1750
5000
5002
5003 Main Campus
5003 Burbank

Re: proc means

novinosrin — Thu, 15 Feb 2018 19:59:49 GMT

filter using

where anyalpha(var)=0;

Re: proc means

mona4u — Thu, 15 Feb 2018 20:04:57 GMT

this code isn't working

Re: proc means

novinosrin — Thu, 15 Feb 2018 20:05:28 GMT

post your code and log please

Re: proc means

Astounding — Thu, 15 Feb 2018 20:19:05 GMT

PROC MEANS does not compute statistics for character variables. You need to create a new variable, make it numeric, and have it contain the numeric piece of SITE_NUMBER. For example:

data want;

set have;

newvar = input( compress(site_number, , 'kd' ), 5.);

run;

Then you can process the new variable with PROC MEANS.

If the numeric portion is always the first four or five characters of SITE_NUMBER, the formula can be simplified:

newvar = input(site_number, 5.);

Re: proc means

Reeza — Thu, 15 Feb 2018 20:49:10 GMT

You need to clean your data before you analyze it. With the data in the form shown, I suspect it was not read in correctly to start.

Re: proc means

ballardw — Thu, 15 Feb 2018 23:23:40 GMT

@mona4u wrote:

this code isn't working

Doesn't work is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of a dataset, the actual results and the expected results. Data should be in the form of a data step. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.