About Claudia_SAS

Claudia_SAS · ‎07-30-2020

Thank you! It worked!

Claudia_SAS · ‎07-30-2020

The start date and end date is not the issue. I can collect them based on min and max of the date for same id.

Claudia_SAS · ‎07-30-2020

Thank you Shmuel, yes the data is in SAS, I know the logic of the code, but it is not working very well for me.\ My fields are dates, and I cannot get it to work properly. I think I am more struggling with the syntax than logic. Do you have a code to share for dates? Thank you again.

Claudia_SAS · ‎07-30-2020

I am looking for a solution to increment by 10 from the first date to end date. In the table below the start date for reading_date is 12/17/2019, what I am trying to do is to create a loop for this date starting with 12/17/2019 by 10 and end in 1/27/2020. After the date is created I need to add the rest of the data corresponding to this date from the original table (please see "want") table t1.reading_date t1.use_date t1.name t1.reading_pct 12/17/2019 12/11/2019 file1 75.00915527 12/22/2019 12/11/2019 file1 75.5859375 12/27/2019 12/11/2019 file1 76.90429688 1/1/2020 12/11/2019 file1 74.29199219 1/2/2020 12/11/2019 file1 64.93835449 1/7/2020 12/11/2019 file1 65.10620117 1/12/2020 12/11/2019 file1 66.90063477 1/17/2020 12/11/2019 file1 66.47033691 1/22/2020 12/11/2019 file1 66.35131836 1/27/2020 12/11/2019 file1 59.61303711 want new(t1.reading_date) t1.use_date t1.name t1.reading_pct 12/17/2019 12/11/2019 file1 75.00915527 12/27/2019 12/11/2019 file1 76.90429688 1/7/2020 12/11/2019 file1 65.10620117 1/17/2020 12/11/2019 file1 66.47033691 1/27/2020 12/11/2019 file1 59.61303711 Any ideas? It's so easy in C++, I don't know how to generate this date in SAS? I have exhausted all my options. I really need your help! Thank you.

Claudia_SAS · ‎05-20-2020

Actually I did an "orthodox" code and it worked just perfect. data split; input rpo $743.; datalines; ; data split2 (drop=rpo i); set test; length opt1-opt186 $3; array opt(186) $; do i = 1 to dim(opt); opt[i]=scan(rpo,i,' ','M'); end; run; proc transpose data=split2 out=split3(drop=_NAME_ rename=(Col1_=opt)); by VIN ; VAR opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 opt16 opt17 opt18 opt19 opt20 opt21 opt22 opt23 opt24 opt25 opt26 opt27 opt28 opt29 opt30 opt31 opt32 opt33 opt34 opt35 opt36 opt37 opt38 opt39 opt40 opt41 opt42 opt43 opt44 opt45 opt46 opt47 opt48 opt49 opt50 opt51 opt52 opt53 opt54 opt55 opt56 opt57 opt58 opt59 opt60 opt61 opt62 opt63 opt64 opt65 opt66 opt67 opt68 opt69 opt70 opt71 opt72 opt73 opt74 opt75 opt76 opt77 opt78 opt79 opt80 opt81 opt82 opt83 opt84 opt85 opt86 opt87 opt88 opt89 opt90 opt91 opt92 opt93 opt94 opt95 opt96 opt97 opt98 opt99 opt100 opt101 opt102 opt103 opt104 opt105 opt106 opt107 opt108 opt109 opt110 opt111 opt112 opt113 opt114 opt115 opt116 opt117 opt118 opt119 opt120 opt121 opt122 opt123 opt124 opt125 opt126 opt127 opt128 opt129 opt130 opt131 opt132 opt133 opt134 opt135 opt136 opt137 opt138 opt139 opt140 opt141 opt142 opt143 opt144 opt145 opt146 opt147 opt148 opt149 opt150 opt151 opt152 opt153 opt154 opt155 opt156 opt157 opt158 opt159 opt160 opt161 opt162 opt163 opt164 opt165 opt166 opt167 opt168 opt169 opt170 opt171 opt172 opt173 opt174 opt175 opt176 opt177 opt178 opt179 opt180 opt181 opt182 opt183 opt184 opt185 opt186; run; data split4; set split3; value = 1; run; proc transpose data=split4 out=want; by VIN; id opt; var value; run; proc stdize data=want out=want missing=0 reponly; run;

Claudia_SAS · ‎05-20-2020

I should've mentioned that the length of rpo column is not the same for each row, in my case I picked the highest number and created as many columns I needed.

Claudia_SAS · ‎05-20-2020

thank you for your reply .....yes...I calculated the length of the rpo column, and then the length of opt(i) always equals to 3, delimiter is always one space.

Claudia_SAS · ‎05-20-2020

My code is: /**************************************************** data split; input rpo $743.; datalines; ; data split2 (drop=rpo i); set test; length opt1-opt186 $3; array opt(186) $; do i = 1 to dim(opt); opt[i]=scan(rpo,i,' ','M'); end; run; /****************************************************** But, this is not what i was looking for What I am looking for is to put variable "#AA" in a different column and not under the same column as "06D" I don't know if I make any sense....I was trying to many ways and nothing came the way I wanted. In the end I want to transpose the columns as leading headers and when I have a blank that should be counted as "0" and when I have a value that should be counted as "1". Something like this... Country #AA 06D 1D3 1SZ 2LZ 4AA 6X1 US 0 1 1 1 1 1 1 US 0 1 1 1 1 1 1 US 1 1 1 1 1 1 0 Please help!

Claudia_SAS · ‎05-20-2020

My dataset is string, and I have no numeric variables. I need to keep the # or 0 when leads the variable.

Claudia_SAS · ‎05-20-2020

Hello, I have a table which contains 2 columns: What I want is to split the second column into multiple columns(my delimiter is space) but in order. Therefore my new table should look just like this: Country OPT1 OPT2 OTP3 OTP4 OPT5............. OPTn US #02 #05 #38 Z82 US #02 #16 #33 ZY1 . . . US 1SZ Any ideas? Thank you, Claudia.

Claudia_SAS · ‎02-25-2020

works perfect! thank you!

Claudia_SAS · ‎02-25-2020

Thank you! what if instead of var 1, var 2,..., (array) i have different values (string only) i.e.: apple, pear, etc Therefore my giving table is Name Description A Apple A Pear A Red B Apple B Blueberry C Apple C Tomato And the output table should look: Apple Blueberry Pear Red Tomato A 1 0 1 1 0 B 1 1 0 0 1 C 1 0 0 0 1 Thank you!

Claudia_SAS · ‎02-25-2020

Hi, I am looking for some support using Proc SQL in SAS Enterprise Guide. What I am trying to do is based on the giving table: t1 (Name(string), Var(string)) looking just like in the imagine below Name Var A Var1 A Var2 A Var3 B Var1 B Var3 B Var89 C Var2 D Var70 And eventually to get my table looking as: Name Var1 Var2 Var3 Var4 …. Var70 … Var89 A 1 1 1 0 0 0 0 B 1 0 1 0 0 0 0 1 C 0 1 0 0 0 0 0 0 D 0 0 0 0 0 1 0 0 Basically it is a pivot table, where Name A has or has not a value of the Var i...n (1-means had a value, 0-means it doesn't have a value) Is there an easy way to do in one step using proc SQL? Thank you for your help!

Claudia_SAS · ‎02-24-2020

Hello, What I am trying to do is based on the giving table: t1 (Name(string), Var(string)) Name Var A Var1 A Var2 A Var3 B Var1 B Var3 B Var89 C Var2 D Var70 In the end I would like to have my table looking as: Name Var1 Var2 Var3 Var4 …. Var70 … Var89 A 1 1 1 0 0 0 0 B 1 0 1 0 0 0 0 1 C 0 1 0 0 0 0 0 0 D 0 0 0 0 0 1 0 0 Is there an easy way to do in one step using proc sql? Thank you for your help!

Online Status	Offline
Date Last Visited	‎07-30-2020 02:38 PM

Re: do loop for a giving start date by 10 to a giving end date

Re: do loop for a giving start date by 10 to a giving end date

Re: do loop for a giving start date by 10 to a giving end date

do loop for a giving start date by 10 to a giving end date

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: proc sql for transpose

Re: do loop for a giving start date by 10 to a giving end date

Re: do loop for a giving start date by 10 to a giving end date

Re: do loop for a giving start date by 10 to a giving end date

do loop for a giving start date by 10 to a giving end date

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Re: Splitting a delimited column into multiple columns in order

Splitting a delimited column into multiple columns in order

Re: proc sql for transpose

Re: proc sql for transpose

proc sql for transpose

Re: Proc Transpose/Proc Tabulate Problems