topic Output data conditionally from a file with multi-record per line in SAS Programming

Output data conditionally from a file with multi-record per line

Dennis_K — Thu, 11 Oct 2018 08:40:13 GMT

the following code will read multi observations per line.

data body_fat;
input Gender $ PercentFat @@;
datalines;
m 13.3 f 22
m 22 f 23.2
m 16 m 12
;
run;

how do i populate the data with only M patients?

Re: Output data conditionally from a file with multi-record per line

RW9 — Thu, 11 Oct 2018 08:47:46 GMT

Something like:

if gender="M" then output;

Re: Output data conditionally from a file with multi-record per line

Kurt_Bremser — Thu, 11 Oct 2018 08:47:59 GMT

Use a subsetting if:

data body_fat;
input Gender $ PercentFat @@;
if gender = 'm';
datalines;
m 13.3 f 22
m 22 f 23.2
m 16 m 12
;
run;

Re: Output data conditionally from a file with multi-record per line

Amir — Thu, 11 Oct 2018 08:53:24 GMT

Hi,

This looks a bit like homework. What have you tried so far? Share any code you have tried and show the log with any error messages.

If you haven't tried anything yet then try looking at the if statement documentation, which includes examples:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202239.htm

then you can post back your findings.

Regards,

Amir.

Re: Output data conditionally from a file with multi-record per line

Dennis_K — Thu, 11 Oct 2018 09:03:15 GMT

data mbody_fat fbody_fat;

input Gender $ PercentFat @@;

IF Gender='m' then
output mbody_fat;
else IF Gender='f' then
output fbody_fat;

datalines;
m 13.3 f 22
m 22 f 23.2
m 16 m 12
;
run;

Somehow the ELSE statement does not work

Re: Output data conditionally from a file with multi-record per line

Amir — Thu, 11 Oct 2018 09:14:20 GMT

Hi,

When I tried your code to split the genders, I had no apparent issues.

The M data set had 4 observations and the F data set had 2 observations.

NOTE: The data set WORK.MBODY_FAT has 4 observations and 2 variables.
NOTE: The data set WORK.FBODY_FAT has 2 observations and 2 variables.

What do you get or what were you expecting?

Regards,

Amir.

Re: Output data conditionally from a file with multi-record per line

Kurt_Bremser — Thu, 11 Oct 2018 09:14:35 GMT

@Dennis_K wrote:
data mbody_fat fbody_fat;

@input Gender $ PercentFat @@;

IF Gender='m' then
output mbody_fat;
else IF Gender='f' then
output fbody_fat;

datalines;
m 13.3 f 22
m 22 f 23.2
m 16 m 12
;
run;

Somehow the ELSE statement does not work

It does work, see this log:

27         data mbody_fat fbody_fat;
28         
29         input Gender $ PercentFat @@;
30         
31         IF Gender='m' then
32         output mbody_fat;
33         else IF Gender='f' then
34         output fbody_fat;
35         
36         datalines;

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.MBODY_FAT has 4 observations and 2 variables.
NOTE: The data set WORK.FBODY_FAT has 2 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      
40         ;

41         run;

I just copy/pasted your code and ran it.