topic SAS Data Manupulation (Urgent Help needed) in SAS Programming

SAS Data Manupulation (Urgent Help needed)

SAS_Practice — Mon, 17 Jun 2019 19:32:04 GMT

I have a following dataset with two variables (var, count):

var                                               count
--------------------------                    -------
Lassion Good Boy                         2
jassion bay boy                              5

Pankha 10

How can I create a dataset (not proc report, as I will use the result dataset later) without hardcoding as below (an additional row for the variable var), Result dataset should be as below :

var                                    count
----------------                     -------
Lassion Good Boy
Lassion Good Boy              2
jassion bad boy
jassion bad boy                   5

Pankha

Pankha 10

Thank you so much

Re: SAS Data Manupulation (Urgent Help needed)

Zhanxiong — Mon, 17 Jun 2019 19:35:43 GMT

So the "count" variable in the new data set is of type character instead of numeric?

Re: SAS Data Manupulation (Urgent Help needed)

SAS_Practice — Mon, 17 Jun 2019 19:39:59 GMT

Count should still be numeric.

Thank you

Re: SAS Data Manupulation (Urgent Help needed)

Zhanxiong — Mon, 17 Jun 2019 19:43:20 GMT

Then you will get a "." instead of blank in "count".

Re: SAS Data Manupulation (Urgent Help needed)

JoshB — Mon, 17 Jun 2019 19:47:04 GMT


data want(drop=_cnt);
  set have(rename=(count=_cnt));
  output;
  count=_cnt;
  output;
run;

Re: SAS Data Manupulation (Urgent Help needed)

Reeza — Mon, 17 Jun 2019 19:48:05 GMT

Are you familiar with the OUTPUT statement? That should be all you need for this problem. If order matters, you may want a PROC SORT as well.

And CALL MISSING() as well, to set values to missing is a convenient option. It doesn't matter if the variable is character or numeric.

@SAS_Practice wrote:

I have a following dataset with two variables (var, count):

var                                               count
--------------------------                    -------
Lassion Good Boy                         2
jassion bay boy                              5

Pankha                                          10

How can I create a dataset (not proc report, as I will use the result dataset later) without hardcoding as below (an additional row for the variable var), Result dataset should be as below :

var                                    count
----------------                     -------
Lassion Good Boy
Lassion Good Boy              2
jassion bad boy
jassion bad boy                   5

Pankha

Pankha                                10

Thank you so much

Re: SAS Data Manupulation (Urgent Help needed)

Zhanxiong — Mon, 17 Jun 2019 20:08:16 GMT

I guess even with CALL MISSING, you may still not assign a missing numeric value to be blank, as blank has already been reserved to represent missing character values.

Re: SAS Data Manupulation (Urgent Help needed)

Reeza — Mon, 17 Jun 2019 20:20:50 GMT

You could just set option missing to blank though. It'd definitely doable.

option missing = '';