Hi   I have a excel file which has many sheet. Have imported data with proc import mentioning sheet as "day" and dbms as "excel". I have sucessfylly imported data in SAS but there exist a problem with one of my variable that is "ELIGIBLE" The variable "ELIGIBLE" ahs two values TRUE and FALSE.   while importing SAS shows 0 and * as value. while cheking the column properties its showing Type as Numeric , Lenght as 8 , format and informat as 1.   while checking the logs for proc import it also doesnot have the procedure import step.   Thanks in advance  Vishyy     ... View more

Hi    I have three columns supoose named as int_rate, grade and sub_grade. Sample value are as below  int_rate grade sub_grade 0.1701      B      B4  0.0788      C      C5    I need to calculate average int_rate by grade and sub_grade.   Thanks & regards  Vishal  ... View more

Hi All.   I have a huge dataset which has various coulmns(variables). I want to find different values that exist in the dataset for a particular variable.   Thanks in advance  Vishyy   ... View more

Hi All.   I have a data file which has many columns. A lot of variable have 0 as values. I need to find which are the top  variables that will be problematic because of the presence of a lot of 0’s?     Thanks & Regards  Vishyy ... View more