About hwangnyc

hwangnyc · ‎10-30-2019

Awesome thank you so much!

hwangnyc · ‎10-30-2019

Hi, I have a time variable that contains character values like this: 11:50 AM 02:35 PM 11:20 AM I'd like to convert it to numeric so I can subtract and determine difference in time. Any suggestions would be greatly appreciated. Thanks!

hwangnyc · ‎10-22-2019

Good question, it's numeric with the timeampm format.

hwangnyc · ‎10-22-2019

Hello everyone, I'm not having much luck re-coding my time variable. What I would like is: 7AM-3PM = 'AM' 3PM-11PM = 'PM' 11PM-7AM = 'OVERNIGHT' I have data that looks like this HAVE ID TIME 102028027 4:00:00 AM 102028032 6:45:00 AM 102028088 3:15:00 PM 102028089 9:00:00 AM 102028049 1:30:00 PM WANT ID TIME SHIFT 102028027 4:00:00 AM Overnight 102028032 6:45:00 AM Overnight 102028088 3:15:00 PM PM 102028089 9:00:00 AM AM 102028049 1:30:00 PM AM Any help would be greatly appreciated! Thank you!

hwangnyc · ‎06-10-2019

Hi everyone, I have string data in two columns that are separated by commas. I'd like to scan the first column's characters and see if it appears in the second column. Here is some sample data: HaveA HaveB Homeless, Health Care, Aided Health Care, Verified, Aided A,B,C A,C X,Y,Z J,K,F This is what I want: HaveA HaveB Want Homeless, Health Care, Aided Health Care, Verified, Aided Health Care, Aided A,B,C A,C A,C X,Y,Z J,K,F . Many thanks in advance!

hwangnyc · ‎03-25-2019

Hi Ballardw, THANK YOU! This is perfect. Can you tell me how I can sum across the rows?

hwangnyc · ‎03-25-2019

Hi everyone, I'm trying to create a report using PROC Report: Here is the data and code: data dataexercise; input Week @@ Status $; datalines; 1 Accept 2 Accept 3 Accept 4 Accept 1 Reject 2 Reject 3 Accept 4 Accept 1 Accept 2 Accept 3 Accept 4 Accept ; run; proc tabulate data=dataexercise; class week Status ; table week*Status; run; Instead of the weeks going horizontally. This is what I would like: Week Accept Reject 1 2 1 2 2 1 3 3 0 4 3 0 Any help would be greatly appreciated! Thank you!

hwangnyc · ‎03-13-2019

Hi everyone, I'm using the WEEK function and I get a column that has 0-53. Is there a format that I can apply to have it read: 1 = 1/7/19 - 1/13/19 2 = 1/14/19 - 1/20/19 Thanks in advance! Henry

hwangnyc · ‎02-01-2019

Hi Tom, You're spot on! it imported on a seperate line in SAS as well. It was just hidden when I glanced at the dataset. Is there a way I can parse out the data by lines?

hwangnyc · ‎02-01-2019

Hello! When I imported the excel file - SAS only took the first few characters, cutting off all the data underneath. So data that is in Excel like this: OP - 1 ALC - 1 Became this: OP-1 in as SAS Data set. Thoughts?

hwangnyc · ‎02-01-2019

Hi everyone, I have an excel file that has data that looks like this: Services BC-1 0 0 BC-1 MI-1 0 BC-1 PC-1 MI-1 Assess B-1 BC-1 HR-1 MHA-1 CC-1 Assess B-1 BC-1 HR-4 BN-1 What I would like to do is transpose each category into a column from each cell. So what I would like is: BC MI PC AssessB HR BN MHA CC 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 1 0 0 1 1 0 1 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 4 0 0 0 Any help would be greatly appreciated thank you!

hwangnyc · ‎02-01-2019

Hi everyone, I have an excel file that has data that looks like this: Services BC-1 0 0 BC-1 MI-1 0 BC-1 PC-1 MI-1 Assess B-1 BC-1 HR-1 MHA-1 CC-1 Assess B-1 BC-1 HR-4 BN-1 What I would like to do is transpose each category into a column from each cell. So what I would like is: BC MI PC AssessB HR BN MHA CC 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 1 0 0 1 1 0 1 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 4 0 0 0 Any help would be greatly appreciated thank you!

hwangnyc · ‎01-16-2019

Hi everyone, This is what I have: Period Staff ID Start John 1234 End 1234 End 1234 End 1234 Start Dira 9876 End 9876 and this is what I want: Period Staff ID Start John 1234 End John 1234 End John 1234 End John 1234 Start Dira 9876 End Dira 9876

hwangnyc · ‎12-08-2018

Hi everyone, Can someone tell me the pros and cons of Proc import vs FILENAME REFFILE for importing in excel files? Why would you do one vs. the other? Thank you! HW

hwangnyc · ‎10-02-2018

Thanks Paige! That gave me this output: freq _TYPE_ _FREQ Time . 0 700 0:41:01 1 1 104 0:56:18 2 1 263 0:42:15 3 1 122 0:32:58 4 1 75 0:36:01 5 1 35 0:40:46 6 1 35 0:35:57 7 1 41 0:37:52 8 1 14 0:31:02 9 1 5 0:27:59 10 1 2 0:28:12 206 1 1 0:40:46 414 1 1 0:41:48 451 1 1 0:33:40 1072 1 1 0:38:09 I'm not quite sure what to make of this?

Online Status	Offline
Date Last Visited	‎12-31-2019 12:37 PM

Re: Character time to Numeric Time

Character time to Numeric Time

Re: IF then with TIMEAMPM data

IF then with TIMEAMPM data

Looking up strings in one column and matching in another.

Re: Proc report - Long instead of wide

Proc report - Long instead of wide

Week Format

Re: Character variables to columns

Re: Character variables to columns

Re: Proc import vs FILENAME REFFILE

Re: Distance between two data set

Re: Determining automatic file names in proc export

Suppress proc report output

Re: Character time to Numeric Time

Character time to Numeric Time

Re: IF then with TIMEAMPM data

IF then with TIMEAMPM data

Looking up strings in one column and matching in another.

Re: Proc report - Long instead of wide

Proc report - Long instead of wide

Week Format

Re: Character variables to columns

Re: Character variables to columns

Character variables to columns

Character variables to columns

Auto filling rows in a dataset

Proc import vs FILENAME REFFILE

Re: Trying to get some means but really struggling. Please help!