topic Re: Proc Freq and Proc Transpose in SAS Programming

Proc Freq and Proc Transpose

Anoruo — Sat, 23 May 2020 01:59:26 GMT

Hello,

Please i intend to use the output from the proc freq procedure to execute the Proc Transpose , however the Out=AA dataset displays only the Country by Trt01p; So when i use the AA dataset to execute the Proc Transpose , the variables Sex , Race and Country are all missing .

Question : How do i make Sex, Race and Country appear in the AA dataset?

Proc freq data=B ;
Table SEX RACE ETHNIC COUNTRY / out=AA ;
BY Trt01p ;
Run;

/*Step 3*/

Proc Transpose data=AA ;
ID Trt01P ;
BY SEX RACE ETHNIC COUNTRY ;
VAR Count;
run;

I have attached the dataset

Thanks a lot

Re: Proc Freq and Proc Transpose

Reeza — Sat, 23 May 2020 02:03:48 GMT

Try my example here:

https://gist.github.com/statgeek/e0903d269d4a71316a4e

If this is for display, you can also consider PROC TABULATE as an option.

@Anoruo wrote:

Hello,

Please i intend to use the output from the proc freq procedure to execute the Proc Transpose , however the Out=AA dataset displays only the Country by Trt01p; So when i use the AA dataset to execute the Proc Transpose , the variables Sex , Race and Country are all missing .

Question : How do i make Sex, Race and Country appear in the AA dataset?

Proc freq data=B ;
Table SEX RACE ETHNIC COUNTRY / out=AA ;
BY Trt01p ;
Run;

/*Step 3*/

Proc Transpose data=AA ;
ID Trt01P ;
BY SEX RACE ETHNIC COUNTRY ;
VAR Count;
run;

I have attached the dataset

Thanks a lot

Re: Proc Freq and Proc Transpose

Anoruo — Sat, 23 May 2020 02:09:38 GMT

@Reeza Thanks for your response . It is not actually for display , i want to use it for some computations and i am required to use Proc Transpose. Thanks for your quick response.

Re: Proc Freq and Proc Transpose

PGStats — Sat, 23 May 2020 22:24:27 GMT

Maybe all you need is:


Proc freq data=B ;
Table SEX*RACE*ETHNIC*COUNTRY / out=AA ;
BY Trt01p ;
Run;

proc sort data=aa; by SEX RACE ETHNIC COUNTRY; run;

/*Step 3*/

Proc Transpose data=AA out=bb;
ID Trt01P ;
BY SEX RACE ETHNIC COUNTRY ;
VAR Count;
run;

Re: Proc Freq and Proc Transpose

Reeza — Sun, 24 May 2020 02:07:09 GMT

Did you run the code? It still answers your question.

@Anoruo wrote:

@Reeza Thanks for your response . It is not actually for display , i want to use it for some computations and i am required to use Proc Transpose. Thanks for your quick response.