The recent version of Analyze supports this functionality; however, I see the question was for LAE. In addition to the solution Gerry provided, a native SQL Server method exists. The SQL Server solution is to build the query dynamically and execute it. Here is an example of the syntax:
declare
@AssetID nvarchar(50) = ?,
@db nvarchar(100) = ?,
@schema nvarchar(100) = ?,
@table nvarchar(100) = ?,
@column nvarchar(100) = ?,
@prof nvarchar(max)
set @prof = 'Select ' +
@AssetID + ' AS AssetID
,COUNT(' +@column +') AS [RowCount]
,COUNT(DISTINCT ' + @column +') AS UniqueCount
From ' +@db +'.'+@schema +'.'+@table
Exec (@prof)