About ydu180

ydu180 · ‎08-01-2017

proc sort data=customer_club out=customers; by Customer_Type Customer_BirthDate; run; data clubextremes; set customers; by Customer_Type; retain oldest oldest_bday youngest youngest_bday; if first.Customer_Type=1 then do; oldest=Customer_ID; oldest_bday=Customer_BirthDate; end; if last.Customer_Type=1 then do; youngest=Customer_ID; youngest_bday=Customer_BirthDate; agerange=(youngest_bday-oldest_bday)/365.25; output; end; keep Customer_Type oldest youngest oldest_bday youngest_bday agerange; run; This is data stpes, but I do not know how to write it in sql.

ydu180 · ‎08-01-2017

I need to print a table usin sql to show youngest and oldest of each customer_type. The desired table is oldest = the Customer_ID value of the oldest customer oldest_bday = the Customer_Birthdate of the oldest customer youngest = the Customer_ID value of the youngest customer youngest_bday = the Customer_Birthdate of the youngest customer agerange = the number of years (rounded to the nearest tenth) between the age of the oldest and youngest members of that type; use Customer_Birthdate instead of theCustomer_Age variable to calculate agerange I tried four sql, can anyone tell how to write this and let it be more efficient?

ydu180 · ‎08-01-2017

I need to sum the hits of each player and then show the max one. This is my code, but I has syntax problem on this nested sql, can someone help to figure out? proc sql; title2"Part 2d"; select distinct PlayerID, min(YearID) label="First Year", sum(H) as Total_Hits group by PlayerID where Total_Hits=max(Total_Hits); quit; title;

ydu180 · ‎07-25-2017

The requirement is: Print a table containing the number of observations, median, mean, and standard deviation for temperatures for each of the two days individually. The output I got is Does anyone know how to show like this data hw6.hotdays_ydu18; infile "/home/ydu180/hw6/hourly_temps.txt" dlm=' '; do Day=1 to 2; do Hour=1 to 24; input Temp@@; output; end; end; run; /*d*/ title2"Part 3d"; proc means data=hw6.hotdays_ydu18 N Median Mean STD; var Temp:; by Day; run;

ydu180 · ‎07-16-2017

I need to caculate age range between youngest and oldest of each type, could someone help mw with this as not every row has data. proc sort data=hw5.customer_club out=work.customer_club; by Customer_Type Customer_BirthDate; format Customer_BirthDate mmddyy10.; run; data work.Oldest; set work.customer_club; by Customer_Type Customer_BirthDate; if First.Customer_Type then oldest=Customer_ID; oldest_bday=Customer_BirthDate; if First.Customer_Type; keep oldest oldest_bday Customer_Type; format oldest_bday mmddyy10.; run; data work.Youngest; set work.customer_club; by Customer_Type Customer_BirthDate; if Last.Customer_Type then youngest=Customer_ID; youngest_bday=Customer_BirthDate; if Last.Customer_Type; keep youngest youngest_bday Customer_Type; format youngest_bday mmddyy10.; run; proc sort data=work.Youngest out=new_Youngest; by Customer_Type; run; proc sort data=work.Oldest out=new_Oldest; by Customer_Type; run; data work.merge1; set work.new_Youngest work.new_Oldest; by Customer_Type; run; The output of merge1 is above. I need to caculate their age range: agerange = the number of years (rounded to the nearest tenth) between the age of the oldest and youngest members of that type

ydu180 · ‎07-09-2017

Thank you, it works.

ydu180 · ‎07-09-2017

Thank you it works.

ydu180 · ‎07-09-2017

The requirement is: Use PROC CONTENTS to view the descriptor portion of each of the three data sets. Include only the first table from each of the PROC CONTENTS output (the one with the number of observations and variables) and don’t include the other two tables (engine data and variable attributes) in the Report Does anyone know what I need to add on proc contents and let it only shows the first table?

ydu180 · ‎07-09-2017

proc sort data=hw4.demographic out=work.demographic; by ID; run; proc sort data=hw4.survey2 out=work.survey2; by ID; run; data work.demo2_ydu18; merge work.demographic work.survey2; by ID; run; ID in demographic is character and in survey2 is numeric. I want to merge those two data set, could anyone tell how to convert one of those type. I tried ID=input(ID, 3.0); in demographic but it did not work.

ydu180 · ‎07-07-2017

Got that, thank you so much. As one of my assignment that data has spaces but use dlm="09"x, then I thought this will be the same. Thanks again.

ydu180 · ‎07-07-2017

libname project "/home/ydu180/project"; title1"Project"; data project.ydu_18; infile "/home/ydu180/project/housing.data" dlm='09'x dsd truncover; input CRIM ZN INDUS CHAS NOX RM AGE DIS RAD TAX PTRATIO B LSTAT MEDV; format CRIM 8.5 ZN 5.2 INDUS 6.3 CHAS 1.0 NOX 6.4 RM 6.4 AGE 5.2 DIS 7.4 RAD 2.0 TAX 5.1 PTRATIO 5.2 B 6.2 LSTAT 5.2 MEDV 5.2; Label CRIM="per capita crime rate by town" ZN="proportion of residential land zoned for lots over 25,000 sq.ft." INDUS="proportion of non-retail business acres per town" CHAS="Charles River dummy variable (= 1 if tract bounds river; 0 otherwise)" NOX="nitric oxides concentration (parts per 10 million)" RM="average number of rooms per dwelling" AGE="proportion of owner-occupied units built prior to 1940 " DIS="weighted distances to five Boston employment centres" RAD="index of accessibility to radial highways" TAX="full-value property-tax rate per $10,000" PTRATIO="pupil-teacher ratio by town" B="1000(Bk - 0.63)^2 where Bk is the proportion of blacks by town" LSTAT="% lower status of the population" MEDV="Median value of owner-occupied homes in $1000's"; run; proc contents data=project.ydu_18; run; proc print data=project.ydu_18 label noobs; var CRIM ZN INDUS CHAS NOX RM AGE DIS RAD TAX PTRATIO B LSTAT MEDV; run; There are 506 instances for every 14 variables, so the total observations should be 7084. I got 506 rows and 14 columns, but there were all dots, which is like the following. The content shows I only have 506 observations. The source data website is http://archive.ics.uci.edu/ml/machine-learning-databases/housing/housing.data Could someone tell how I read this txt and can get those data shown on my results?

ydu180 · ‎07-05-2017

The first one is my results, there are three missing value. The second is the information. I need to find the three and three them up.

ydu180 · ‎07-05-2017

How could I do if three missing Athletes have different age?

ydu180 · ‎07-05-2017

Does anyone know how to filling this missing values? I have information to fill, but I don't know how to locate these three and then assign, as other variables are the same.

ydu180 · ‎07-05-2017

It shows this: NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. title2"Part 3c"; title3"Invalid Data Errors"; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 156:12 157:17 158:17 159:17 160:17 161:17 162:17 NOTE: The infile "/home/ydu180/hw3/OlympicAthletes.dat" is: Filename=/home/ydu180/hw3/OlympicAthletes.dat, Owner Name=ydu180,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=28Jun2017:20:52:29, File Size (bytes)=526175 NOTE: Invalid data for CCD in line 2151 37-45. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 2151CHAR Mariela Antoniska.29.Argentina.2004.29/8/2004.Hockey.0.0.1.1 60 ZONE 467666624676667660330476667666033330332323333046666703030303 NUMR D1295C101E4FE93B192991275E49E192004929F8F200498F3B5990909191 Athlete=Mariela Antoniska Country=Argentina Sport=Hockey Host=Athens Age=29 Year=2004 CCD=. GM=0 SM=0 BM=1 TM=1 _ERROR_=1 _N_=2150 NOTE: Invalid data for Year in line 3209 25-28. 3209CHAR Luis Scola.28.Argentina.2oo8.8/24/2008.Basketball.0.0.1.1 57 ZONE 476725666603304766676660366303233233330467667666603030303 NUMR C593033FC192891275E49E192FF898F24F20089213B5421CC90909191 Athlete=Luis Scola Country=Argentina Sport=Basketball Host= Age=28 Year=. CCD=08/24/2008 GM=0 SM=0 BM=1 TM=1 _ERROR_=1 _N_=3208 NOTE: Invalid data for Year in line 3584 30-33. 3584CHAR Bakhtiyar Akhmedov.21.Russia.2oo8.8/24/2008.Wrestling.0.1.0.1 61 ZONE 4666767672466666670330577766036630323323333057677666603030303 NUMR 21B84991201B8D54F6921925339192FF898F24F2008972534C9E790919091 Athlete=Bakhtiyar Akhmedov Country=Russia Sport=Wrestling Host= Age=21 Year=. CCD=08/24/2008 GM=0 SM=1 BM=0 TM=1 _ERROR_=1 _N_=3583 NOTE: Invalid data for Year in line 7963 39-42. 7963CHAR DeLisha Milton-Jones.33.United States.2oo8.8/24/2008.Basketball.1.0.0.1 71 ZONE 46467662466766246667033056676625767670366303233233330467667666603030303 NUMR 45C93810D9C4FEDAFE5393395E9454034145392FF898F24F20089213B5421CC91909091 Athlete=DeLisha Milton-Jones Country=United States Sport=Basketball Host= Age=33 Year=. CCD=08/24/2008 GM=1 SM=0 BM=0 TM=1 _ERROR_=1 _N_=7962 NOTE: 8618 records were read from the infile "/home/ydu180/hw3/OlympicAthletes.dat". The minimum record length was 41. The maximum record length was 84. NOTE: The data set WORK.OLYMPICS_ERRORS_YDU18 has 8618 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.01 seconds memory 1922.50k OS Memory 30628.00k Timestamp 07/05/2017 05:29:21 AM Step Count 132 Switch Count 178 Page Faults 0 Page Reclaims 416 Page Swaps 0 Voluntary Context Switches 662 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 3080 run; Do I need any quotation mark like ""?

Online Status	Offline
Date Last Visited	‎08-01-2017 02:13 PM

Re: Find min and max of the same column in sql

Find min and max of the same column in sql

How to sum and then find max in sql

print array

How to caculate age range between youngest and oldest

Re: How to convert format from character to numeric variable

Re: How to Show First Table only in Proc Contents

How to Show First Table only in Proc Contents

How to convert format from character to numeric variable

Re: Cannot show read results