Hi,    I've a message error and i don't find the cause, I think maybe it's some configuration. I'm doing a proc reg and i need to have the residuals in a dataset. But the first time i run the program the dataset 'prevrest' is not generated and the second time i run the program, i see the dataset in work librery but when i try to open i have the message of the picture.  I found here another post about the problem but the solution was 'restart' the pc and i tried that but the problem persists.   The problem is with SAS 9.4, I have executed exactly the same code in entreprise guide and that works fine.   Somebody could help me ?    Thanks very much ! Lucia    data house ; set "D:\Users\lucia\Documentos\housing"; prix_au_feet2 = price / lotsize ; run ; proc reg data=house ; model price = lotsize bathrms ; output out=prevrest p=prev r=res ; run ; ... View more

Hi,    I post this question because i didn't find the answer in internet. I did a multiple linear regression and i would want to show the regression line and observated valus fit, but i don't know how to do this for multiple variables.   I tried this but i have error messages .   proc reg data=house_decile lineprinter outest=residus_decile plots=fitplot ; model price = (lotsize bedrooms bathrms) ; output out=prevres p=prev r=res ; run ; Somebody knows how is the correct syntax ?   Thanks you very much ! ... View more

Hi !   I need to create several datasets with a SAS’s Macro but I could not do it. I have a dataset with “I” variables group by variable “j” and i get many statistics for each one with Proc Means. At the end, I have for each variable j value,  i datasets with one variable and one observation, like this :   J=1         Dataset 1,1 Dataset 1,2 Dataset 1,3 …. Dataset 1,i Mean_11 Mean_12 Mean_13   Mean_1i 5,5 8 45   12           J=2         Dataset 2,1 Dataset 2,2   …. Dataset 2,i Mean_21 Mean_22 Mean_23   Mean_2i 87 85 4   65  ...          ...         J=j         Dataset j,1 Dataset j,2   …. Dataset j,i Mean_j1 Mean_j2     Mean_ji 15 5     23   I need to create only one table with all  of one variable’s datasets for each j value group. Something like that : Dataset j=1, Mean_11 Mean_12 Mean_13   Mean_1i 5,5 8 45   12     I tried that but it do not work:   %let j=1 ; %macro all; data test_t&j ; set %do i=1 %to 10 ; mean_&j&i sum_&j&i %end ; run ; %mend ; %all; Could somebody help me please to find where I have wrong ? There is a way to do a DO loop for the value of j to avoid making a macro for each value of j ?   Thank you very much !   ... View more

Hi !  I have a Sas new user’s question. I have a dataset with this structure and I want to get the number of repetitions of the max value for each Vle_a’s value.   Vle_a Vle_b A 5 A 10 A 9 A 8 A 10 A 2 A 10 B 9 B 1 B 3 B 9     I need to get a dataset like this :   Vle_a Nb_repetitions A 3 B 2     I tried this code with proc freq but does not consider the max value and I get the number of observation for each Vle_a’s value.   proc freq data=test noprint; tables vle_a / NOCOL NOROW NOPERCENT OUT=want; by vle_a ; where vle_b = max(vle_b); run ; I could do that whit proc sql but I would prefer to do it with a data step.   Somebody could help me please ?   Thank you very much !   Best regards Lucia   ... View more