topic Re: how to get valiable names from multiple datasets in SAS Programming

how to get valiable names from multiple datasets

radha009 — Mon, 30 Apr 2018 22:44:13 GMT

i have 4 datasets jan_Data,feb_data,march_data,April data

All tables variable names are same ( ID,name,owner,val_requred (yes/No)

jan_data - dataset:

A451 oranges peter yes

B345 Apples sam No

B123 berry john yes

Feb_data - dataset:

A451 oranges peter No

B123 berry john yes

C125 grape rob yes

Expected result:

ID name owner val_req_jan val_req_feb val_req_mar

A451 oranges peter yes No

B123 berry john yes yes

B345 Apples sam No

C125 grape rob yes

Thank you

Re: how to get valiable names from multiple datasets

ballardw — Mon, 30 Apr 2018 22:57:29 GMT

One way IF all the data sets are sorted by id name and owner

data want;
   merge jan_data    (rename=(val_required = val_req_jan))
         feb_data    (rename=(val_required = val_req_feb))
         march_data  (rename=(val_required = val_req_mar))
         april_data  (rename=(val_required = val_req_apr))
   ;
   by id name owner;
run;

For a large number of analysis you might be better off by setting the sets and adding a variable that holds the month and likely as an actual date. Things would sort as needed using a date and any analysis /reporting would not require having to add a variable name when the May, June, July etc data is available. Not to mention ease of ordering things if you cross a calendar year border...

You also may find it helpful to change Yes/No coding with character values to numeric 1/0. Then a sum of the values would be the count yes, the mean a percentage.

How will the resulting set be used?

Re: how to get valiable names from multiple datasets

Reeza — Mon, 30 Apr 2018 23:03:54 GMT

I'd probably APPEND the data and then use a TRANSPOSE to transform the months into a wide format.

@radha009 wrote:

i have 4 datasets jan_Data,feb_data,march_data,April data

All tables variable names are same ( ID,name,owner,val_requred (yes/No)

jan_data - dataset:

A451 oranges peter yes

B345   Apples sam   No

B123    berry    john   yes

Feb_data - dataset:

A451 oranges peter No

B123    berry    john   yes

C125    grape rob yes

Expected result:

ID         name    owner    val_req_jan      val_req_feb         val_req_mar

A451 oranges   peter        yes                      No

B123    berry    john            yes                      yes

B345   Apples   sam          No

C125    grape rob                                        yes

Thank you

Re: how to get valiable names from multiple datasets

radha009 — Mon, 30 Apr 2018 23:49:29 GMT

Awesome. Thanks a lot.