About Xinxin

Xinxin · ‎09-18-2023

I have a very silly but frustrating issue! The icons for programs, data etc have somehow moved way, way below on the project grid. I selected the group of icons to move up but it's taken me hours and they have moved up only a few millimeters !! Please help on how to quickly move them up. This could have happened when I auto-arranged the icons as it was a big mess to figure out the flow.

Xinxin · ‎10-13-2020

This also worked....thank you very much!

Xinxin · ‎10-13-2020

Interesting way to solve it...it worked ...Thank you!

Xinxin · ‎10-13-2020

I have data as shown below. I need to add the numbers preceding "mL" for each ID, into 1 variable, and add the numbers preceding mL/kg per ID into another variable. I tried removing the spaces but I don't know how many digits the number will be, to count back. I tried extracting the numeric part but then other numbers like the 9 from the % also gets extracted. Any help on how to do it in SAS (or Excel) will be appreciated. Thank you! ID DISPLAY_NAME 1 sodium chloride 0.9 % bolus 2,250 mL 1 sodium chloride 0.9 % bolus 1,000 mL 1 sodium chloride 0.9 % bolus 1,000 mL 2 sodium chloride 0.9 % bolus 500 mL 3 sodium chloride 0.9 % bolus 1,000 mL 3 sodium chloride 0.9 % bolus 250 mL 3 sodium chloride 0.9 % bolus 1,551 mL 4 lactated ringers bolus 1,000 mL 4 sodium chloride 0.9 % bolus 1,000 mL 4 PLASMA-LYTE A bolus 1,000 mL 5 sodium chloride 0.9 % bolus 30 mL/kg/dose 5 sodium chloride 0.9 % bolus 1,000 mL

Xinxin · ‎04-14-2020

Thank you...that worked and I learnt something new!!

Xinxin · ‎04-14-2020

Hello, I have a variable with ICD codes. I want everything of the left of the decimal. But some cells have multiple codes in a row. ICD_Code ICD_Code1 C18.9 C18 C15.9 C15 Z80.3 Z80 Z12.11, Z12.12 Z85.46 Z85 Z85.528 Z85 C65.9, C66.9 My code was as following: if ICD_Code1 in ("C85","C50", ~~ a lot more codes~~ ) then Cancer=1; I also tried with scan and substr, but I don't know how to do it when there are many values separated by commas. Thanks in advance!

Xinxin · ‎02-27-2020

I have looked at code online but I don't know how to project my data on the map and get the shading. Also, I don't want the whole country or state but zoomed in to a part of the state. Also, yesterday and today, the govt census site is down, so will check again later. Thanks.

Xinxin · ‎02-26-2020

Hello, My data is like this: ZIPcode Cases longi lati 43613 1 -83.604452 41.704307 44140 1 -81.92148 41.48982 46052 1 -86.470531 40.051603 48009 22 -83.213883 42.544619 48017 6 -83.151815 42.535396 48021 7 -82.946167 42.463894 48025 19 -83.265758 42.523195 I want to map the cases by zip code. The outline should be of the zip code boundary and the shading should be according to number of cases, darker as cases increase. If anyone can tell me how to do this either in SAS or R, that'll be great. I'm very new to R...Tried a lot of code I found online but can't get what I want. Any help is appreciated. Thank you!

Xinxin · ‎08-12-2019

Thank you very much....this worked!

Xinxin · ‎08-12-2019

Oh yes, thank you Reeza...I had forgotten about this option!

Xinxin · ‎08-12-2019

Wow....genius! I can do this with multiple tables too! Thanks a lot!!

Xinxin · ‎08-09-2019

Hello, I am joining 2 tables and this is my syntax: proc sql; create table final1 as select a.*, b.* from main1 a left join main2 b on a.ACCOUNT_ID = b.ACCOUNT_ID ; quit; And I know why I get the following note: WARNING: Variable ACCOUNT_ID already exists on file WORK.FINAL1 Both a and b data sets have many columns and I don't want to list out ALL the columns of b and just eliminate ACCOUNT_ID. I tried using DROP at various places but did not work. What is the method with proc sql if you want to keep a lot more columns than you want to drop, when joining tables. (In this ex I want to drop only 1 but my query is in general) Thanks!

Xinxin · ‎11-29-2018

Wow...thanks...learnt something new! Yes, I ended up ordering by ACCOUNT_ID and some other variables. Thanks to both of you ,@kiranv_ and @novinosrin !

Xinxin · ‎11-29-2018

When I use this code: proc sql; create table finn_counts1 as select *, sum(finn36) as ct_finn36 from finn1 group by ACCOUNT_ID; quit; I get the correct sum (albeit it's for each row of ACCOUNT_ID, and I can dedup that) but why does the order of the rows for each ACCOUNT_ID change? It's not sorted by any variable, looks randomly changed. Get these notes in the log: NOTE: The query requires remerging summary statistics back with the original data. NOTE: SAS threaded sort was used. Do I need to sort the data again to keep the original sequence per ACCOUNT_ID ?

Xinxin · ‎06-26-2018

There are observations where the episode ends in control=Yes and I have figured out the programming for that. (not an ideal situation to split the data, but...I did it.) The drug of interest is LABE. If a different drug, other than LABE was used then the control=XX. Every episode ends with control=Yes, if controlled by LABE or XX if controlled by other drug, but still considered a failure as LABE didn't work. I do not want a string that reads "80+80" but just used it for explanation. There are cases where control is no, no, yes, no, no, yes -- these are 2 episodes, I haven't figured programming for that either. My following crude code gives what I need as the last row, but for pushes it should be 200-40, which I can do later... data test124; set test123; if desc = "LABE" then pushes+dose; else if desc = "HYDR" then pushesxx+dose; run; LABE and other drugs will not be mixed within an ID. It will be only LABE and control =yes (maybe few no's in between) or LABE followed by another drug and then control will be xx.

Online Status	Offline
Date Last Visited	‎09-18-2023 08:41 PM

Icons in a SAS EG project

Re: Extract a number from a string

Re: Extract a number from a string

Extract a number from a string

Re: Extracting from a string with multiple values

Extracting from a string with multiple values

Re: Mapping by Zip code

Mapping by Zip code

Re: Proc Sql and Drop

Re: Proc Sql and Drop

Re: Extract a number from a string

Re: Extract a number from a string

Re: Extracting from a string with multiple values

Re: Proc Sql and Drop

Re: Creating multiple rows from 1 row of data

How to get labels in proc means output dataset ?

Re: Extract a number from a string

Re: Extracting from a string with multiple values

Multiple windows in SAS EG

Icons in a SAS EG project

Re: Extract a number from a string

Re: Extract a number from a string

Extract a number from a string

Re: Extracting from a string with multiple values

Extracting from a string with multiple values

Re: Mapping by Zip code

Mapping by Zip code

Re: Proc Sql and Drop

Re: Proc Sql and Drop

Re: Proc Sql and Drop

Proc Sql and Drop

Re: proc sql, counts

proc sql, counts

Re: Looping across rows