About sas_viclearner

sas_viclearner · ‎10-31-2017

In the diagram Columns A,B,C, D has $ symbol for currency, i need to get rid of them. And some of the values are missing which are shown as blank, i need to replace those blank with NA not a numeric Edit [KB]: adapted the subject line.

sas_viclearner · ‎10-31-2017

Hi Team, I have a csv file in which some columns( example column A) has $ value and column B has (0 value). How can i remove $ symbol for column A and convert the column B value to numeric(NA)

sas_viclearner · ‎10-25-2017

how can i add a personalized message for scores <50 as poor and >50 as excellent

sas_viclearner · ‎10-25-2017

Hi Everyone, Please see the below picture where my file says no data exists when I am trying to explore data from Score data. Can anyone tell me what could be the reason? How can I explore the data from scoring? Please help..! Thanks in advance.

sas_viclearner · ‎10-24-2017

Hello everyone, Can anyone tell me how to use two different decision trees to model the data using SAS Enterprise Miner. Many thanks in advance.

sas_viclearner · ‎10-23-2017

Hi Team, I have a hierarchy(Name: ABC) created for 3 variables. I need to create a drillable crosstab visualisation showing the x, y, z measures by hierarchy ABC. How can I create a display rule which highlights the values( for example greater than 50 as Excellent and less than 50 as poor).

sas_viclearner · ‎10-21-2017

Hi Team, I have a csv file , i want to create a bat file using libname function. i tried using the following line of code under the project code libname sample "path of csv file"; i cannot find the bat file created. Any suggestion appreciated

sas_viclearner · ‎10-21-2017

Thanks Michelle

sas_viclearner · ‎10-21-2017

Hi Team, I have created a hierarchy and now need a drillable chart to be created by a measure(xyz) and hierarchy created. Any suggestions appreciated. Thanks

sas_viclearner · ‎10-19-2017

Hi, Thank you for the material. It was very helpful. Could you please tell me how to do the average absent days and average discipline days by lunch status. Please see the attached file for more information. Thanks in advance.

sas_viclearner · ‎10-18-2017

Hi, Thank you for the response.I am using SAS VA Designer.Actually, i don't know the process to calculate the percent of students enrolled.I am new to this platform.Please find the link below where it contains the sample student data . Thanks

sas_viclearner · ‎10-18-2017

Hello everyone, Below are the questions I need to find out by using student data in SAS VA. I just want to know the process how to carry out the below method. i. How can I calculate the percentage of students enrolled in each school? ii. How to find out Enrolment numbers for each school category, each year? iii. Also, A breakdown of enrolment numbers by Grade, Ethnicity and Gender? Please help..! Thanks in advance

sas_viclearner · ‎10-17-2017

Hi Colin, I have a numeric measure "year" and to convert it into category variable "Year" do i need to duplicate the numeric measure and name it with category variable name

sas_viclearner · ‎10-17-2017

hi everyone, i have a data set which has Year as measure and i need to convert it to category variable year. Can any one help me in this. how can i do it? if i do it how is it going to affect my rest operations on data? what are the steps to be considered before i do this. Any suggestion and help is much appreciated. Thanks

Online Status	Offline
Date Last Visited	‎11-05-2017 01:29 AM

Re: Removing currency symbol, replace missing with "NA"

Removing currency symbol, replace missing with "NA"

Re: Display rule

When i am trying to Explore data from Score data_I see no data exsits

what is the process to use two different decision trees to model the d...

Display rule

SAS ENTERPRISE MINER

Re: drillable chart

drillable chart

How to calculate the average absent days and average discipline days b...

Re: convert numeric measure year to category variable year

Re: drillable chart

Re: Removing currency symbol, replace missing with "NA"

Removing currency symbol, replace missing with "NA"

Re: Display rule

When i am trying to Explore data from Score data_I see no data exsits

what is the process to use two different decision trees to model the d...

Display rule

SAS ENTERPRISE MINER

Re: drillable chart

drillable chart

How to calculate the average absent days and average discipline days b...

Re: How will i know the percentage of students enrolled in each school...

How will i know the percentage of students enrolled in each school?

Re: Measure to Category conversion in SAS VA

convert numeric measure year to category variable year