About michokwu

michokwu · ‎01-30-2020

Yes. But the format for Id2 is 11. and w_geocode is 15.

michokwu · ‎01-30-2020

It returns the same error without the format included

michokwu · ‎01-30-2020

Its the format. 11 digits

michokwu · ‎01-30-2020

changed it to: where Id2 = w_geocode 11. error: ERROR 22-322: Syntax error, expecting one of the following: ;, !, !!, &, (, *, **, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT, HAVING, INTERSECT, LE, LET, LT, LTT, NE, NET, NOT, OR, ORDER, OUTER, UNION, ^, ^=, |, ||, ~, ~=. ERROR 76-322: Syntax error, statement will be ignored.

michokwu · ‎01-30-2020

Hi. Any reason why I am getting this error. Both variables are numeric proc sql; create table my_location as select Id2, sum(s000) as s000, sum(sa01) as sa01, sum(sa02) as sa02, sum(sa03) as sa03, from work, tracts where Id2 = put(w_geocode, 11.) ; quit; Proc content output below: Alphabetic List of Variables and Attributes # Variable Type Len Format Label 1 Id2 Num 8 BEST. Id2 Alphabetic List of Variables and Attributes # Variable Type Len Format 3 S000 Num 8 3 4 SA01 Num 8 2 5 SA02 Num 8 3 6 SA03 Num 8 2 7 SE01 Num 8 2 8 SE02 Num 8 2 9 SE03 Num 8 2 10 SI01 Num 8 2 11 SI02 Num 8 2 12 SI03 Num 8 3 13 Year Num 8 2 h_geocode Num 8 15 1 w_geocode Num 8 15

michokwu · ‎01-29-2020

I can't seem to format the city code, even though the format contains fewer characters, when I run the program it retains the region code. The codes are numeric

michokwu · ‎01-28-2020

Thank you Reeza. Please can you clarify 'Now apply the Region name to the data'

michokwu · ‎01-27-2020

Hello, I would like to link and aggregate records (over 10 million) in a dataset to another dataset. Is there a way to achieve this in one task? Thank you Data 1 - what I have City City_Code Item 1 Item 2 Item 3 Item 4 City A 123001001 10 20 30 40 City B 123001002 20 30 40 50 City C 123002001 30 40 50 60 City D 123002002 40 50 60 70 City E 123003001 50 60 70 80 City F 123003002 60 70 80 90 City G 123004001 70 80 90 100 City H 123004002 80 90 100 110 Data 2 - what I want (the region code forms the beginning part of the city code) Region Region_Code Item 1 Item 2 Item 3 Item 4 North 123001 30 50 70 90 South 123002 70 90 110 130 East 123003 110 130 150 170 West 123004 150 170 190 210

michokwu · ‎10-03-2019

Thank you

michokwu · ‎10-03-2019

Hello, I want to calculate 5-year average on a time series dataset with Years as the variable names. How do I correctly input the variable names in my code? My data: Company 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 A 9470 6920 3540 8247 8177 8001 7047 5829 5388 6491 B 8141 8511 6755 7427 6252 6551 8634 6489 5715 7338 C 506 90 1073 183 217 1432 699 382 253 340 D 1027 1521 1319 390 667 1101 371 1201 273 1311 What I want Company 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2001-2005 2006-2010 A 9470 6920 3540 8247 8177 8001 7047 5829 5388 6491 7270.8 6551.2 B 8141 8511 6755 7427 6252 6551 8634 6489 5715 7338 7417.2 6945.4 C 506 90 1073 183 217 1432 699 382 253 340 413.8 621.2 D 1027 1521 1319 390 667 1101 371 1201 273 1311 984.8 851.4 Thank you, Data want; set have; '2001-2005'n=mean(of 2001-2005); '2006-2010'n=mean(of 2006-2010); run;

michokwu · ‎09-27-2019

Please see Sheet2 attached. Thank you

michokwu · ‎09-27-2019

Hello, I'm creating a summary table and want to calculate the weighted counts and sums by group and subgroup. I have this summary by subgroups in different files but I want it as 1 summary table, it goes through 2001 to 2017. When I tried to that, I did not get the desired result. (See excel sheet attached) and my code below proc tabulate data=analysis1.in out=analysis1.in_w(drop=_type_); var weight; class Year race_sex education; table Year*race_sex*education weight*(n sum); run; Regards,

michokwu · ‎08-28-2019

Yes, long to wide. Thank you

michokwu · ‎08-28-2019

Need to observe trends over time. The transpose works. Thank you

michokwu · ‎08-28-2019

Hi, I am trying to reformat a really large dataset for better analysis what I have Year Manager Sales (#) 2015 Alan 360 2015 James 190 2015 Elena 220 2015 McCarthy 470 2016 Alan 387 2016 James 202 2016 Elena 250 2016 McCarthy 515 2017 Alan 2017 James 2017 Elena 2017 McCarthy what I want Manager 2015 2016 2017 Alan 360 387 James 190 202 Elena 220 250 McCarthy 470 515 Thank you,

Online Status	Offline
Date Last Visited	‎01-05-2023 12:58 PM

Re: Proc Means producing different results

Re: Proc Means producing different results

Proc Means producing different results

Re: Create Positive and Negative Trends

Re: Create Positive and Negative Trends

Re: Create Positive and Negative Trends

Create Positive and Negative Trends

Re: Convert Wide-form to Long-form

Convert Wide-form to Long-form

Re: calculating weighted average by group

Re: Proc Means producing different results

Re: Proc Means producing different results

Re: Proc Means producing different results

Re: Proc Means producing different results

Re: Proc Means producing different results

Re: unable to save libname

Re: unable to save libname

Re: Expression using equals (=) has components that are of different d...

Re: Expression using equals (=) has components that are of different d...

Re: Expression using equals (=) has components that are of different d...

Re: Expression using equals (=) has components that are of different d...

Expression using equals (=) has components that are of different data ...

Re: Map and Aggregate Data

Re: Map and Aggregate Data

Map and Aggregate Data

Re: working with variable names:numeric

working with variable names:numeric

Re: sums and counts by group/subgroups

sums and counts by group/subgroups

Re: Reformat datasets: short to long

Re: Reformat datasets: short to long

Reformat datasets: short to long

SAS Inner Circle Panel