BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
alepage
Barite | Level 11

Hello,

 

I am using proc stdize to set the missing value to zero without having to named all numeric variables.  Nice proc....

however, I am receiving this warning:

 

WARNING: At least one of the scale and location estimators of variable var12 can not be computed. Variable var12 will
not be standardized.

 

I believe that this warning popup only when all the values are missing for a particular variable.  Is it possible to continue to use this procedure to set the missing value to zero without getting this warning?

 

Regards,

 

Alain

 

proc stdize data=Dataset1

out=dataset2 reponly missing=0;

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

First ask yourself does it make sense to "standardize" a variable will all missing value to anything? Why were all of the values missing might be a critical question before attempting to use values of 0 in further steps.

 

 

You will likely have to add the value of 0 in a separate data step, either before or after the Proc Stdize call.

View solution in original post

6 REPLIES 6
stat_sas
Ammonite | Level 13

Hi, 

 

Please try this

 

proc stdize data=Dataset1(drop=var12) reponly out=dataset2 missing=0;
run;

alepage
Barite | Level 11

Good evening,

 

I have tested two different codes and when all the values of a variable are missing, we get the warning message.

 

data have;
infile datalines delimiter=',';
input A B C;
datalines;
1, ,3
3, ,4
3, ,5
., ,7
2, ,3
6, ,.
.,1 ,2
;
run;
proc stdize data=have reponly out=want missing=0;
var _numeric_;
run;

 

The following code is not working because all the values of B are missing;

data have;
infile datalines delimiter=',';
input A B C;
datalines;
1, ,3
3, ,4
3, ,5
., ,7
2, ,3
6, ,.
.,.,2
;
run;
proc stdize data=have reponly out=want missing=0;
var _numeric_;
run;

alepage
Barite | Level 11

Thanks for responding to my question.

 

I have test your code and it works but if a drop a variable I will not be able to set the missing value to zero.

 

Regards,

Alain

ballardw
Super User

First ask yourself does it make sense to "standardize" a variable will all missing value to anything? Why were all of the values missing might be a critical question before attempting to use values of 0 in further steps.

 

 

You will likely have to add the value of 0 in a separate data step, either before or after the Proc Stdize call.

alepage
Barite | Level 11

Good evening,

 

You have a very good point regarding the use of a missing variable. My client is asking me to develop algorithms either to extract data or to perform calculations.

 

Our dataset are relatively large and we don't know at the begining that in a certain dataset, for a particular variable, all the value are missing.

 

I have recently experiment this procedure to initialize missing value to zero without have to name all the variables, but it sound it not appropriate when all the values are missing.

 

Regards,

 

Alain

 

ballardw
Super User

@alepage wrote:

Good evening,

 

Our dataset are relatively large and we don't know at the begining that in a certain dataset, for a particular variable, all the value are missing.

 

 


First step with almost any project is get some familiarity with the data. For numeric a quick

 

Proc means data=have ;

   var _numeric_;

run;

 

Would show you the variables with all missing values (N=0) on possibly other problematic variables by mean, min or max values.

 

For instance a numeric with all missing values I might trace back to documentation to see if 1) is supposed to be numeric and 2) did the data actually contain value but they were not acceptable as numeric such as containing special characters or were currency read with the incorrect informat. A "large" data set with any variable missing for all records often points to some issue from data extraction by the client, incomplete specifications of data received (to include changes without notification) or read specification errors on my part.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 3454 views
  • 1 like
  • 3 in conversation