Hi how may I change the following PROC SQL code to SAS code? I have tried everything I know but it gives me errors such as " Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values." RescaledValues is a csv dataset in my local file with no missing values. Scores is a SAS dataset with no missing values. proc sql;
create table RescaledValues as
select PageID , 100*(pageLikesN-min(pageLikesN))/(max(pageLikesN)-min(pageLikesN)) as pageLikes,
100*(commentsCountN-min(commentsCountN))/(max(commentsCountN)-min(commentsCountN)) as commentsCount,
100*(likesCountN-min(likesCountN))/(max(likesCountN)-min(likesCountN)) as likesCount,
100*(sharesCountN-min(sharesCountN))/(max(sharesCountN)-min(sharesCountN)) as sharesCount,
100*(pscoreMN-min(pscoreMN))/(max(pscoreMN)-min(pscoreMN)) as pscoreM,
100*(nscoreMN-min(nscoreMN))/(max(nscoreMN)-min(nscoreMN)) as nscoreM
from Scores;
quit;
... View more