Hello,   thanks for helping me out >"<   I used this: %let dirdata=C:\Users\jc3992\My SAS Data; libname Test "&dirdata"; run; data snow1; set "C:\Users\jc3992\Downloads\snow1.sas7bdat"; proc print data=snow1; run; data work.snow1; length Sep Oct Nov Dec Jan Feb Mar Apr May 8; run; proc transpose data=work.snow1(obs=118) out=test.snow1a name=month prefix=snowfall; var sep--may; by year; run; proc print data=snow1a; run; The LOG:   275 %let dirdata=C:\Users\jc3992\My SAS Data; 276 libname Test "&dirdata"; NOTE: Libref TEST refers to the same physical library as DIRDATA. NOTE: Libref TEST was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\jc3992\My SAS Data 277 run; 278 279 data snow1; 280 set "C:\Users\jc3992\Downloads\snow1.sas7bdat"; NOTE: There were 118 observations read from the data set C:\Users\jc3992\Downloads\snow1.sas7bdat. NOTE: The data set WORK.SNOW1 has 118 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 281 proc print data=snow1; 282 run; NOTE: There were 118 observations read from the data set WORK.SNOW1. NOTE: PROCEDURE PRINT used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 283 284 data work.snow1; 285 length Sep Oct Nov Dec Jan Feb Mar Apr May 8; 286 run; NOTE: Variable Sep is uninitialized. NOTE: Variable Oct is uninitialized. NOTE: Variable Nov is uninitialized. NOTE: Variable Dec is uninitialized. NOTE: Variable Jan is uninitialized. NOTE: Variable Feb is uninitialized. NOTE: Variable Mar is uninitialized. NOTE: Variable Apr is uninitialized. NOTE: Variable May is uninitialized. NOTE: The data set WORK.SNOW1 has 1 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 287 288 proc transpose data=work.snow1(obs=118) out=test.snow1a name=month prefix=snowfall; 289 var sep--may; 290 by year; ERROR: Variable YEAR not found. 291 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set TEST.SNOW1A may be incomplete. When this step was stopped there were 0 observations and 0 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 292 293 proc print data=snow1a; 294 run; NOTE: There were 9 observations read from the data set WORK.SNOW1A. NOTE: PROCEDURE PRINT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds The output SNOW1A still is unsuccessful...   ... View more

hello,   Thanks for replying:)   The data looks like the attached. My code: data snow1; set "C:\Users\jc3992\Downloads\snow1.sas7bdat"; proc print data=snow1; title "snow1"; run; proc transpose data=snow1 out=snow1a; by year; var month=sep--may; run; The LOG showed:   166 proc transpose data=snow1 out=snow1a; 167 by year; 168 var month=sep--may; - 22 200 ERROR: Variable MONTH not found. ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 200-322: The symbol is not recognized and will be ignored. 169 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.SNOW1A may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.SNOW1A was not replaced because this step was stopped. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.33 seconds cpu time 0.01 seconds ... View more

I have no idea either. I used SAS Studio because I am a MAC user. and because many data sets our instructor asked us to do with cannot easily looked through in SAS Studio I changed to SAS Window version yeaterday. I am using computers in our school >"<   I succeeded by this code %let dirdata=C:\Users\jc3992\My SAS Data; libname Test "&dirdata"; run; I thought my problem is I set a new library by right clicking "Libraries" in Exploere and actually I do not need to set up a libname "Dirdata" it can be any libname which I would like to create with a code and the file would appear in the folder "Libraries" and I just define a path as "dirdata" and create a libname in this path. That was what my understanding.   sometimes after one or two sleeps I forget about this and start all over again lol   ... View more

I succeeded!^__^ Thanks for your kind help~~   May I ask you what command I can use if I am going to combine data to some categories. For instance, I have a data set listing every single years, months in every year, and quantity of snowfall for each month in each year, and now I am going to combine these to three columns named "Year" "Month" and "Snowfall" What would you do with this?   Thank you!:) ... View more

Thanks very much!   so, I use my university desk top again to continue, and I encountered problem again. (for previous months I'have used Sas Studio because I use Mac but I got some data sets not easily access so I changed to SAS 9.2 I really need some help..)   The same problem again. It is: %let dirdata=C:\Users\jc3992\MySASData; libname snow "&dirdata"; run; and the LOG is as below:   4 %let dirdata=C:\Users\jc3992\MySASData; 5 libname snow "&dirdata"; NOTE: Library SNOW does not exist. 6 run; I have checked the folder, it showed it does not exist. Would you mind helping me out with this ? I can hardly move on with these issues >"< Thanks!! ... View more

%let dirdata=C:\Users\jc3992\Downloads; libname snow "&dirdata"; run; /*1*/ data snow.snowfall; set "&dirdata.Tmp4.Snow"; Year = INPUT((SUBSTR(Season, 1, length(Season)-3)),4.); ARRAY month (10) Sep--Total; DO i=1 to 10; if month(i)=. then month(i)=0; end; run; Now the data set is in the Tmp4 file in my dirdata file. I want to create a graph of the snowfalls for November December January February and March v.s. Year The part of the data set is as below And after I ran the code, the Log showed as below: 168 %let dirdata=C:\Users\jc3992\Downloads; 169 libname snow "&dirdata"; NOTE: Libref SNOW refers to the same physical library as TMP4. NOTE: Libref SNOW was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\jc3992\Downloads 170 run; 171 %let dirdata=C:\Users\jc3992\Downloads; 172 libname snow "&dirdata"; NOTE: Libref SNOW refers to the same physical library as TMP4. NOTE: Libref SNOW was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\jc3992\Downloads 173 run; 174 175 /*1*/ 176 data snow.snowfall; 177 set "&dirdata.Tmp4.Snow"; ERROR: Extension for physical file name "C:\Users\jc3992\DownloadsTmp4.Snow" does not correspond to a valid member type. 178 Year = INPUT((SUBSTR(Season, 1, length(Season)-3)),4.); 179 ARRAY month (10) Sep--Total; NOTE: The array month has the same name as a SAS-supplied or user-defined function. Parentheses following this name are treated as array references and not function references. ERROR: Variable Sep cannot be found on the list of previously defined variables. ERROR: Too few variables defined for the dimension(s) specified for the array month. 180 DO i=1 to 10; 181 if month(i)=. then month(i)=0; 182 end; 183 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 178:22 178:40 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 181:4 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set SNOW.SNOWFALL may be incomplete. When this step was stopped there were 0 observations and 3 variables. WARNING: Data set SNOW.SNOWFALL was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds May I ask what did it mean by "a valid member type"? And what can I do to "Array" command to make this work?   Any suggestions and hints would be much appreciated!   Thanks very much! ... View more

It worked after I struggled the whole afternoon lol Thanks so much!! ... View more

May I ask you that, for this data set, I cannot see its full length before using Proc Print, but I do not know how. Would you please giving me some hints?   Thanks very much>"< ... View more