Hello everyone,    I have been looking for some way to transpose data that contains which months certain individuals participated and how this can be turned into a readable table.  the data is currently like this ID       Month 01      JUN 02      MAY 02      JUN 03      APR 03      MAY 03      JUL 03      AUG 04      AUG 04      SEP 04      OCT   and i want it to look like this: ID       APR     MAY    JUN    JUL    AUG     SEP       OCT 01                                X 02                      X       X 03          X         X                   X        X 04                                                      X           X             X   Is this possible with proc transpose or with some other proc in SAS?    thanks!   ... View more

Hi Everyone,    i need to figure out how to loop through a list of numbers using a macro/do loop. I have tried the same approach as a list of variables but that doesn't seem to work at all. I need to run the code for a set of clinic numbers but don't want to have to change the clinic number and run it a million times if it can be avoided.    thanks!   cat    %macro doit(list); %let n=%sysfunc(countw(&list)); %do i=1 %to &n; %let val = %scan(&list,&i); %mend; %doit(124 70 76 57 79 221); proc sql; CONNECT to odbc(dsn=dbwh); CREATE TABLE bftest as SELECT * from connection to odbc ( SELECT P.FileDate, CLINICID, SUM( Mo0Count) as Mo0Count1, Mo0CountTotal, R.PACKET, CASE WHEN convert(float, Mo0CountTotal) > 0 THEN SUM(Mo0Count) / convert(float, Mo0CountTotal) ELSE 0 END as Mo0FEEDPercent FROM dbo.BreastfeedingEthnicity as P JOIN dbo.Dates D ON p.FileDate = D.DateText JOIN (SELECT *, CASE WHEN PGLABEL = 'IB -BF Fully' THEN 'FullyBF' WHEN PGLABEL = 'IF -Formula' THEN 'FORMULA' WHEN PGLABEL IN ('IC -BF Mostly', 'IO -BF Some') THEN 'MOSTSOME' ELSE '' END AS PACKET FROM dbo.PacketGroupReference) as R ON P.PacketGroup = R.PacketGroup JOIN ( SELECT FileDate, SUM(Mo0Count) as Mo0CountTotal FROM dbo.BreastfeedingEthnicity as P WHERE FileDate >= '2017-10' AND AgencyID = 314 AND ClinicID = %doit GROUP BY CLINICID, FILEDATE ) as T ON P.FileDate = T.FileDate WHERE P.FileDate >= '2017-10' AND AGENCYID =314 AND CLINICID = %doit GROUP BY CLINICID, P.FileDate, Mo0CountTotal, PACKET ORDER BY CLINICID, P.FILEDATE ); %end; quit; ... View more

Hello,    I am trying to do a multilinear regression of income data as the outcome with disability as the main predictor and controlling for confounding of age education and gender. the income data is from two different years where i am trying to see if there have been any improvements or socioeconomic gains for people with disabilities. In order to look at this from a more relative angle, it was suggested that i convert the income data into centiles (100 by 1)  and use linear regression. However, i am running into issues because the income data includes negative and 0 income values which we do not wish to take out but analyze all together. These are being grouped into one centile which makes the data skewed when running the regression analysis. Is there any ideas on how this data should be analyzed instead. there is a weight for the data however this is not helping meet the assumption of normality.    proc rank data=incdis groups=100 out=cent_incdis ; var atinc42; ranks atinc42_centile; by year; run; proc surveyreg data=cent_incdis; class ecsex99_n (ref='0') education (ref='0'); model atinc42_centile = disabs26_n ecsex99_n education ecage26 / solution; weight icswt26; run;   ... View more

Hello everyone,    I currently have a dataset where we assign a sequential number as the hidden ID to protect our pariticipants data when sharing information. Some participants have been assigned a hidden ID (sequential) in previous years and I can just the file updated with this already existing hidden ID. This dataset used to be housed as a SQLserver data table where the Identity column could easily but updated with new participants each year. I am turning into a SAS data file where I will be continuously adding new participants each year we receive new data. Is there any code in SAS that would allow me to assign the participants their already existing "hidden ID"  as well as continue the sequence with newly added participants.    this is the code i am currently using however i know that the code for those that are completely brand new is not correct to continue the sequence. individualID is the actual ID they are assigned and individual code is the hidden ID i need to assign as a sequential number for new participants.     data individualhidingcodes(keep=individualid individualcode) ; merge individualhidden(in=a) individuals2018(in=b); by individualid; if a and b then individualcode=individualcode; if b and not a then individualcode=individualcode+1; run; this is a sample of how the current hidden code table looks: IndividualID       Individualcode hg111                    746589 hg112                    746590 hg113                    746591 ...   This table i am attempting to merge is like so: IndividualID  hg129 hg111  *\ these that are the same in both tables would be assigned the same individual code from above*\ hg113 hg178  *\ the new IDs that have never been assigned a hidden code in previous years would need to continue from where the sequence left off in the other table *\   Thank you for all your help with this!     ... View more