Ho to get values from one data set to another data set.

Reply
Occasional Contributor
Posts: 13

Ho to get values from one data set to another data set.


Hi,

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.

Eg.

Excel imported X I have values like:

CELL_NM

A

B

C

D

In Dataset Y, I need to have value like

no. of store =count(Cell_NM).

Please suggest.



Super User
Posts: 5,257

Re: Ho to get values from one data set to another data set.

This requires very basic SQL programming skills. I suggest you get yourself some training/tutorials.

Data never sleeps
Occasional Contributor
Posts: 13

Re: Ho to get values from one data set to another data set.

can you please tell me the code

Super User
Super User
Posts: 7,401

Re: Ho to get values from one data set to another data set.

proc sql;

     create table Y as

     select     count(distinct CELL_NM) as NO_OF_STORE

     from       X;

quit;

Super User
Super User
Posts: 7,401

Re: Ho to get values from one data set to another data set.

Ask a Question
Discussion stats
  • 4 replies
  • 195 views
  • 0 likes
  • 3 in conversation