Hello. I have a table with 120 columns and 22k rows loaded into memory and promoted. I add the columns 1 by 1 at a list table but when I added the first 4 columns (category type) the total rows reduced to 21k. I continue adding more columns to the table and the total rows from the report keeps decreasing. I end up with 1700 rows. Notice that I have selected "Detail Data" in the options to specify NOT to aggregate on any column. It does not show any error though, while building the table. Some columns have missing values too, but not all the columns at the same time. (At least 1 column is non-missing for every row).   Thank you for any help or suggestion.   ... View more

Hello guys. I am running a DS2 procedure and reading an in-memory table. Code is similar to the structure below. %LET SESSION=table2pro; %LET ACASLIB=PUBLIC ; cas &SESSION sessopts=(caslib=&ACASLIB. timeout=1800 locale="en_US"); libname &ACASLIB. cas; caslib _ALL_ list ; caslib _ALL_ assign ; proc Ds2;     DS2_OPTIONS divbyzero=ignore;     DS2_OPTIONS TYPEWARN;     DATA &ACASLIB..output_M1 / overwrite=yes;         method run();             SET &ACASLIB..input_M1; /* OTHER STATEMENTS HERE*/ /* OTHER STATEMENTS HERE*/ I get an error like: ERROR: Compilation error. ERROR: BASE driver, schema name PUBLIC was not found for this connection I would appreciate any help. ... View more

Hello guys. I have a huge dataset with 700'000 rows and around 300 variables.  I wanted to create a new dataset WANT where I keep only variables with 2 types of values. For example AGE has values M and F. I am doing this to convert to 0 and 1 and interpret afterward.   Take the example below data GIVEN; input ID AGE NAME $ YEAR ACTIVITY $ HEIGHT $; DATALINES; 1 23 ERI 1995 ACTIVE TALL 2 22 ANDI 1997 ACTIVE SHORT 3 20 ENCA 2000 PASSIVE TALL 4 26 BORA 2001 ACTIVE SHORT ; RUN;   So here, I want to keep only variables ACTIVITY and HEIGHT since the result is either tall or short, either active or passive. I have hundreds of variables and I can't seem to work it out. Thanks in advance ... View more