I have data-set with 4 with variable ID, SEQNUM, NAME, and ACTION. We should group by id, seqnum,  and name in such a way that action variable  should not have "not done"  for that group.  Below is the sample data with ID SEQNUM, NAME, and ACTION as variables 470010002 2 abc NOT CHANGED 470010002 2 abc not done 470010002 4 def NOT CHANGED 470010002 4 def NOT CHANGED 470010002 7 jkl NOT CHANGED 470010007 19 xyz INTERRUPTED 470010007 19 xyz not done 470010010 10 pqr not done 470010012 5 suv NOT CHANGED 470010012 6 lmn INTERRUPTED 470010012 6 lmn INTERRUPTED 470010012 6 lmn INTERRUPTED 470010012 6 lmn INTERRUPTED 470010012 6 lmn not done the output looks like this 470010002 4 def NOT CHANGED 470010002 4 def NOT CHANGED 470010002 7 jkl NOT CHANGED 470010012 5 suv NOT CHANGED ... View more

I have dataset with around 80-90 variables. I want to create dataset  in such way that I have to drop those variables which are null for all records. It should be dynamic in such way if new variable is added with null value it should be dropped. Thanks ... View more

Can some one give me a proc sql code for the following query in sas PROC SORT DATA=x  OUT=x;       BY a; RUN; PROC SORT DATA=z  OUT=z (KEEP = a b c);       BY a; RUN;     DATA  final;       MERGE  x(IN=A) z;       BY a;       IF A; RUN; ... View more

I have CSV file. I am importing into SAS dataset using proc import but as result some of the data is truncated…can someone suggest if there is any better way importing…… PROC IMPORT OUT=mydata    DATAFILE="/c/clean.csv"        DBMS=CSV REPLACE;      delimiter = ";";     GETNAMES=YES;     DATAROW=2; RUN; ... View more

Hi, I have folder with N number of CSV files with same structural format but with different names for the csv file. I would like to append all csv files into one final dataset. The folder is dynamic folder and new csv files arrive on day to day…So would like to put in a macro such that every time program runs it would append all the existing csv files in one dataset. Thanks ... View more