Hello,   I have a dataset that looks like this. There are indicator variables for the purchase of each brand, for each brand display and each brand feature. There's also the price for each brand in each observation.  The data set that I want looks like. Each subject will be split into 4 observations, one for each brand.  obs OBS Purchase Brand Feature Display Price 1 1 0 Private  0 0 0.709999979 2 1 0 Keebler 0 0 0.980000019 3 1 1 Nabisco 0 0 0.879999995 4 1 0 Sunshine 0 0 1.199999928   Essentially it's a wide to long transformation and I believe I need to merge the certain variables. So far I've been trying to use proc transpose, in several different ways. One example being :  proc transpose data=HW5.crackers_hw5; var DisplKeebler DisplNabisco DisplPrivate DisplSunshine FeatKeebler FeatNabisco FeatPrivate FeatSunshine; by obs KEEBLER NABISCO PRIVATE SUNSHINE; run; My first question is, how do I merge the indicator variables appropriately? Secondly, what would be the best way to manipulate proc transpose to get this data set?   Thank you   ... View more

Hello All,   I have a data set that looks like this  As you can see obs are on the far left, the following four columns represent whether or not a specific brand was purchased. The next four columns represent prices, the next eight columns indicate whether or not a display and feature was used for each brand.     I would like to do an alternative specific regression in this context to represent each brand. Would the best data structure in this case be to sort and organize observations by brand purchase? Essentially, should I lump all the observations together where the purchase of nabisco is 1, for example?   Thank you! ... View more

Hi everyone,   I'm trying to create a graph, that delineates everything by year. proc sgplot data=HW2.earthquakes(where=(year >= 2000)); XAXIS interval = year; Scatter X = year Y = magnitude; Title 'Magnitude of Earthquakes occuring in 2000 and beyond'; run; When I run this code, I wind up with up with a graph that still shows ticks in two year increments.   How do I get it to show a tick for every year? ... View more

I'm trying to libname with a data infile statement, to avoid storing everything in work. I tried the following code, but it didn't work.  libname Swine 'C:\sally';run; Data Swineflu; Infile 'C:\sally\SwineFlu2009.dat' dsd dlm='09'x missover; input First_Case_ID Case_Continent_ID Country $ First_Case_Date April_Cases May_Cases June_Cases July_Cases August_Cases Last_Cases_August9 First_Death_ID Death_Continent_ID First_Death_Date May_Deaths June_Deaths July_Deaths August_Deaths September_Deaths October_Deaths November_Deaths December_Deaths ; proc print data=Swine.Swineflu; run; Thank you! ... View more