Hi, I'm trying to read in MSG file into SAS but wasn't able to do so. Then I tried using LINUX command, I got it to convert to txt file but it wasn't readable by SAS. I used code like: data _null_;  x "cd /source/data/";  x "rename .msg .txt *.msg"; run; Can anyone help me in trying to read the Outlook MSG file from SAS? I'm ok with converting the msg file too into txt file but it should be SAS Readable.   Please help. ... View more

Say I have 2 tables as following. What would be equivalent proc sql code to the update statement be?   create table #City (CityId varchar(20), [Name] varchar(20), Period varchar(20)) create table #Assets (AssetId varchar(20), [Name] varchar(20))   insert into #City values (1, 'Asset1', null) insert into #City values (2, 'Asset2', null) insert into #City values (3, 'Asset3', null)   insert into #Assets values (1, 'Asset1') insert into #Assets values (2, 'Asset1') insert into #Assets values (3, 'Asset1') insert into #Assets values (4, 'Asset2') insert into #Assets values (5, 'Asset2') insert into #Assets values (6, 'Asset3') insert into #Assets values (7, 'Asset3')   select * from #City select * from #Assets   update #City set Period = (     select top 1 a.AssetID     from #Assets a     where #City.Name = a.Name     order by a.AssetId asc)   select * from #City   drop table #City drop table #Assets   Thank you! ... View more