About RebeccaJW

RebeccaJW · ‎05-10-2019

data raw; set rawdata; keep day year title number; proc sort data=raw nodupkey; by day year; run; How could I modify this code to keep the day and year with the highest number if raw data contained multiple different values of numbers, instead of just a single value? Thank you!

RebeccaJW · ‎04-29-2019

Thank you for explanation!

RebeccaJW · ‎04-29-2019

Thank you for pointing out it!

RebeccaJW · ‎04-29-2019

Thank you! I solve that!

RebeccaJW · ‎04-29-2019

Thank you so much for your help! I appreciate it!

RebeccaJW · ‎04-29-2019

Hello, I am struggling with conversion of a character price to numeric. The data looks like this: As there is dollar sign there, I did the following. But there is error, and all prices turn out to be 0. Could anyone help me? if Price ~=0 then Price_num = input(Price, dollar10.3); else Price_num = 0;

RebeccaJW · ‎04-15-2019

Thank you so much! It works!

RebeccaJW · ‎04-15-2019

Hello, I am asked to subtract the numeric portion of a character variable using input(), substrn() or scan(). Thank you in advance for your help! This is what the original character look like. This is the expected result.

RebeccaJW · ‎04-15-2019

There are almost 70000 rows and 8 columns in the data set.

RebeccaJW · ‎04-15-2019

Hello, I want to merge two datasets as shown below. data sub; set orig; where name="speech"; run; data main; merge sub(in=a) orion.play(in=b); by actor; if a and b; run; If I just run the code above, there is an error saying ERROR: BY variables are not properly sorted on data set WORK.SUB. However, if i sort the data as below: proc sort data=sub out=sub; by actor; run; There are still errors saying ERROR: Insufficient space in file WORK.'SASTMP-000000713'n.UTILITY. ERROR: File WORK.'SASTMP-000000713'n.UTILITY is damaged. I/O processing did not complete. Can anyone help me? Thanks!

RebeccaJW · ‎04-15-2019

Thank you for replying! It works now!

RebeccaJW · ‎04-15-2019

Thank you! It works now!

RebeccaJW · ‎04-15-2019

data orig; infile "/home/Projects/Project2/A/B_clean.csv" dsd missover firstobs=2; informat title name $10000. date MMDDYY10. ; format date DDMMYY10.; input title name date; if title = "NEW" then date = '31OCT12010'd; if title = "OLD" then date = '15JUN2008'd; run; data orig.sub; set orig; where name="speech"; run; This is what I have written. The first part works well, but in the orig.sub step, there is an error shown below: ERROR: Libref ORIG is not assigned. Thank you for replying!

RebeccaJW · ‎04-15-2019

Hello, I have a problem about subsetting data. I need to keep the observations where the variable A equals to "speech" from a dataset. Then I need to merge this new dataset with another dataset and keep the observations that are in both datasets. It is appreciated if anyone can help me. Thank you!

RebeccaJW · ‎03-13-2019

Thank you so much for answering!

Online Status	Offline
Date Last Visited	‎05-10-2019 03:56 AM

keep highest value using proc sort

Re: convert character price to numeric

Re: convert character price to numeric

Re: convert character price to numeric

Re: convert character price to numeric

convert character price to numeric

Re: subtract numbers from character

subtract numbers from character

Re: sort and merge

sort and merge

keep highest value using proc sort

Re: convert character price to numeric

Re: convert character price to numeric

Re: convert character price to numeric

Re: convert character price to numeric

convert character price to numeric

Re: subtract numbers from character

subtract numbers from character

Re: sort and merge

sort and merge

Re: keep data subset for merging

Re: keep data subset for merging

Re: keep data subset for merging

keep data subset for merging

Re: separate datetime using Datepart() and Timepart()