topic Re: Format issue in SAS Programming

Format issue

zimcom — Fri, 21 Aug 2020 13:58:45 GMT

Good morning!

I have a table

Country	Sex	Age
Canada	Female	89
Canada	Male	62
USA	Female	55

I want to convert into a table below with one variable but combining the 3 variables values into different row

Country/ Sex/ Age

Canada
Female
89

Canada
Male
62

USA
Female
55

Thanks !

Re: Format issue

PeterClemmensen — Fri, 21 Aug 2020 14:01:44 GMT

Is this for reporting purposes or do you need at SAS data set like this?

Re: Format issue

zimcom — Fri, 21 Aug 2020 14:05:03 GMT

Yes, for reporting purpose.

Re: Format issue

Shmuel — Fri, 21 Aug 2020 14:32:56 GMT

data _null_;
 set have;
     file print;
     if _N_ = 1 then put "Country/Sex/Age";
     put country / Sex / Age;
end;

Re: Format issue

zimcom — Fri, 21 Aug 2020 15:09:30 GMT

I have other variables in the table as well, only want to combine the 3 avriables into one variable, how can I modify the code below:
if _N_ = 1 then put "Country/Sex/Age";
put country / Sex / Age;

Re: Format issue

ballardw — Fri, 21 Aug 2020 15:47:07 GMT

@zimcom wrote:
I have other variables in the table as well, only want to combine the 3 avriables into one variable, how can I modify the code below:
if _N_ = 1 then put "Country/Sex/Age";
put country / Sex / Age;

The show the variables in the example data and how they are supposed to appear in the output.

Re: Format issue

zimcom — Fri, 21 Aug 2020 15:55:14 GMT

Have

PID	Country	Sex	Age	Outcome
123	Canada	Female	89	Good
456	Canada	Male	62	Good
789	USA	Female	55	Best

Want

PID	Country/Sex/Age	Outcome
123	Canada Female 89	Good
456	Canada Male 62	Good
789	USA Female 55	Best

Re: Format issue

zimcom — Fri, 21 Aug 2020 16:39:09 GMT

Thank you very much!!

Re: Format issue

Shmuel — Fri, 21 Aug 2020 17:32:22 GMT

Adapting the code to desired output:

data _null_;
 set have;
     file print;
     if _N_ = 1 then put "PID   Country/Sex/Age   Outcome"; /* as labels */ 
     put        @5 country / 
        @1 PID  @5 Sex  @15 outcome / 
                @5  Age;
end;

each @ assigns the starting position of the vale, and / assigns new line.

Re: Format issue

zimcom — Fri, 21 Aug 2020 17:42:58 GMT

wgat would be the variable name for "Country/Sex/Age" then?

Re: Format issue

Cynthia_sas — Fri, 21 Aug 2020 18:05:09 GMT

Hi:

Here's a solution using PROC REPORT with the NEWLINE function and ODS ESCAPECHAR set to '^':

Hope this helps,

Cynthia

Re: Format issue

Shmuel — Fri, 21 Aug 2020 18:46:43 GMT

@zimcom wrote:
wgat would be the variable name for "Country/Sex/Age" then?

You asked for a report. With the method I used, there is no need to create a new variable, especially as y want to have them vertically, in the same column of the report.