About venkatard

venkatard · ‎09-19-2013

Hi, I want to convert a few variables to missing in a dataset. Any help?

venkatard · ‎08-30-2013

Sorry Jaap, The problem is there are some 100 tables and i am making ETL in SAS Base. This finally goes to tables with same lengths in MYSQL and goes into product. So i cannot rename them as it will effect the final product. Kust wondered will there be any short cut 🙂

venkatard · ‎08-30-2013

That means there is no solution for this?

venkatard · ‎08-30-2013

Cannot do as i am extracting these tables from MYSQL DB.

venkatard · ‎08-30-2013

ERROR:Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SAS name in this context. I get the following error. is there any solution/option to get rid of this error.

venkatard · ‎06-26-2013

This will only replace for one variable. I need to replace for entire dataset

venkatard · ‎06-26-2013

I want to replace for all the variables.

venkatard · ‎06-26-2013

IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire dataset

venkatard · ‎06-26-2013

Is there any SAS Code for Bayes rule(bayesian) and Neural Networks. I do not have SAS EM.

venkatard · ‎06-24-2013

Is there any sas Macro available for decision tree(chaid) as i do not have SAS Enterprise Miner.

venkatard · ‎04-18-2013

This works Ron. Thank:-)

venkatard · ‎04-16-2013

I think i will give clear idea. First dataset with means. mean_score mean_forum mean_subs 23.45 43.45 12.22 Second data set with original values. Score forum subs 12 23 . 145 12 87 . 12 98 15 . 67 Now i want to replace the missing values in second data set with the mean value. For example in score if any value is missing it should be replaced with mean_score.

venkatard · ‎04-15-2013

I have 2 data sets one with mean value for each variable(proc means output) and the other with values. I want to replace the missing values with mean value for each particular variable in the dataset. Any help please. I tried call symput but does it work for multiple variables?

venkatard · ‎04-12-2013

Sorry for the confusion it is row and not column

venkatard · ‎04-12-2013

course class user score post forum quiz assign main group 1001 2001 3001 0 1 0 0 0 0 0 1001 2002 3001 0 0 0 0 0 0 0 1001 2001 3001 0 0 0 0 0 0 0 1001 2002 3001 5 0 0 0 0 0 0 In this example if we see the third and fourth column has all zeros. i want to know which row has all zeros and which has atleast one value. Any help please

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Convert values to missing

Re: Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SA...

Re: Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SA...

Re: Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SA...

Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SAS na...

Re: IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire d...

Re: IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire d...

IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire datas...

Is there any SAS Code for Bayes rule(bayesian) and Neural Networks. I ...

Is there any sas Macro available for decision tree(chaid) as i do not ...

Re: Can any one help me out in calculating moving(running) minimum and...

How to split a data set equally

Convert values to missing

Re: Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SA...

Re: Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SA...

Re: Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SA...

Name 'LCS_TBL_COURSE_ASSESSMENT_MATRIX_ASSOC' is too long for a SAS na...

Re: IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire d...

Re: IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire d...

IS THERE ANY FUNCTION TO REPLACE VALUE "0" TO Missing for entire datas...

Is there any SAS Code for Bayes rule(bayesian) and Neural Networks. I ...

Is there any sas Macro available for decision tree(chaid) as i do not ...

Re: I have 2 data sets one with mean value for each variable(proc mean...

Re: I have 2 data sets one with mean value for each variable(proc mean...

I have 2 data sets one with mean value for each variable(proc means ou...

Re: I want to create a new variable and see if the entire column has 0...

I want to create a new variable and see if the entire row has 0 or any...