Hi SAS friends, I have some code I've written using data-step but after many hours of troubleshooting i can't get it to work in Macro language. can you 'convert' it for me? %macro Get_DataSets(date,date2);   %put &date.;   %put &date2.; %mend Get_DataSets; data dates; length date2 $8.;   do i=1 to 9;    date=intnx('month','01MAY2013'd,i);     year=put(year(date),$4.);   month=put(month(date),z2.);   date2=compress(year||"_"||month);   %Get_DataSets(date,date2);    output;   end;   format date monyy.;   keep date date2; run; i  wanna call a macro within a macro but I can't figure out how to send my two macro variables to %Get_DataSets Thanks! ... View more

I'm trying to import clickstream data but i have a field that has multiple commas. i know that the next field always starts with double quotes. maybe there is a scan solution for this? Here is what i'm using to import: data Sample                       ; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */   infile 'E:\Jeff B\Open\ClickStream\Sample.txt' delimiter = ',' MISSOVER DSD lrecl=32767 ;   informat Date  date11.;   informat DateTime time. ;   informat IP $15. ;   informat DOM $50. ;   informat DOM_SUB $255. ;   informat DEV $255.;   informat DUR best12.;   format Date date9. ;   format DateTime time18.3;   format IP $15. ;   format DOM $50. ;   format DOM_SUB $255. ;   format DEV $255.;   format DUR best12.;   input   Date   DateTime   IP $   DOM $   DOM_SUB $   DEV $   DUR; if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */ run; *please note that record #3 and #7 are not being read in correctly; Thanks -- Sample data attached. I've attached the full data set. ... View more

Hi friends in SAS, I want to get output for each var on the var statement for proc summary. for example: proc summary data = sashelp.class;   var age height;   output out =want min=MIN max=MAX; run; will give me the min and max for age but not height. how can i get them both in one dataset? as always, thank you! ... View more

Hi All, I'm trying to forecast a non-seasonally adjusted unemployment rate but when run through the Time Series Forecasting System i get an error that says " ERROR: The estimation algorithm did not converge after 150 iterations. ERROR: Forecasting was not performed because estimation was not done. " The source for my data comes right form the LAUS BLS webpage. any hints? Thanks! ... View more

Hi SAS friends, I want to import a CSV file but I have a field  (CBSA_NAM) that contains multiple comma's as part of the text string but is identified by SAS as a delimiters. Ultimately i get an extra column created (VAR31) for some records. any workarounds for this? Thanks! Here is the code i'm using to import and a snippet of the file attached. data WORK.CLARITAS_2010; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */   infile "E:\Jeff B\Open\Data Pull for Paul\CSV Import.txt" delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;   informat Geo_Id $1. ;   informat ID $12. ;   informat G3 $2. ;   informat COUNTY $3.;   informat G34 $5. ;   informat G32 $6.;   informat BG $1.;   informat GCMSA $5. ;   informat GCCBS $5.;   informat GCAZP $5.;   informat G11 $5. ;   informat DMACODE $5.;   informat CD $5. ;   informat ST_F_NAM $30. ;   informat CTY_FNAM $30. ;   informat CBSA_NAM $50. ;   informat GEO_CODE $20.;   informat LAT $13. ;   informat LON $13.  ;   informat HOUSEHLDSC best32. ;   informat HAGE15_24C best32.  ;   informat HAGE25_34C best32.  ;   informat HAGE35_44C best32. ;   informat HAGE45_54C best32. ;   informat HAGE55_64C best32. ;   informat HAGE65_74C best32.  ;   informat HAGE75_84C best32. ;   informat HAGE_85P_C best32.  ;   informat MAGE_HHR_C best32. ;   informat AVAGE_HH_C best32.  ;   informat VAR31 best32. ;   format Geo_Id $1. ;   format ID $12. ;   format G3 $2. ;   format COUNTY $3.;   format G34 $5. ;   format G32 $6.;   format BG $1.;   format GCMSA $5. ;   format GCCBS $5.;   format GCAZP $5.;   format G11 $5. ;   format DMACODE $5.;   format CD $15. ;   format ST_F_NAM $30. ;   format CTY_FNAM $30. ;   format CBSA_NAM $50. ;   format GEO_CODE $20.;   format LAT $13. ;   format LON $13.  ;   format HOUSEHLDSC best32. ;   format HAGE15_24C best32.  ;   format HAGE25_34C best32.  ;   format HAGE35_44C best32. ;   format HAGE45_54C best32. ;   format HAGE55_64C best32. ;   format HAGE65_74C best32.  ;   format HAGE75_84C best32. ;   format HAGE_85P_C best32.  ;   format MAGE_HHR_C best32. ;   format AVAGE_HH_C best32.  ;   format VAR31 best32. ;   input   Geo_Id $   ID $   G3 $   COUNTY $   G34 $   G32 $   BG $   GCMSA $   GCCBS $   GCAZP $   G11 $   DMACODE $   CD $   ST_F_NAM $   CTY_FNAM $   CBSA_NAM $   GEO_CODE $   LAT $   LON $   HOUSEHLDSC   HAGE15_24C   HAGE25_34C   HAGE35_44C   HAGE45_54C   HAGE55_64C   HAGE65_74C   HAGE75_84C   HAGE_85P_C   MAGE_HHR_C   AVAGE_HH_C   VAR31   ; if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */ run; ... View more

Hi SAS friends,      I have multiple datasets that i would like to send to proc summary. I can get the dataset names into a macro variable but can't quite figure out how to send it to proc summary. below is pseudo code, thank you. data class1 class2;   set sashelp.class; run; proc sql noprint;   select memname into: list separated by ' '   from dictionary.tables   where libname = 'WORK' and memname contains 'CLASS'; quit; proc summary data = &list.;   var _numeric_;   output out = &list._sum sum=; run; ... View more