@jflycn wrote:   1. The NAMEROW statement should be mentioned on the PROC IMPORT document. When user hits F1 on PROC IMPORT, every possible statement should be there, no matter BASE or SAS/ACCESS. 2. Detailed information for Excel importing should be linked on the PROC IMPORT document. When user hits F1 on PROC IMPORT, the document should easily lead the user to detailed information for different file types. 3. I actually use google more than document from the software. Maybe many SAS users do the same. I think the SAS documentation website is not SEO friendly, so it also creates some problems. 1. NOT every statement should be there, the ones for the installation should be there possibly. If you want to wade through the documentation for every single DBMS supported by SAS more power to you. And some of those IMPORT options are operating system dependent as well. So should the Windows user have the z/OS or MVS or Unix syntax, that will not work, included? 2. Why? If my shop does not use Excel why should Excel documentation be forced on us? And since Excel changes file formats so often I'm less interested in having to manuever through Excel 1, Excel 2, Excel 3, Excel..., Excel 13 versions.   ... View more

Haikuo, thanks for your response. My interpretation is the same as yours, i.e. ROW_NUMBER is a reserved word in FedSQL only means a possibility of future implementation.   Also thanks for your suggestion, but I guess this ODS approach won't work for ROW_NUMBER by group. I do know other turn around approaches to get ROW_NUMBER by group, just hope there is a staightfoward way of doing this in SAS. ... View more