topic Re: Creating a variable to count occurences in SAS Programming

Creating a variable to count occurences

nickc10 — Wed, 30 Nov 2016 04:01:47 GMT

I have a data set that have 48 temperatures that correspond to two 24 hour days. I want to create a variable that is 1 if it occurs in the first day and 2 if it occurs in the second. I used a do loop to create the Hour variable.

data temps

set hot;

    do Hours=1 to 24;
   input temp@@;
       output;
   end;
run;

Re: Creating a variable to count occurences

PGStats — Wed, 30 Nov 2016 04:06:48 GMT

What is the structure of dataset hot?

Re: Creating a variable to count occurences

mkeintz — Wed, 30 Nov 2016 04:07:49 GMT

Are you reading SAS data from sas dataset HOT? If so you don't need the INPUT statement which is intended to read raw data.

So lets assume you have 48 obs, i.e. 24 for day 1 and 24 for day 2.

Then you could do this:

data temps;

set hot;

if _n_<=24 then day=1;

else day=2;

run;

The automatic variable _N_ above is the iteration number of the data set, which corresponds in this case to the observation number.

Re: Creating a variable to count occurences

nickc10 — Wed, 30 Nov 2016 04:14:49 GMT

I was reading in a raw text file, but to save space and some personal details I subsituted the path for 'HOT.' I initially tried to use the _N_ for this, but I can't seem to get it to work correctly with the do loop. Any ideas?

Re: Creating a variable to count occurences

nickc10 — Wed, 30 Nov 2016 04:16:08 GMT

It is a raw text file read in. I subsituted the actual pathway for 'HOT.'

Re: Creating a variable to count occurences

mkeintz — Wed, 30 Nov 2016 04:23:06 GMT

Reading raw data? In that case;

data want;

infile '....... path to raw data of temps ';

do day=1 to 2;

do hour=1 to 24;

input temp @@;

output;

end;

run;

Re: Creating a variable to count occurences

PGStats — Wed, 30 Nov 2016 04:23:46 GMT

Something like this?

data temps;
    infile "path\myHotFile.txt";
	do day = 1, 2;
		do Hour=1 to 24;
			input temp@@;
			output;
			end;
		end;
run;

Re: Creating a variable to count occurences

nickc10 — Wed, 30 Nov 2016 04:25:47 GMT

Perfect! Thanks so much!

Re: Creating a variable to count occurences

nickc10 — Wed, 30 Nov 2016 04:26:43 GMT

Awesome! Thanks for the help!