Hi Ballardw:   here is the log when I ran my code 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 options validvarname=v7; 72 73 filename stdata '/home/u62043935/Specialist_Prep_Guide/cert/state_data.txt' 74 lrecl=100; 75 proc import datafile=stdata 76 dbms=dlm 77 out=states 78 replace; 79 delimiter=' '; 80 getnames=yes; 81 run; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. Number of names found is greater than number of variables found. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Name is not a valid SAS name. Problems were detected with provided names. See LOG. 82 /********************************************************************** 83 * PRODUCT: SAS 84 * VERSION: 9.4 85 * CREATOR: External File Interface 86 * DATE: 04NOV22 87 * DESC: Generated SAS Datastep Code 88 * TEMPLATE SOURCE: (None Specified.) 89 ***********************************************************************/ 90 data WORK.STATES ; 91 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 92 infile STDATA delimiter = ' ' MISSOVER DSD firstobs=2 ; 93 informat Region $7. ; 94 informat State $16. ; 95 informat Capital $11. ; 96 informat Bird $20. ; 97 informat VAR5 $1. ; 98 informat VAR6 $1. ; 99 informat VAR7 $1. ; 100 informat VAR8 $1. ; 101 informat VAR9 $1. ; 102 informat VAR10 $1. ; 103 informat VAR11 $1. ; 104 informat VAR12 $1. ; 105 informat VAR13 $1. ; 106 informat VAR14 $1. ; 107 informat VAR15 $1. ; 108 informat VAR16 $1. ; 109 informat VAR17 $1. ; 110 informat VAR18 $1. ; 111 informat VAR19 $1. ; 112 informat VAR20 $1. ; 113 informat VAR21 $1. ; 114 informat VAR22 $1. ; 115 informat VAR23 $1. ; 116 informat VAR24 $1. ; 117 informat VAR25 $1. ; 118 informat VAR26 $1. ; 119 informat VAR27 $1. ; 120 informat VAR28 $1. ; 121 informat VAR29 $1. ; 122 informat VAR30 $1. ; 123 informat VAR31 $1. ; 124 informat VAR32 $1. ; 125 informat VAR33 $1. ; 126 informat VAR34 $1. ; 127 informat VAR35 $1. ; 128 informat VAR36 $1. ; 129 informat VAR37 $1. ; 130 informat VAR38 $1. ; 131 informat VAR39 $1. ; 132 informat VAR40 $1. ; 133 informat VAR41 $1. ; 134 informat VAR42 $1. ; 135 informat VAR43 $1. ; 136 informat VAR44 $1. ; 137 informat VAR45 $1. ; 138 informat VAR46 $1. ; 139 informat VAR47 $1. ; 140 informat VAR48 $1. ; 141 informat VAR49 $1. ; 142 informat VAR50 $1. ; 143 informat VAR51 $1. ; 144 informat VAR52 $1. ; 145 format Region $7. ; 146 format State $16. ; 147 format Capital $11. ; 148 format Bird $20. ; 149 format VAR5 $1. ; 150 format VAR6 $1. ; 151 format VAR7 $1. ; 152 format VAR8 $1. ; 153 format VAR9 $1. ; 154 format VAR10 $1. ; 155 format VAR11 $1. ; 156 format VAR12 $1. ; 157 format VAR13 $1. ; 158 format VAR14 $1. ; 159 format VAR15 $1. ; 160 format VAR16 $1. ; 161 format VAR17 $1. ; 162 format VAR18 $1. ; 163 format VAR19 $1. ; 164 format VAR20 $1. ; 165 format VAR21 $1. ; 166 format VAR22 $1. ; 167 format VAR23 $1. ; 168 format VAR24 $1. ; 169 format VAR25 $1. ; 170 format VAR26 $1. ; 171 format VAR27 $1. ; 172 format VAR28 $1. ; 173 format VAR29 $1. ; 174 format VAR30 $1. ; 175 format VAR31 $1. ; 176 format VAR32 $1. ; 177 format VAR33 $1. ; 178 format VAR34 $1. ; 179 format VAR35 $1. ; 180 format VAR36 $1. ; 181 format VAR37 $1. ; 182 format VAR38 $1. ; 183 format VAR39 $1. ; 184 format VAR40 $1. ; 185 format VAR41 $1. ; 186 format VAR42 $1. ; 187 format VAR43 $1. ; 188 format VAR44 $1. ; 189 format VAR45 $1. ; 190 format VAR46 $1. ; 191 format VAR47 $1. ; 192 format VAR48 $1. ; 193 format VAR49 $1. ; 194 format VAR50 $1. ; 195 format VAR51 $1. ; 196 format VAR52 $1. ; 197 input 198 Region $ 199 State $ 200 Capital $ 201 Bird $ 202 VAR5 $ 203 VAR6 $ 204 VAR7 $ 205 VAR8 $ 206 VAR9 $ 207 VAR10 $ 208 VAR11 $ 209 VAR12 $ 210 VAR13 $ 211 VAR14 $ 212 VAR15 $ 213 VAR16 $ 214 VAR17 $ 215 VAR18 $ 216 VAR19 $ 217 VAR20 $ 218 VAR21 $ 219 VAR22 $ 220 VAR23 $ 221 VAR24 $ 222 VAR25 $ 223 VAR26 $ 224 VAR27 $ 225 VAR28 $ 226 VAR29 $ 227 VAR30 $ 228 VAR31 $ 229 VAR32 $ 230 VAR33 $ 231 VAR34 $ 232 VAR35 $ 233 VAR36 $ 234 VAR37 $ 235 VAR38 $ 236 VAR39 $ 237 VAR40 $ 238 VAR41 $ 239 VAR42 $ 240 VAR43 $ 241 VAR44 $ 242 VAR45 $ 243 VAR46 $ 244 VAR47 $ 245 VAR48 $ 246 VAR49 $ 247 VAR50 $ 248 VAR51 $ 249 VAR52 $ 250 ; 251 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 252 run; NOTE: The infile STDATA is: Filename=/home/u62043935/Specialist_Prep_Guide/cert/state_data.txt, Owner Name=u62043935,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=30 October 2022 15:10:58, File Size (bytes)=486 NOTE: 5 records were read from the infile STDATA. The minimum record length was 80. The maximum record length was 80. NOTE: The data set WORK.STATES has 5 observations and 52 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 11079.00k OS Memory 38440.00k Timestamp 04/11/2022 07:31:57 PM Step Count 24 Switch Count 2 Page Faults 0 Page Reclaims 230 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 272 5 rows created in WORK.STATES from STDATA. NOTE: WORK.STATES data set was successfully created. NOTE: The data set WORK.STATES has 5 observations and 52 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.10 seconds user cpu time 0.08 seconds system cpu time 0.04 seconds memory 11079.00k OS Memory 38440.00k Timestamp 04/11/2022 07:31:57 PM Step Count 24 Switch Count 58 Page Faults 0 Page Reclaims 5310 Page Swaps 0 Voluntary Context Switches 392 Involuntary Context Switches 0 Block Input Operations 8 Block Output Operations 384 253 254 proc print data=states; 255 run; NOTE: There were 5 observations read from the data set WORK.STATES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.10 seconds user cpu time 0.10 seconds system cpu time 0.01 seconds memory 6698.71k OS Memory 37808.00k Timestamp 04/11/2022 07:31:57 PM Step Count 25 Switch Count 0 Page Faults 0 Page Reclaims 1505 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 24 256 257 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 268 I used SAS studio on OnDemand to see the .txt file, you can see when I highlight the data you can see that there are many spaces after the text.          ... View more

Hi Stacey   Thank you for the detailed response, although you wrote alot even in your final paraphrase didn't address any of my specific complaints I mentioned regarding to wide to narrow proc transpose, your response in the your final paragraph was very general and rationalise how your course was designed as a whole and did not address   why wide to narrow transpose is only 27 second long with only one slide of a two tables, not explaining of the wide to narrow transpose syntax in video, no full code solution in the activity, wide to narrow transpose is just one of the many many examples throughout the whole course, I only mentioned it because it is the last one I did in lesson 7.    Anyways I have moved onto the prep guide, which is much more detailed and comprehensive. There is full solution to the quiz at the end of chapters. Maybe I am just more suited to the book style.    peace out. ... View more

okay, I just found out that the mod accepted Stacey's response to my criticism of her course as my "solution".    Letting one SAS employee accepting another SAS employee's response as the solution without OP's knowledge is kind of conflict of interest in a so-called "community"?   Happen for the author to response to my criticism, but I have never even read her response before it being labelled as solution. ... View more

I just came back to my log, since when did I accept stacey's response as my solution? Can other people designate solution on OP's behalf?  Sorry I am new to the community so I am not sure how the voting/solution system work.    There shouldn't be a solution, this is a personal log, not a question/answer thread. ... View more

no worries, I will just let it expire. ... View more

week 43 update. Finished Programming 2 yesterday (29th OCT) took me 17.9 hours.  One of the worst experience I had to endure in my life. I can believe SAS Institute thinks it is worth charging $1200 AUD for. In fact I wouldn't even recommend it even if SAS institute pay you to study it, there are much better options IMO.   Just give you a simple example from lesson 7 because the memory is still fresh..   In lesson 7 part 2 on Transpose Procedure, the in part where the course suppose to "teach" you how to turn a wide table to a narrow table, is this how it is taught.. you get a 27 second video with only a diagram like this, and THAT IS LITERALLY IT... with no explanation on the code or syntax or anything.. and then it gets better.. right after the 27 video, you get throw into this shamble SAS institute calls "activity".   So you read the following instruction, then you have to into your SAS studio, find the corresponding sas file, open it, put the var statement, then run it and see the result and figure out how the syntax and the results fit together.   And that's it, that is all the "teaching" you gonna get on proc transpose wide to narrow, then do some difficult practice questions, it's like watch someone hammer a nail then get asked to build a hut with instructions at different places.   And when you do the quiz, you don't have a single page for easy reference where you can see the explanation with code and output/result, you'll have to go into the course, find the activity because the video is useless, find the activity number, then go back your SAS studio, copy the code from the activty insturtion to see the result and all without explanation on any of the syntax/code structure. yeah sorry for the rant, the 18 hours could be much better invested on better materials.      ... View more

another question I have is How come there is no period after the 9 in the LENGTH statement? Since we are specifying a formatting attribute, should it have a period or period is only necessary in the FORMAT statement? ... View more

thanks man. ... View more

Programming 1 and 2 is just like your typical Coursera courses.  Any average book would be superior to these courses in every single way.  I am only doing it to see what the fuss is all about like like Google DA certificate, not very impressed so far. Looking forward to the official SAS base exam prep guide tho. ... View more

To be honest, I don't know SAS expect you to complete the challenges coding with like a 3 minutes ish explanation video. I usually just go straight to the solution and practice with the solution code or skip challenges. ... View more

100% off voucher? ... View more