topic Re: transpose and get the long data keeping the same variables. in SAS Data Science

transpose and get the long data keeping the same variables.

Decay2020 — Fri, 16 Jul 2021 08:08:16 GMT

Hi, I have below two tables. i want to populate the column ' Value' on the basis of 'previous year' and 'current year'. For example, A+ and A should have 20 as its value.

Now when the table1 is imported in SAS, SAS autmoatically rename the variable name, B- will become B_. Even if i import the data without renaming as per sas, it asks for sorting it while doing the transpose by grade.

Is there any way to go about this? Main goal is to populate 'value' using previous and current year.

grade	A+	A	B-
A+	22	20	20
A	24	27	26
B-	26	34	32

previous year	current year	Value
A+	A	?
A	B-	?
B-	A+	?

Re: transpose and get the long data keeping the same variables.

andreas_lds — Fri, 16 Jul 2021 09:58:26 GMT

Is this a data mining question?

You are talking about "previous and current year" but i don't see a variable named "year" in your table. Start by posting the data you have in usable form, then show the expected results and explain the rules to be applied.

Re: transpose and get the long data keeping the same variables.

Decay2020 — Fri, 16 Jul 2021 11:34:05 GMT

row head is previous year and column head is current year.

Re: transpose and get the long data keeping the same variables.

ballardw — Fri, 16 Jul 2021 16:40:53 GMT

Time to start posting data examples in the form of a data step as shown in several responses to basically this exact same question in several of your other posts.

Make sure that any requirement like "previous year" or "current year" is either available from the variable names or details in the request.

Re: transpose and get the long data keeping the same variables.

Tom — Fri, 16 Jul 2021 15:14:10 GMT

So you have posted two html tables (or spreadsheet tables) and not SAS datasets.

What does your actual SAS data look like? What are the names of the variables? How are they defined (numeric or character: if character maximum length: are any special formats like DATE or TIME applied?).

The first table you posted looks like a report you could generate from data that you have collected in the format like the second table you posted.

If you don't have the data in SAS yet then what format is it in now? Text file? Something else?