About Koke

Koke · ‎07-29-2017

For Base SAS Software ... Custom version information: 9.4_M4 Image version information: 9.04.01M4P110916 For SAS/STAT ... Custom version information: 14.2 For SAS/ETS ... Custom version information: 14.2 For SAS/IML ... Custom version information: 14.2 For High Performance Suite ... Custom version information: 2.2_M5 For SAS/ACCESS Interface to PC Files ... Custom version information: 9.4_M4 This is what it shows when I run the PROC product status thank

Koke · ‎07-29-2017

I would like to have both of them come together like this 'a^' not separate like this 'a' '^'. Thank

Koke · ‎07-28-2017

Hi all, I want to use 'a^' as a mark in my plot2, but I don't know how to combine the character (a) with symbol(^). Need help data sat; infile datalines firstobs = 3 delimiter='.' truncover ; input year 4. @6 L_quart 5. U_quart ; datalines; Year Lower Upper Quart Quart 2015 1200 1360 2014 1170 1330 2013 1170 1330 2012 1140 1330 2011 1130 1320 2010 1110 1310 2009 1140 1310 2008 1120 1290 2007 1130 1300 2006 1150 1310 ; proc print data = sat; PROC SGPLOT DATA = sat; symbolchar name=plot1 char='0056'x; symbolchar name=plot2 char='0061'x/'02C4'x; SCATTER X = year Y = L_quart / MARKERATTRS = (SYMBOL=plot1 size=12pt); SCATTER X = year Y = U_quart / markerattrs=(symbol=plot2 size=12pt); 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data sat; 63 infile datalines firstobs = 3 delimiter='.' truncover ; 64 input year 4. @6 L_quart 5. U_quart 65 ; 66 datalines; NOTE: The data set WORK.SAT has 10 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 79 ; 80 proc 81 print data = sat; NOTE: There were 10 observations read from the data set WORK.SAT. NOTE: PROCEDURE PRINT used (Total process time): real time 0.19 seconds cpu time 0.16 seconds 82 PROC SGPLOT DATA = sat; 83 symbolchar name=plot1 char='0056'x; 84 symbolchar name=plot2 char='0061'x/'02C4'x; _______ 22 200 ERROR 22-322: Syntax error, expecting one of the following: ;, HOFFSET, ROTATE, SCALE, TEXTATTRS, VOFFSET. ERROR 200-322: The symbol is not recognized and will be ignored. 85 symbolchar name=plot3 char='02C4'x ; 86 SCATTER X = year Y = L_quart / MARKERATTRS = (SYMBOL=plot1 size=12pt); 87 SCATTER X = year Y = U_quart / markerattrs=(symbol=plot2 size=12pt); 88 89 90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 103

Koke · ‎07-27-2017

Hello expert I want to trim my data by eliminate highest and lowest (G1-G13) for each observation from my data set . data grades; infile '/folders/myshortcuts/SASUniversityEdition/module 7/grades.txt'; input id 4. @6 G1 1. G2 1. G3 1. G4 1. G5 1. G6 1. G7 1. G8 1. G9 1. G10 1. G11 1. G12 1. G13 1. ; total = G1+G2+G3+G4+G5+G6+G7 +G8+G9+G10+G11+G12+G13; proc print data = grades; here is my output Obs id G1 G2 G3 G4 G5 G6 G7 G8 G9 G10 G11 G12 G13 total 1 2 3 1105 8 7 5 8 3 7 7 8 8 8 8 8 6 91 1294 8 8 8 7 5 7 8 8 8 8 5 8 2 90 2009 8 6 3 8 4 6 7 7 8 7 0 4 7 75

Koke · ‎07-23-2017

Hello guys, need help by using ARRAY on tranform this ID X1 X2 X3 X4 X5 Y1 Y2 Y3 Y4 Y5 1 4 5 4 7 3 1 7 3 6 8 2 8 7 8 6 7 5 4 3 5 6 into this form. ID Time X Y 01 1 4 5 01 2 5 7 01 3 4 3 01 4 7 6 here is my code DATA FROG; INPUT ID X1-X5 Y1-Y5; DATALINES; 01 4 5 4 7 3 1 7 3 6 8 02 8 7 8 6 7 5 4 3 5 6 ; proc print data = frog; and here is my log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 DATA FROG; 63 INPUT ID X1-X5 Y1-Y5; 64 DATALINES; NOTE: The data set WORK.FROG has 2 observations and 11 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 67 ; 68 proc 69 print data = frog; 70 71 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 84 thank you guys

Koke · ‎07-23-2017

hello all, I'm trying to transpose my variable into observation. from name week0 week2 week4 max 0 1106 0 bijou 0 855 344 cooper 70 800 568 princess 85 69 688 lucy 92 762 97 and I want the output look like this name week eos max week0 0 week2 1106 week4 0 bijou week0 0 week2 855 week4 344 . . . and so on here is my code data dogs3; infile '/folders/myshortcuts/SASUniversityEdition/module 6/dogs3.txt' firstobs=3 ; input name $ week0 week2 week4; proc print data = dogs3; proc sort data= dogs3; by name; proc transpose data = dogs3 out = newdog3; by name; ID week0 week2 week4; var week0 week2 week4 ; proc print data = newdog3; here is my log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data dogs3; 63 infile '/folders/myshortcuts/SASUniversityEdition/module 6/dogs3.txt' 64 firstobs=3 65 ; 66 input name $ week0 week2 week4; NOTE: The infile '/folders/myshortcuts/SASUniversityEdition/module 6/dogs3.txt' is: (no system-specific pathname available), (no system-specific file attributes available) NOTE: 25 records were read from the infile '/folders/myshortcuts/SASUniversityEdition/module 6/dogs3.txt'. The minimum record length was 32. The maximum record length was 32. NOTE: The data set WORK.DOGS3 has 25 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.03 seconds 67 proc 68 print data = dogs3; NOTE: There were 25 observations read from the data set WORK.DOGS3. NOTE: PROCEDURE PRINT used (Total process time): real time 0.56 seconds cpu time 0.46 seconds 69 proc sort data= dogs3; 70 by name; 71 72 NOTE: There were 25 observations read from the data set WORK.DOGS3. NOTE: The data set WORK.DOGS3 has 25 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 73 proc 74 transpose data = dogs3 75 out = newdog3; 76 by name; 77 ID week0 week2 week4; 78 var week0 week2 week4 ; NOTE: There were 25 observations read from the data set WORK.DOGS3. NOTE: The data set WORK.NEWDOG3 has 75 observations and 27 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.03 seconds cpu time 0.02 seconds 79 proc 80 print data = newdog3; 81 82 83 84 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 97 If you guys have another to create an output such as array would be appreciate. Thank you guys

Koke · ‎07-23-2017

Hello all, I want the table, which shows frequency of observation in ascending order Here is my output STATE1 Frequency NJ NY PA 1 1 1 STATE2 Frequency Frequency Missing = 1 NJ NY 1 1 STATE3 Frequency Frequency Missing = 1 CA PA 1 1 STATE4 Frequency Frequency Missing = 2 TX 1 STATE5 Frequency Frequency Missing = 2 GA 1 I want the table that has the frequency 1 come first and then 2 and 3. here is my code DATA STATE (drop = i); INFORMAT STATE1-STATE5 $2.; INPUT ID STATE1-STATE5; array vars[*] _character_; do i=1 to dim(vars); if vars[i]= 'XX' then vars[i]= ' '; end; DATALINES; 1 NY NJ PA TX GA 2 NJ NY CA XX XX 3 PA XX XX XX XX ; proc print data=state; proc freq data=state; table STATE1-STATE5/ nocum nopercent; run; here is my log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 DATA STATE (drop = i); 63 INFORMAT STATE1-STATE5 $2.; 64 INPUT ID STATE1-STATE5; 65 array vars[*] _character_; 66 do i=1 to dim(vars); 67 if vars[i]= 'XX' then vars[i]= ' '; 68 end; 69 DATALINES; NOTE: The data set WORK.STATE has 3 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 73 ; 74 proc 75 print data=state; 76 NOTE: There were 3 observations read from the data set WORK.STATE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.21 seconds cpu time 0.22 seconds 77 proc 78 freq data=state; 79 table STATE1-STATE5/ nocum nopercent; 80 run; NOTE: There were 3 observations read from the data set WORK.STATE. NOTE: PROCEDURE FREQ used (Total process time): real time 0.29 seconds cpu time 0.27 seconds 81 82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 95 thank you guys

Koke · ‎07-22-2017

I'm having a problem with stacking when the if the condition is met. here is my output Obs id test1 test2 test3 test4 test5 pass 1 2 3 4 001 90 88 92 95 90 5 002 64 64 77 72 71 8 003 68 69 80 75 70 12 004 88 77 66 77 67 16 the pass value should be 5,3,4,4 repectively but it turn out that the values are stacking. here is my code data test (drop = i); input id $ test1 test2 test3 test4 test5 ; array test (5) test1-test5; do i =1 to 5; if test(i) =test1 and test(i)>= 65 then pass + 1; else if test(i) =test2 and test(i)>= 70 then pass + 1; else if test(i) =test3 and test(i)>= 60 then pass + 1; else if test(i) =test4 and test(i)>= 62 then pass + 1; else if test(i) =test5 and test(i)>= 68 then pass + 1; end; datalines; 001 90 88 92 95 90 002 64 64 77 72 71 003 68 69 80 75 70 004 88 77 66 77 67 ; proc print data = test; if you could simplified my array that would be appriciate. here is my log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data test (drop = i); 63 input id $ test1 test2 test3 test4 test5 64 ; 65 array test (5) test1-test5; 66 do i =1 to 5; 67 if test(i) =test1 and test(i)>= 65 then pass + 1; 68 else if test(i) =test2 and test(i)>= 70 then pass + 1; 69 else if test(i) =test3 and test(i)>= 60 then pass + 1; 70 else if test(i) =test4 and test(i)>= 62 then pass + 1; 71 else if test(i) =test5 and test(i)>= 68 then pass + 1; 72 else if test(i) ^= test(i) then pass = 0; 73 end; 74 datalines; NOTE: The data set WORK.TEST has 4 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds 79 ; 80 proc 81 print data = test; 82 83 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 96 Thank you guys

Koke · ‎07-11-2017

Hi, guys I'm struggling in print my new value (Mileage, Cost), but unfortunately it still did not work even I used commax and dollarx. The result is (.), and I'm not sure what I'm missing. I use sas university edition. Need help data usedcar; infile "/folders/myshortcuts/SASUniversityEdition/module 3/usedcars.txt" firstobs=2 expandtabs obs=50 dsd ; input Year $2. Manufacturer $16. Model $16. Mileage commax. cost dollarx. ; proc contents data = usedcar varnum; Proc Format; value Mileage low - 50000 = '<50,000' 50000 - high = '>=50,000' other = 'Unknown'; Value Cost low - 5000 = 'Economic' 5000-10000 = 'Moderate' other = 'Expensive'; Proc print; run; Here is my log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data usedcar; 63 infile "/folders/myshortcuts/SASUniversityEdition/module 3/usedcars.txt" 64 firstobs=2 expandtabs obs=50 dsd 65 ; 66 input 67 Year $2. Manufacturer $16. Model $16. Mileage commax. cost dollarx. 68 ; NOTE: The infile "/folders/myshortcuts/SASUniversityEdition/module 3/usedcars.txt" is: (no system-specific pathname available), (no system-specific file attributes available) NOTE: 49 records were read from the infile "/folders/myshortcuts/SASUniversityEdition/module 3/usedcars.txt". The minimum record length was 91. The maximum record length was 91. NOTE: The data set WORK.USEDCAR has 49 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.02 seconds 69 proc 70 contents data = usedcar varnum; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.51 seconds cpu time 0.46 seconds 71 Proc 72 Format; 73 value Mileage low - 50000 = '<50,000' 74 50000 - high = '>=50,000' 75 other = 'Unknown'; NOTE: Format MILEAGE is already on the library WORK.FORMATS. NOTE: Format MILEAGE has been output. 76 77 Value Cost low - 5000 = 'Economic' 78 5000-10000 = 'Moderate' 79 other = 'Expensive'; NOTE: Format COST is already on the library WORK.FORMATS. NOTE: Format COST has been output. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 80 Proc 81 print; 82 run; NOTE: There were 49 observations read from the data set WORK.USEDCAR. NOTE: PROCEDURE PRINT used (Total process time): real time 0.50 seconds cpu time 0.49 seconds 82 ! 83 84 85 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 98 xxxxxxxxxxxxxxxxx Here is my data (Example) xxxxxxxxxxxxxxxxx 94 Chrysler LeBaron 50,000 $7,999

Koke · ‎07-11-2017

Oh, my silly mistake Thx.

Koke · ‎07-11-2017

Oh, my silly mistake Thx.

Koke · ‎07-11-2017

Hello all, I'm trying to create a text file, and print it. However, it did not show anything in the output. I use sas univeristy edition. I really not sure that A shared folder named "myfolders" was not found on the virtual machine. See the FAQ for details. this message that show in the notification effect the problem or not. Need help My example data from (infile).txt 11 Xxxxxxxx Yyyy XX 5-8 YY 2X Here is my code data _null_ ; infile "/folders/myshortcuts/SASUniversityEdition/module 2/soccer.txt" delimiter="-" ; Input number $ 2. #2 firstname $ 1-8 lastname $ 11. #3 code $ #4 feet 1. inches #5 level $ #6 jersey $ ; file "/folders/myfolders/soccer.txt" print; Title; Put @2 firstname lastname 'wear Number' @1 number ; Put; run; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data _null_ 63 ; 64 infile "/folders/myshortcuts/SASUniversityEdition/module 2/soccer.txt" delimiter="-" 65 ; 66 Input number $ 2. #2 firstname $ 1-8 lastname $ 11. #3 code $ #4 feet 1. inches #5 67 level $ #6 jersey $ 68 ; 69 file "/folders/myfolders/soccer.txt" print; 70 Title; 71 Put @2 firstname lastname 'wear Number' @1 number ; 72 Put; 73 run; NOTE: The infile "/folders/myshortcuts/SASUniversityEdition/module 2/soccer.txt" is: (no system-specific pathname available), (no system-specific file attributes available) NOTE: The file "/folders/myfolders/soccer.txt" is: (no system-specific pathname available), (no system-specific file attributes available) NOTE: 192 records were read from the infile "/folders/myshortcuts/SASUniversityEdition/module 2/soccer.txt". The minimum record length was 22. The maximum record length was 22. NOTE: 32 records were written to the file "/folders/myfolders/soccer.txt". The minimum record length was 23. The maximum record length was 30. NOTE: DATA statement used (Total process time): real time 0.11 seconds cpu time 0.02 seconds 74 75 76 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 91 Thank.

Koke · ‎07-09-2017

Hello, guys I'm struggling in a date issue. I searched for informat date statement and did not find this type of format M-DD-YY. here is my data 3-05-98,5.79,7.69,112.8,128,47,46.7,10.6 4-06-98,4.75,5.49,61.3,75,20,19.3,7.1 4-07-98,4.95,5.79,65.5,62,20,19.8,7.6 2-25-98,5.34,6.77,.,102,33.5,33.5,8.3 This my code data limes ; infile "/folders/myshortcuts/SASUniversityEdition/module 3/limes.txt" firstobs=2 dsd ; input date fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt ; proc print data = limes ; Obs date fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt 1 2 3 4 5 6 . 5.79 7.69 112.8 128 47.0 46.7 10.6 . 4.75 5.49 61.3 75 20.0 19.3 7.1 . 4.95 5.79 65.5 62 20.0 19.8 7.6 . 5.34 6.77 . 102 33.5 33.5 8.3 . 5.44 6.16 86.6 100 32.0 31.8 8.7 . 6.71 7.46 164.2 184 67.0 67.5 15.7 Thank you guys

Koke · ‎07-09-2017

Thank you, Shmuel I fix mistakes follow from your code. In the output, some observation in date column shows the number that I want, but some show (.). So I look back to the data file. Date 10/10/1997 (date type in csv.) 10/18/1997 (general type in csv.) 10/24/1997 (general type in csv.) 10/26/1997 (general type in csv.) 10/31/1997 (general type in csv.) 11/01/1997(date type in csv.) 11/07/1997(date type in csv.) 11/08/1997(date type in csv.) This is an output Obs date Team City State OSU OPP 1 2 3 4 5 6 7 8 13797 Toronto Columbus Ohio 5 13805 Miami Oxford Ohio 0 13811 Merrimac Columbus Ohio 2 13813 Merrimac Columbus Ohio 5 13818 Clarkson Potsdam New York 1 . Clarkson Potsdam New York 6 2 . Western Columbus Ohio 1 3 . Notre Da Columbus Ohio 3 2 I assume that the problem is I have both number type and date type in the same column. As a result, the (.) show in some of the column. The log shows this statement WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. Here all of the log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 61 62 data hockey; 63 infile "/folders/myshortcuts/SASUniversityEdition/module 3/hockey.csv" 64 firstobs = 2 delimiter="," dsd; 65 66 input date mmddyy10. Team $ 8. City $ State $ OSU $ OPP $ ; 67 run; NOTE: The infile "/folders/myshortcuts/SASUniversityEdition/module 3/hockey.csv" is: (no system-specific pathname available), (no system-specific file attributes available) NOTE: Invalid data for date in line 7 1-10. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 7 11/1/1997,Clarkson,Potsdam , New York,6,2 41 date=. Team=Clarkson City= State=Potsdam OSU=New York OPP=6 _ERROR_=1 _N_=6 NOTE: Invalid data for date in line 8 1-10. 8 11/7/1997,Western Michigan,Columbus , Ohio,1,3 46 date=. Team=Western City=Michigan State=Columbus OSU=Ohio OPP=1 _ERROR_=1 _N_=7 NOTE: Invalid data for date in line 9 1-10. 9 11/8/1997,Notre Dame,Columbus , Ohio,3,2 40 date=. Team=Notre Da City=me State=Columbus OSU=Ohio OPP=3 _ERROR_=1 _N_=8 NOTE: Invalid data for date in line 14 1-10. 14 12/5/1997,Alaska-Fairbanks,Columbus , Ohio,8,3 46 date=. Team=Alaska-F City=airbanks State=Columbus OSU=Ohio OPP=8 _ERROR_=1 _N_=13 NOTE: Invalid data for date in line 15 1-10. 15 12/6/1997,Alaska-Fairbanks,Columbus , Ohio,4,0 46 date=. Team=Alaska-F City=airbanks State=Columbus OSU=Ohio OPP=4 _ERROR_=1 _N_=14 NOTE: Invalid data for date in line 18 1-10. 18 1/2/1998,Michigan,Ann Arbor, Michigan,4,2 41 date=. Team=ichigan, City=Ann Arbo State=Michigan OSU=4 OPP=2 _ERROR_=1 _N_=17 NOTE: Invalid data for date in line 19 1-10. 19 1/3/1998,Michigan,Ann Arbor, Michigan,6,0 41 date=. Team=ichigan, City=Ann Arbo State=Michigan OSU=6 OPP=0 _ERROR_=1 _N_=18 NOTE: Invalid data for date in line 20 1-10. 20 1/9/1998,Lake Superior,Columbus , Ohio,7,0 42 date=. Team=ake Supe City=rior State=Columbus OSU=Ohio OPP=7 _ERROR_=1 _N_=19 NOTE: Invalid data for date in line 21 1-10. 21 1/10/1998,Ferris State,Columbus , Ohio,5,3 42 date=. Team=Ferris S City=tate State=Columbus OSU=Ohio OPP=5 _ERROR_=1 _N_=20 NOTE: Invalid data for date in line 22 1-10. 22 1/18/1998,Bowling Green,Columbus , Ohio,4,2 43 date=. Team=Bowling City=Green State=Columbus OSU=Ohio OPP=4 _ERROR_=1 _N_=21 NOTE: Invalid data for date in line 23 1-10. 23 1/24/1998,Northern Michigan,Columbus , Ohio,2,0 47 date=. Team=Northern City=Michigan State=Columbus OSU=Ohio OPP=2 _ERROR_=1 _N_=22 NOTE: Invalid data for date in line 24 1-10. 24 1/25/1998,Notre Dame,Columbus , Ohio,5,3 40 date=. Team=Notre Da City=me State=Columbus OSU=Ohio OPP=5 _ERROR_=1 _N_=23 NOTE: Invalid data for date in line 25 1-10. 25 1/30/1998,Western Michigan,Kalamazoo, Michigan,4,2 50 date=. Team=Western City=Michigan State=Kalamazo OSU=Michigan OPP=4 _ERROR_=1 _N_=24 NOTE: Invalid data for date in line 26 1-10. 26 2/6/1998,Michigan State,Columbus , Ohio,4,2 43 date=. Team=ichigan City=State State=Columbus OSU=Ohio OPP=4 _ERROR_=1 _N_=25 NOTE: Invalid data for date in line 27 1-10. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 27 2/7/1998,Alaska-Fairbanks,Columbus , Ohio,4,4 45 date=. Team=laska-Fa City=irbanks State=Columbus OSU=Ohio OPP=4 _ERROR_=1 _N_=26 NOTE: Invalid data for date in line 28 1-10. 28 2/13/1998,Notre Dame,South Bend,Indiana,5,3 43 date=. Team=Notre Da City=me State=South Be OSU=Indiana OPP=5 _ERROR_=1 _N_=27 NOTE: Invalid data for date in line 29 1-10. 29 2/14/1998,Michigan State,East Lansing,Michigan,4,1 50 date=. Team=Michigan City=State State=East Lan OSU=Michigan OPP=4 _ERROR_=1 _N_=28 NOTE: Invalid data for date in line 30 1-10. 30 2/26/1998,Miami,Columbus , Ohio,5,2 35 date=. Team=Miami,Co City=lumbus State=Ohio OSU=5 OPP=2 _ERROR_=1 _N_=29 NOTE: Invalid data for date in line 31 1-10. 31 3/13/1998,Lake Superior,Columbus , Ohio,2,1 43 date=. Team=Lake Sup City=erior State=Columbus OSU=Ohio OPP=2 _ERROR_=1 _N_=30 NOTE: Invalid data for date in line 32 1-10. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 32 3/14/1998,Lake Superior,Columbus , Ohio,6,0 43 date=. Team=Lake Sup City=erior State=Columbus OSU=Ohio OPP=6 _ERROR_=1 _N_=31 NOTE: 36 records were read from the infile "/folders/myshortcuts/SASUniversityEdition/module 3/hockey.csv". The minimum record length was 35. The maximum record length was 56. NOTE: The data set WORK.HOCKEY has 36 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.02 seconds 68 69 proc print data = hockey; run; NOTE: There were 36 observations read from the data set WORK.HOCKEY. NOTE: PROCEDURE PRINT used (Total process time): real time 1.56 seconds cpu time 1.50 seconds 70 71 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 84 Thank you for your time and guiding

Koke · ‎07-08-2017

Hello, guys I have a question about how to convert data in a .csv file. I use sas university edition. The file has one column, which has both numbers that look like (date type) (ex.10/18/1991) and date (ex.10/10/1997) in the same column. My goal is combined the month, day, and year into one variable representing the date. However, I m still struggling in converting all of them. Need guidelines and help. Data Date Team City State OSU OPP 10/10/1997 Toronto Columbus Ohio 5 0 10/18/1997 Miami Oxford Ohio 0 3 10/24/1997 Merrimack Columbus Ohio 2 7 10/26/1997 Merrimack Columbus Ohio 5 3 10/31/1997 Clarkson Potsdam New York 1 1 11/01/1997 Clarkson Potsdam New York 6 2 11/07/1997 Western Michigan Columbus Ohio 1 3 11/08/1997 Notre Dame Columbus Ohio 3 2 data hockey; infile "/folders/myshortcuts/SASUniversityEdition/module 3/hockey.csv" firstobs = 2 delimiter="/" dsd ; input Date DDMMYY8. Team $ City $ State $ OSU $ OPP $ ; proc print data = hockey; Thank you

Online Status	Offline
Date Last Visited	‎07-30-2017 05:27 PM

Re: symbol in proc SGPLOT

Re: symbol in proc SGPLOT

symbol in proc SGPLOT

trimmed mean

array problem

tranpose variable into obs

Proc freq ascending order

IF Statements Problem

format and print new values

Re: creating txt.

Re: array problem

Re: IF Statements Problem

Re: Combine the (m-dd-yy) into one variable representing the date.

Re: convert number and date in the same column ,and combine to date (o...

Re: symbol in proc SGPLOT

Re: symbol in proc SGPLOT

symbol in proc SGPLOT

trimmed mean

array problem

tranpose variable into obs

Proc freq ascending order

IF Statements Problem

format and print new values

Re: creating txt.

Re: creating txt.

creating txt.

Combine the (m-dd-yy) into one variable representing the date.

Re: convert number and date in the same column ,and combine to date (o...

convert number and date in the same column ,and combine to date (one v...