About lstockman

lstockman · ‎01-07-2019

fixed it - great solution, thanks.

lstockman · ‎01-07-2019

Thanks! This works too but for some reason the table appears twice before it adds the caption at the bottom. I'll look into it a bit.

lstockman · ‎01-07-2019

Thanks! That works.

lstockman · ‎01-07-2019

Hello, I'd like to add a caption under the table that results from this statement. A footnote is too far down the page. Thanks for any suggestions! ODS PDF file="&savepathrep.\Table_1994_2017_&val._&filedate..pdf" STYLE=styles.analysis; proc tabulate data=have missing classdata=dummy.dummyyr; where lhj="&val"; class count vitalstat year; table year*f=comma8.0 all*f=comma8.0, count*f=comma8.0 vitalstat*f=comma8.0 /misstext='0' printmiss box="&val"; label year='Year of Report' count='Confirmed Cases' vitalstat='Vital Status'; keylabel all='Total 1994-2017'; Title 'Title of Table Here'; run; ODS PDF close;

lstockman · ‎01-04-2019

That worked perfectly. Thank you!

lstockman · ‎01-04-2019

Thank you @PaigeMiller!

lstockman · ‎01-04-2019

Thank you @Kurt_Bremser ! This works and is so much faster! Do you know if there is a statement I can add to retain the variable names as the first row in the resulting csv files?

lstockman · ‎01-03-2019

Thanks, that works for some things and is very helpful to know. In my code below, the where statement is working but the output dataset is only the first word of the county i.e. work.want_los and work.want_san. Makes sense as I don't think an output dataset can have a space (?) Ultimately, I want to output a .csv or .xls file for each county in my list. Can I do that without first making individual datasets for each?

lstockman · ‎01-03-2019

Hello, I have a list of counties that have spaces in their names. Rather than change all the spaces to underscores or remove them, is there a way I can format the list so the macro will run with the original value? Here is the code I am trying to pass the macro 'list' through to create a file for each county in my list. %macro loopit(lhjlist); %let n = %sysfunc(countw(&lhjlist)); %do I=1 %to &n; %let val = %scan(&lhjlist,&I); data want_&val; set have; where county= "&val"; run; %end; %mend; %let list= LOS ANGELES CONTRA COSTA SAN DIEGO ; %loopit(&list);

lstockman · ‎12-20-2018

Thanks ballardw! I have the ucod.txt doc, and am trying to work with it. NCHS has stripped out the E and the decimal in the data I have so external codes are reported beginning with 800. I will consider the 4th digit. Was hoping to find the same info in the txt doc in a more usable format.

lstockman · ‎12-19-2018

Hi all, Does anyone have a proc format statement that assigns the cause of death description the three-digit ICD-9 code? I have this for ICD-9-CM (hospitalization data) but looking specifically for ICD-9 for Mortality. Thank you!

lstockman · ‎11-20-2018

Thank you. Unfortunately, the tmonth calculation is not working quite right. I would like the tmonth calculation to be the difference in months between each test_date and the previous test_date. Then if tmonth <=6 months then new_var=1. Does anyone know a modification? Also the code provided is outputting multiple rows for each ID.

lstockman · ‎11-15-2018

Hi! There are no missing or null values within completed values in test_date. So if there are three tests, then test_date1, test_date2, and test_date3 will all have values. I don’t have a good starting point for the 6-month period, this is my problem. If test_date1 is in 2012 but the test_date2 and test_date3 both occur in 2014 and 6 months or less apart, I want to flag the record as meeting the criteria.

lstockman · ‎11-15-2018

Hello - I have a dataset of test dates for each record in sequential order, earliest to latest. Some records have data in up to 300 columns (i.e. test_date1...test_date300), some have only one. I need to add a new variable 'new_var' that indicates if there are two test_dates within a 6 month timespan. Does anyone have suggestions of an array that would calculate the span of time between the first test_date and the last test_date and then count if there are two dates, if there are new_var='Y'. Some sample data if useful. data labs; input ID $ test_date1 test_date2 test_date3 test_date4 test_date5; datalines; 101 08192010 . . . . . 102 01192010 01192010 11272014 07262016 09272016 103 02192011 02192013 12272014 . . ; run; Thank you!

Online Status	Offline
Date Last Visited	‎09-22-2020 02:20 PM

Re: How do I add a caption with proc tabulate and ODS PDF

Re: How do I add a caption with proc tabulate and ODS PDF

Re: How do I add a caption with proc tabulate and ODS PDF

How do I add a caption with proc tabulate and ODS PDF

Re: How to handle spaces in a macro variable list

Re: How to handle spaces in a macro variable list

Re: How to handle spaces in a macro variable list

Re: How to handle spaces in a macro variable list

How to handle spaces in a macro variable list

Re: Looking for format for ICD-9 mortality codes

Re: How do I add a caption with proc tabulate and ODS PDF

Re: How to handle spaces in a macro variable list

Re: How do I add a caption with proc tabulate and ODS PDF

Re: How do I add a caption with proc tabulate and ODS PDF

Re: How do I add a caption with proc tabulate and ODS PDF

How do I add a caption with proc tabulate and ODS PDF

Re: How to handle spaces in a macro variable list

Re: How to handle spaces in a macro variable list

Re: How to handle spaces in a macro variable list

Re: How to handle spaces in a macro variable list

How to handle spaces in a macro variable list

Re: Looking for format for ICD-9 mortality codes

Looking for format for ICD-9 mortality codes

Re: Difference between dates across columns

Re: Difference between dates across columns

Difference between dates across columns