01-07-2015 07:18 AM
I have one excel file having multiple excel sheet. I have imported all the sheet X and I have also created another data set Y in the sas library.
Now I need to take count of particular no. of rows from each excel one by one as all are different and then I wish to put that number in another data set.
Excel imported X I have values like:
In Dataset Y, I need to have value like
no. of store =count(Cell_NM).