About marleeakerson

marleeakerson · ‎03-05-2021

Thank you! Given this information - do you know how to add a timestamp variable?

marleeakerson · ‎03-05-2021

I have attached the original file from the CDC website.

marleeakerson · ‎03-05-2021

COVID-19 Vaccinations in Long Term Care Facilities Date generated: Tue Mar 02 2021 14:44:45 GMT-0700 (Mountain Standard Time) State/Territory Total LTC Doses Adminstered People in LTC with 1+ Doses People in LTC with 2 Doses Alabama 77434 48746 28403 Alaska 6346 4192 2131 American Samoa N/A N/A N/A Arizona 102230 75263 26624 Arkansas 28084 18858 9129 California 743328 469515 270387 Colorado 124448 81007 42850 Connecticut 128606 77042 50792 Delaware 35133 24151 10767 District of Columbia 7678 5274 2295 Federated States of Micronesia N/A N/A N/A Florida 385199 234959 147605 Georgia 116804 71915 44195 Guam N/A N/A N/A Hawaii 21657 13875 7768 Idaho 26324 16282 9963 Illinois 390482 274369 114992 Indiana 123351 79432 43647 Iowa 134635 89229 44581 Kansas 87541 54817 32493 Kentucky 92607 62913 29262 Louisiana 105803 73451 31893 Maine 36308 23189 13038 Marshall Islands N/A N/A N/A Maryland 159639 108419 50136 Massachusetts 300678 181899 117069 Michigan 253356 172716 79545 Minnesota 155038 104952 49524 Mississippi 50049 31749 18108 Missouri 142315 93900 47998 Montana 20684 13563 7087 Nebraska 56505 37532 18817 Nevada 71827 51292 20295 New Hampshire 46428 27909 18332 New Jersey 230338 143660 85498 New Mexico 36874 25124 11503 New York State 388955 248250 136929 North Carolina 203098 141124 60888 North Dakota 6461 3616 2815 Northern Mariana Islands N/A N/A N/A Ohio 349179 226999 119284 Oklahoma 63105 43196 19580 Oregon 108865 70605 38066 Pennsylvania 389781 232318 155200 Puerto Rico 70055 52079 17942 Republic of Palau N/A N/A N/A Rhode Island 47554 29677 17699 South Carolina 96850 63177 33061 South Dakota 12416 8486 3919 Tennessee 95696 66131 29281 Texas 448036 280652 164563 Utah 54398 34541 19605 Vermont 20370 13036 7255 Virgin Islands N/A N/A N/A Virginia 197850 120465 75517 Washington 145539 98350 46488 West Virginia N/A N/A N/A Wisconsin 149935 110821 38762 Wyoming 6652 3876 2755

marleeakerson · ‎03-05-2021

Hello, I am trying to capture a time stamp while importing a CSV file. The raw data looks like: the time stamp i am trying to capture is the "Tue Mar 02 2021 14:44:45 GMT-0700" from line 2. But I don't want another information from the first three lines. I need the data to start at line 5. Ideally, I would like to add a new variable called 'TimeStamp' that captures the time stamp from line 2. M current code looks like: data vacc_ltc ; infile "filepath" dsd truncover firstobs=5; input State :$20. Total_LTC_Doses_Adminstered :20. Dose1 :20. Dose2 :20. ; run; Any advice on how to add in that time stamp?

marleeakerson · ‎03-03-2021

Thanks for replying! Unfortunately, that does not work. The data looks like this after that switch: I need the data that is in line 1 to be the column headers

marleeakerson · ‎03-03-2021

Hello, I am trying to import a CSV file using this code: proc import datafile="filepath" out=vacc_us dbms=csv replace; getnames=yes; datarow=5; the raw file looks like this: So want row 4 to be the column headers and the data to start at row 5. I essentially want rows 1,2 and 3 deleted. But the code I used doesn't quite work for this. I have tried using getnames=no; datarow=4; and some other combinations but it never works out with the right column headers. Any advice?

marleeakerson · ‎02-01-2021

Hello, I am having some trouble with date formatting. I am inputting a table that has a date variable that looks like this: But when I try to format it using this code: format cp_createdat MMDDYY10. ; I get this in the output table: Does anyone why this is/how to fix it? I am hoping to format this variable to be in the MM/DD/YYYY format. Thank you!

marleeakerson · ‎02-01-2021

Hello, I am trying to group by age and use the sums of the groups. For instance, if I am using this data table: Age Users 17 1 18 2 19 5 20 3 21 9 22 9 23 2 24 5 25 3 26 2 I want to make a new table that groups the age groups by three years and uses the sum of the 'users' variable for that age group. So the output table would look like: Age_group Users 17-20 8 21-23 20 24-26 10 Does anyone know how to help write the code for this?

marleeakerson · ‎11-24-2020

Hello, I need some helping making a table. Taking the sample data: CountyCode Code Score 1 1 2 1 1 2 2 1 2 2 2 3 I want to create a table that looks something like this CountyCode County_Cnt Code_1 Code_2 Score_2 Score_3 1 2 2 0 2 0 2 2 1 1 1 1 So I want a summary table based on the count of observations in each county (countycode) and the sum of the different codes and scores within that county. I think the easiest way to do this would be in proc SQL but I am not sure. Is there an easy way to do this (assuming there are multiple codes and multiple scores for each countycode? Thank you!

marleeakerson · ‎11-23-2020

Hello, I am trying to run a basic libname statement and I keep getting this error: libname ows "X:\Temp\DRS\project"; NOTE: Writing HTML5(EGHTML) Body file: EGHTML libname ows "X:\Temp\DRS\project; NOTE: Library OWS does not exist. Any ideas? This should be a really simple piece of code to run but it isn't running for some reason

marleeakerson · ‎11-05-2020

Hello, Using this sample data: ID Code 1 A 1 B 1 C 2 A 2 B 3 A 3 B 3 C I am trying to create a new table that pulls observations where an ID has both Code 'A' and Code 'C' associated with it. So the final data would look like: ID Code 1 A 1 B 1 C 3 A 3 B 3 C Thank you!

marleeakerson · ‎11-02-2020

I am trying to merge Data1 with Data2. Data1 has a bunch of variables, including claim_numb. Data2 has only two variables, Date_Begin_Service_Header and claim_numb. I am trying to merge the two tables so I have Data3, which has all the claim_numb from Data1 matched with the Date_Begin_Service_Header variable from Data2. But when I merge, the Date_Begin_Service_Header variable is blank.

marleeakerson · ‎11-02-2020

Hello, I am trying to merge two data sets based on claim_numb, but when I do, the Date_Begin_Service_Header variable ends up blank, even though it is completely filled out in data2. Any advice? proc sort data=data1; by Claim_Numb; run; data data2; set file1(keep=Date_Begin_Service_Header claim_numb) file2 (keep=Date_Begin_Service_Header claim_numb); run; proc sort data=data2; by Claim_Numb; run; data data3; merge data1 (in=a) data2 (in=b) ; by Claim_Numb; if a; run;

marleeakerson · ‎10-21-2020

Hello, I am using this code: data want; infile "filepath" delimiter = '|' MISSOVER DSD FIRSTOBS=2; input ID $15. Location_ID 9 Code 4 Date_Eff 8 Date_Insert_Row 8 Date_Exp 8 Code_ID $9. ; run; to infile data that looks like this: ID|Location_ID|Code|Date_Eff|Date_Insert_Row|Date_Exp|Code_ID 100101160A |200010386|1|19920430|20200926|22991231|BR3209512 200001040A |200050045|1|19930630|20200926|22991231|AA8312693 but my output data looks like this: can someone help diagnosis this issue? it looks like the code isn't reading the delimiter properly?

marleeakerson · ‎10-13-2020

Hello, I currently have a variable that contains a last name and first name, and I want to split it up into two separate variables, one for the last name and one for the first name. For example, I want the data to go from: Name Smith Julia Johnson Mark Reynolds Steve to this: Last Name First Name Smith Julia Johnson Mark Reynolds Steve Does anyone have any advice? Thanks!

Online Status	Offline
Date Last Visited	‎03-05-2021 07:07 PM

Re: Capturing time stamp from CSV file

Re: Capturing time stamp from CSV file

Re: Capturing time stamp from CSV file

Capturing time stamp from CSV file

Re: PROC IMPORT of CSV file, while removing leading rows

PROC IMPORT of CSV file, while removing leading rows

Date Format

Groupings by Age

help with PROC SQL

Library does not exist

Re: Help with proc format step, creating new custom column formats

Re: Capturing time stamp from CSV file

Re: Capturing time stamp from CSV file

Re: Capturing time stamp from CSV file

Capturing time stamp from CSV file

Re: PROC IMPORT of CSV file, while removing leading rows

PROC IMPORT of CSV file, while removing leading rows

Date Format

Groupings by Age

help with PROC SQL

Library does not exist

Help with filtering data

Re: Help with merge

Help with merge

Help with infiling

Splitting up a variable