Hi all, I've been trying to educate myself on CHAID but preliminary search shows the only way to build/run a model in SAS is by using the Enterprise Miner. Is that true? I don't have the Miner, just Enterprise Guide. Can anyone please direct me to sample code in SAS for a CHAID analysis? Thanks! ... View more

Hi, I used an infile statement to convert a data file into a SAS dataset in UNIX. libname here '.'; data here.a1;        infile "pos1" dsd dlm='|' firstobs=2 missover;          input MKT $ STORE $  WEEK $ DATE $ USE $ ........ run; I want to read in about 50 variables, but I get the following warning, and it also messes up a few columns. WARNING: Truncated record. Can somebody help? Also, is there a smarted way to read in all variables from the dataset? Thanks! ... View more

Can I use proc compare to compare and output equal values in more than two columns in the same dataset? Say for the following, each class has different combinations of different columns for weight, but I want them all extracted from the bigger dataset: Class Wt1 Wt2 Wt3 Wt4 Wt5 1 67 89 56 56 45 2 72 72 45 87 23 3 43 78 99 43 88 Thanks! ... View more

Hi, I want to use the following code to create counts of groups. My only problem is that there are more than a 100 distinct types. Is there a smart way to do it? proc sql; create table a as select distinct type1, type2, type3, count (*) as count from b group by type1, type2, type3; quit; Thanks. ... View more