topic transpose in Statistical Procedures

transpose

saza — Wed, 23 Feb 2022 21:00:28 GMT

Was asked the following question:

1) Reshape the data from long to wide according to the Date variable
(i.e., creating multiple new variables based on Date). Retain ID, LastName, and DOB 
on each line, and use the values in Event as the new variable names.

I thought I had it but when I use my code, nothing in the dataset seemed to change? There were still 100 rows like the original dataset

proc transpose data = covidlng.covidlong out = cohortwide prefix = Event;
	by id lastname dob;
	id event;
	var date;
	run;

what I see when I hit run

proc contents for OG dataset

proc contents for the cohort wide

Re: transpose

Reeza — Wed, 23 Feb 2022 20:31:06 GMT

Show the log and proc contents on each data set please.

Re: transpose

saza — Wed, 23 Feb 2022 20:40:07 GMT

Sure, added them to the original post

Re: transpose

Reeza — Wed, 23 Feb 2022 20:42:20 GMT

That's a proc print, not proc contents and for only one data set.

But your log shows that your output data set has 472 records not 100, are you sure you're checking the correct output data set?

Re: transpose

saza — Wed, 23 Feb 2022 21:01:06 GMT

I am sorry for the confusion on my end. Hopefully my update helps

Re: transpose

ballardw — Wed, 23 Feb 2022 21:34:47 GMT

What does your LOG look like? Copy the text from the log, open a text box on the forum using the </> icon above the message window and paste the text. Include the program statements and all the notes or messages from that code.

I ran your code on your data set and get 472 records in the output data set, which is the same as you show in the proc contents for the wide set. The original data set has 1416 observations. So I do not see where you are getting 100.

I suspect that perhaps you do not want to use PREFIX=EVENT has that makes the new variable names EVENT+the value of the event variable.

Re: transpose

Reeza — Wed, 23 Feb 2022 21:43:06 GMT

Your log and code and everything looks correct. What makes you think it's wrong?

Re: transpose

Reeza — Wed, 23 Feb 2022 21:44:00 GMT

I think SAS Studio only shows you the first 50 or 100 records by default, you need to press a button to see the rest of the records?