Hi all,   I'm having some issues with the below code and datasets. I am trying to use a proc sql left join to bring the two datasets together with a new variable, but when I do it adds an extra two from the second dataset instead of only joining to the two already existing in the first dataset. Code and pictures of the three datasets in order below. Thank you in advance for the help!   proc sql; create table eligs as select a. * , b. x_dupIPelig label = "Match with other Elig" as eligIP_flag from eligIP2 a left join eligIPdups b on a.screener_ID = b.screener_ID; quit;   eligIP2: Eligipdups:   Eligs(Created dataset):       ... View more

Title says it. I'm trying to create a program to add a password to an excel file using SAS but haven't been able to get it to work today. It worked a couple of weeks ago but I cant remember how or if I changed anything. Any ideas? Also an explanation of how it works would be great as well. Thanks!   %let ExcelFile = H:\Password Code Test\Password Code Test 4.xlsx; %let VBscript = H:\convert.vbs; %let password=test; data _null_; file "&vbscript" lrecl=200; put 'Dim xlApp, xlWkb, SourceFile, TargetFile'; put 'Set xlApp = CreateObject("excel.application")'; put 'SourceFile="' "&ExcelFile" '"'; put 'Set xlWkb = xlApp.Workbooks.Open(SourceFile)'; put 'TargetFile="' "&ExcelFile" '"'; put 'xlApp.DisplayAlerts=false'; put "xlWkb.SaveAs TargetFile, 51,""&password"""; put 'xlApp.DisplayAlerts=true'; put 'xlWkb.close'; run; options noxwait noxsync; x "cscript ""&vbscript"""; ... View more

Hi all,   I'm trying to do an interaction assessment for a dataset I have using dummy variables coded as different smoking statuses and a lifestyle score I have been using. However, when I try to multiply these together to create a variable to use in the analysis, no values are created. Both variables are numerical with the score ranging from 5-25 and the dummy variables being coded as 0/1. Code posted below:    ecl_nonsmoke = ecl2_score*dummy_nosmoke; ecl_cursmoke = ecl2_score*dummy_cursmoke; ecl_forsmoke = ecl2_score*dummy_forsmoke;   The proc freq I run afterwards shows that all values for the newly created variables are missing, even though all the observations in the dataset have values for the score and the dummy variables used in the calculation. Any ideas why this could be happening? Thanks! ... View more

Hi there,   I'm trying to make a new variable that will convert a variable to a new variable representing packs of cigarettes smoked per week and am having some issues. I have run this code several times and checked the log and it has no errors, but for some reason when I run a proc freq on it it only gives shows me the values for values that were already in cigarettes/week values.    Some context. The original variables (q6_4 and q6_10)  were coded as follows:   The first digit of the answer identifies the unit (1 represent day, 2 represent week, etc.), the next two digits was the number smoked during that unit of time frame. This is coded as a categorical variable.   _ _ _      Enter number of cigarettes                          1 pack = 20 cigarettes   101 ‑ 199            Number per day 201 ‑ 299            Number per week 301 ‑ 399            Number per month 401 ‑ 499            Number per year 888                                    Don't Know/Not Sure 999                                    Refused   What I tried to do is convert them to numeric, and then use that numerical variable to calculate packs smoked per week for all the individuals who smoke any amount of cigarettes. Calculations are as follows   Convert cigarettes/day to cigarettes/week: (cigarettes/day)*7 Convert cigarettes/month to cigarettes/week: (cigarettes/month)/4.345 (4.345 weeks in a month on average) Convert cigarettes/year to cigarettes/week: (cigarettes/year)/52   The code I am using is below:   *Convert smoking variables to numeric; if q6_4 ne "" and smoke_stat = 1 then numerical_smoke = input(q6_4, 4.); else if q6_10 ne "" and smoke_stat = 1 then numerical_smoke = input(q6_10, 4.); else numerical_smoke = 0;   *Make variable for current packs per week at baseline; if numerical_smoke gt 100 and numerical_smoke lt 200 then cig_perweek = ((numerical_smoke - 100)*7); else if numerical_smoke gt 200 and numerical_smoke lt 300 then cig_perweek = (numerical_smoke - 200); else if numerical_smoke gt 300 and numerical_smoke lt 400 then cig_perweek = ((numerical_smoke - 300)/4.345); else if numerical_smoke gt 400 and numerical_smoke lt 500 then cig_perweek = ((numerical_smoke - 400)/52); else cig_perweek = 0;   *Create pack per week variable; pack_perweek = cig_perweek/20;   I honestly don't know why it won't show me the full range of values I've asked for. Any ideas?   Thanks!     ... View more