This works, but I struggle to use a function like 'round' for the result nrows['numrows']
proc cas; simple.numRows result=nrows status=s / table={name= 'TELYNET_WIDE_YTD_V16' caslib='onair'}; if (s.severity == 0) then print nrows['numrows']/1E6; run;
This may help you.
proc cas; simple.numRows result=nrows status=s / table={name='TELYNET_WIDE_YTD_V16' caslib='onair'}; if (s.severity == 0) then print round(nrows['numrows']/1E6) as RoundedNumRows; run;
April 27 - 30 | GAYLORD TEXAN
Register now to lock in early bird pricing through February 25!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!