I am not sure i understand the logic you want to implement. From your description, i would guess the answer should be 300 and not 200.     data have; infile cards dlm=',' dsd; attrib Date format=date9. informat=ddmmyy8.; length name $10.; input ID Date name $ Amount Flag_first_name Flag_last_name; cards; 12345,21032016,Bob,200,0,0 12345,21032016,Bob,300,0,0 12345,31122014,Bob,500,0,0 67890,31012012,John,100,0,0 67890,31012006,John,200,1,0 ; run; proc sql; CREATE TABLE want AS SELECT * FROM ( SELECT * FROM have WHERE strip(name)="Bob" GROUP BY name HAVING Date=max(Date) ) GROUP BY Name HAVING Amount=max(Amount); quit; ... View more

Hello,   data have; infile cards dlm=',' dsd; attrib Date format=date9. informat=ddmmyy8.; length name $10.; input ID Date name $ Amount Flag_first_name Flag_last_name; cards; 12345,15082014,Bob,100,0,0 12345,20122016,Bob,200,0,0 12345,20122016,Bob,150,0,1 67890,31012012,John,100,0,0 67890,31012006,John,200,1,0 ; run; proc sql; CREATE TABLE want AS SELECT * FROM have WHERE strip(name)="Bob" GROUP BY name, date HAVING Amount=max(Amount); quit; ... View more

With proc sql :   data have; input Group $ Member; cards; A 1 A 1 A 2 B 1 B 1 B 1 C 2 C 1 ; run; proc sql; CREATE TABLE want AS SELECT * FROM HAVE GROUP BY Group HAVING count(DISTINCT Member)=1; quit; ... View more

Are those columns of a SAS dataset ? If so, does this mean that values are stored as character variables ? Why not use a numeric format since your data is of numeric nature ?   ... View more

You have to describe more precisely your needs.   Here are the contents of your csv file :   Trial - 2015,,,,, ,,,,, food  quality data,,,,, ,,,,, Plot,Cultigen number,Rep,Loc,Std,1 ,,,,, 6360,1,1,CIe,6,11 ,,,,, 6366,2,1,CIe,6,. What should the output dataset look like ? What are the names/formats of the columns ? ... View more

Which program ?   The log message says that SAS has created a dataset DST1 in the work library. This dataset has 18 columns but no row of data, i.e. it's an empty dataset.   Can you show the code and describe expected output. ... View more

Hello,   Something like this ?   Data BU; infile datalines dlm=','; input Business_Unit $ Dataset $ Variables $; datalines; Credit,Dsn1,Var1 Credit,Dsn1,Var2 Credit,Dsn1,Var3 Credit,Dsn2,Var1 Credit,Dsn2,Var3 ; run; Data Lookup; infile datalines dlm=','; input Business_Unit $ Variables $; datalines; Credit,Var1 Credit,Var2 Credit,Var3 ; run; proc sql; CREATE TABLE Qc1 AS SELECT a.Business_Unit, a.Dataset, b.Variables FROM BU a LEFT JOIN Lookup b ON b.Business_Unit=a.Business_Unit EXCEPT SELECT * FROM BU; quit; ... View more