Hello All,    I am trying to transpose some stock data that I generated in R. There are two entries for one stock symbol, I will attach the photo so that you may be able to understand better what I am saying. All I want is one row, not two, for each stock symbol.    I have tried this  proc transpose data=pa.regression_stats out=pa.transposed_data; by Var; var estimate p_value statistic std_error; run; But it does the exact opposite of what I want, converting it into four rows instead of two      ... View more

Hi all,  Do I really have to put the dollar sign in every time to make this data a character value?    data learn.survey; infile '/folders/myfolders/71442_example/survey.txt'; input Subject_Id Gender $ Age Salary Ques1 $ Ques2 $ Ques3 $ Ques4 $ Ques5 $; label subject_id = "Subject ID" Age = "Age as of 1/1/2006" Salary = "Yearly Salary" Ques1 = "The governor doing a good job" Ques2 = "The property tax should be lowered" Ques3 = "Guns should be banned" Ques5 = "The schools need to be expanded" ; run; Because this will not work    data learn.survey; infile '/folders/myfolders/71442_example/survey.txt'; input Subject_Id Gender $ Age Salary Ques1-Ques5 $; label subject_id = "Subject ID" Age = "Age as of 1/1/2006" Salary = "Yearly Salary" Ques1 = "The governor doing a good job" Ques2 = "The property tax should be lowered" Ques3 = "Guns should be banned" Ques5 = "The schools need to be expanded" ; run; ... View more

Hello,   I was trying to do one of the chapter homework problems for the book mentioned above and the website listed for the datasets is support.sas.com/cody  There I was able to find my book and download the zip file for the book. It seems as if there isn't the file Colleges dataset though. This is the only dataset that is used in the chapter test so it is impossible to practice. I know that this is more so a question for the publisher but I was unable to contact anyone from SAS directly since it is the weekend.   I was just wondering if anyone had the dataset or if they experienced the same problem. This is the link for the zipfile https://support.sas.com/downloads/package.htm?pid=2238   Any help would be appreciated   Thanks  ... View more

Why doesn't the below replace the old character value with the right numeric? I have seen the solution in my textbook but I still don't understand as to why I need to name a new array in order to get numeric values for the four variables? The variable subject{I} should be converted to numeric with the input function, there shouldn't be a necessity to make a whole new array no? Wrong data quiz.cleaned; set quiz.all_score; array subject{4} read math science write; do I= 1 to dim(subject); if subject{I} = 'missing' then subject{i} = ''; subject{I} = input(subject{I}, 30.); end; run; Right data quiz.cleaned2; set quiz.all_score; array subject{4} read math science write; array subject_2{4} readN mathN scienceN writeN; do I= 1 to dim(subject); if subject{I} = 'missing' then subject{i} = ''; subject_2{I} = subject{I} * 1; end; run; ... View more

Hi All,   Just trying to see if there is a way to search for missing characters within this list. When I output the data, take still comes out to be complete even if there is a missing value in score 2. I thought the syntax below but I guess missing() only returns for one variable because when I run the data the only one that will come out incomplete when there is a missing score is score 1. What do I have to do in order to just search multiple variables? I know the easy answer would just be to do an OR clause but let's assume there are tons of scores. would it really be necessary to right 20 different OR's?       data udemy.scoredata_all; set udemy.score_data; if not missing(score1-score3) then take = 'complete'; else take = 'incomplete'; run;   Best,  Jake    ... View more

Hello,   I have currently been following with Learning SAS by Example book and for some reason when I type in the program   title "Listing All the Sas data sets in a library; proc contents data=sashelp._all_nods; run;   I get an error saying ERROR: File SASHELP._ALL_NODS.DATA does not exist. which obviously isn't true, I have tried it with numerous other libraries but keep getting the same error.    ... View more