@_maldini_ wrote:
And/or, could you please help me better understand what I need to do differently using the second approach? Include a PROC SQL and QUIT? Where?
SAS Proc SQL uses "standard" ANSI SQL syntax but needs to be told you are using it.
proc sql;
Create table sas_comm(seqn float, ever_used float, age_first_used float, monthly_yr float, age_monthly_use float, time_since_monthly_use float, time_since_monthly_use_unit float, times_month float, joints_pipes_day float, last_used float, last_use_unit float, days_past_month float, ever_told_chf float, age_told_chf float, ever_told_chd float, age_told_chd float, ever_told_angina float, age_told_angina float, ever_told_mi float, age_told_mi float, ever_told_stroke float, age_told_stroke float, ever_told_dm2 float, year float, gender float, age_yrs float, age_mos float, race_hisp_origin float, race_all float, educ_6_19 float, educ_gtet_20 float, mar_status float, wtint2yr float, wtmec2yr float, sdmvpsu float, sdmvstra float, hh_income float, family_income float, ever_etoh float, often_etoh float, etoh_days_per_wk float, etoh_use float, smk100_life float, start_smk_age float, smk_currently float, smk100_life_re float, smk_status float, flag_smk_status float, hdl_mg float, hdl_mmol float, tchol_mg float, tchol_mmol float, wtsaf2yr float, trigly_mg float, trigly_mmol float, ldl_mg float, ldl_mmol float, status_code float, weight float, weight_comment float, height float, height_comment float, bmi float, bp_comment float, sbp_1 float, dbp_1 float, sbp_2 float, dbp_2 float, sbp_3 float, dbp_3 float, sbp_4_if float, dbp_4_if float, mean_sbp float, mean_dbp float, htn float, rxddci1a_21 float, rxddci1a_22 float, rxddci1b_21 float, rxddci1b_22 float, ace float, bb float, ccb float, diur float, arbs float, htn_combo float, lipid_meds float, other float, htn_meds float, wtmec2yr_17_18 float, mos_since_last_use float, yrs_since_last_use float, mos_since_monthly_use float, yrs_since_monthly_use float, cann_use_status float, flag_cann_use_status float, cann_use_status2 float, flag_cann_use_status2 float, yrs_monthly_use float, flag_yrs_monthly_use float, pre_50_monthly_use float, age_first_used_cat float, flag_1 float, flag_2 float, flag_3 float, flag_4 float, flag_5 float, flag_6 float, non_hdl float, least_12_yr float, least_12_life float, often_past_yr float, often_past_yr_units float, etoh_days_per_wk_cont float, wtmec2yr_15_16 float, bp_status float, rxddci1a_23 float, rxddci1b_23 float, wtmec2yr_13_14 float, wtmec2yr_11_12 float, wtmec2yr_09_10 float, wtmec10yr_09_18 float);
Insert into sas_comm(seqn, ever_used, age_first_used, monthly_yr, age_monthly_use, time_since_monthly_use, time_since_monthly_use_unit, times_month, joints_pipes_day, last_used, last_use_unit, days_past_month, ever_told_chf, age_told_chf, ever_told_chd, age_told_chd, ever_told_angina, age_told_angina, ever_told_mi, age_told_mi, ever_told_stroke, age_told_stroke, ever_told_dm2, year, gender, age_yrs, age_mos, race_hisp_origin, race_all, educ_6_19, educ_gtet_20, mar_status, wtint2yr, wtmec2yr, sdmvpsu, sdmvstra, hh_income, family_income, ever_etoh, often_etoh, etoh_days_per_wk, etoh_use, smk100_life, start_smk_age, smk_currently, smk100_life_re, smk_status, flag_smk_status, hdl_mg, hdl_mmol, tchol_mg, tchol_mmol, wtsaf2yr, trigly_mg, trigly_mmol, ldl_mg, ldl_mmol, status_code, weight, weight_comment, height, height_comment, bmi, bp_comment, sbp_1, dbp_1, sbp_2, dbp_2, sbp_3, dbp_3, sbp_4_if, dbp_4_if, mean_sbp, mean_dbp, htn, rxddci1a_21, rxddci1a_22, rxddci1b_21, rxddci1b_22, ace, bb, ccb, diur, arbs, htn_combo, lipid_meds, other, htn_meds, wtmec2yr_17_18, mos_since_last_use, yrs_since_last_use, mos_since_monthly_use, yrs_since_monthly_use, cann_use_status, flag_cann_use_status, cann_use_status2, flag_cann_use_status2, yrs_monthly_use, flag_yrs_monthly_use, pre_50_monthly_use, age_first_used_cat, flag_1, flag_2, flag_3, flag_4, flag_5, flag_6, non_hdl, least_12_yr, least_12_life, often_past_yr, often_past_yr_units, etoh_days_per_wk_cont, wtmec2yr_15_16, bp_status, rxddci1a_23, rxddci1b_23, wtmec2yr_13_14, wtmec2yr_11_12, wtmec2yr_09_10, wtmec10yr_09_18) Values(51624, 1, 17, 2, ., ., ., ., ., 17, 4, ., 2, ., 2, ., 2, ., 2, ., 2, ., 2, ., ., ., ., ., ., ., ., ., ., ., ., ., ., ., 1, ., 0, 2, 1, 18, 3, 0, 2, 0, 50, 1.29, 135, 3.49, ., ., ., ., ., 1, 87.4, ., 164.7, ., 32.22, ., 114, 88, 114, 88, 112, 82, ., ., 113.333, 86.000, 1, ., ., ., ., 2, 2, 2, 2, 2, 2, 2, 2, 2, ., 204, 17, ., ., 2, 0, 2, 0, ., 1, 0, 0, 1, 0, 0, 0, 0, 1, ., 1, ., 0, ., 0.00000, ., 1, ., ., ., ., ., .);
quit;
The Proc, as is typical in SAS comes as the first thing, then statements. The procedure ends with the Quit; statement.
Note the text box for the code. One thing that can be very important with data step or similar code is that the forum software will reformat text pasted into the main message window and sometimes results in code that generates errors when we copy/paste into a SAS session and attempt to run the code.
Reducing the variables to just what is needed might be the solution for the problems you might have encountered with the create data. Since it is creating text you might not see everything clearly when lots of not-needed-for-this-question variables are included.
Note that there is another form of INPUT that is called name input that can take text such as your PUTLOG output, though use of character variables may get tricky:
data example;
input race_all= gender= htn_meds= smk_status= ever_told_dm2= age_yrs= ;
datalines;
race_all=3 gender=2 htn_meds=1 smk_status=1 ever_told_dm2=1 age_yrs=40
race_all=4 gender=2 htn_meds=1 smk_status=1 ever_told_dm2=1 age_yrs=45
;
The = after the variable name says that SAS expects to see values with the variable name followed by an = sign then the value in the data source.
Hint: when using something like PUT or PUTLOG to examine results it is a good idea to include the dependent variables used in the calculations such as your tchol_mg and hdl_mg variables. If you find that those variables are missing then you should expect to get missing results for the calculated variables.
Also Putting calculated variables such as cauc_f_age before they are calculated is a waste of electrons. Put those variables AFTER the statements that should calculate them.
