Thanks. Interesting code I will keep around. I had the same results. MM ... View more

I wondered if this could be one of your help datasets like the car dataset? MM ... View more

Yes. I get a very interesting description of the data set but no data? I have looked at it in SAS U Editon and JMP.   MM   ... View more

Hi,   I am learning about tidy data. It is a game-changer Sep--May and year are columns in my data set. I want a panel of 6 plots which is different from a matrix of 9 cells.   MM   SAS CODE: proc sgpanel data=MYDATA; panelby year Jan Feb Mar; scatter y=Feb x=Jan; scatter y=Mar x=Jan; scatter y=Mar x=Feb; reg x=year y=Jan; reg x=year y=Feb; reg x=year y=Mar; reg x=Jan y=Feb; reg x=Jan y=Mar; reg x=Feb y=Mar; run;   ... View more

Reeza,   I need to include those scatterplots a well. I will try adding more statements.  Thanks.  MM   ... View more

I am in a classroom and don't want to affect my professor's class. I need the data sent to SAS communities to be deleted. Can you help with that? I have great books on SAS but sometimes the syntax eludes me. Mary A. Marion ... View more

Hello,   I successfully read in the data as A--K but since I have to merge this data set with 3 other datasets with different variables ( not B--K), I am not sure this is the best way to go. How to read in this data using long file names as opposed to using letters? I am using label statements. If I use this technique for other files there will be multiple  B's ..K's whose contents differ.  Current working code is given below.   Thank you. MM   data nypop ; informat A $30. B C D E F G H I J K comma10.; infile '/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv' DSD firstobs=2; input A B C D E F G H I J K ; format A $30. B C D E F G H I J K comma10.; label A='Geographical Area' B='Total Population' C='Total One Race' D='White' E='Black or African American' F='American Indian and Alaska Native' G='Asian' H='Native Hawaiian and Other Pacific Islander' I='Some other race' J='Two or more Races' K='Hispanic or Latino(of any race)'; run; proc print data=nypop label; run;     ... View more

hi,   The following code ran: data ny; informat A $30. B C D E F G H I J K comma10.; infile '/folders/myshortcuts/611/data/Week 03/HWdata/nypopulation.mm.csv' DSD firstobs=2; input A B C D E F G H I J K ; format A $30. B C D E F G H I J K comma10.; run; Thank you. I will be deleting this post tomorrow.  MM   ... View more

NOTE: Invalid data for K in line 1 21-21. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+---- 1 A,B,C,D,E,F,G,H,I,J,K 21 A=A B=. C=. D=. E=. F=. G=. H=. I=. J=. K=. _ERROR_=1 _N_=1 NOTE: 63 records were read from the infile '/folders/myshortcuts/611/data/Week ... View more