INTNX() will allow you to get the last day of the month using the alignment parameter. Use the first as your day and then use the 'e' as the last parameter to increment to the end of the month. last_month = intnx('month', today(), 0, 'e'); This would return March 30, 2020. ... View more

@ambadi007 wrote: Dear Experts ,   I am creating a Statistics summary for the visits ,   eg:- Visit 1 - N SD Mean Median Q1 Q3 MIn Max  visit 2  -N SD Mean Median Q1 Q3 Min MAx   I can create taking each visits and find the statistics using Proc means , but the problem is I need a dynamic code that find if any other visits also occurs in future and then the respective statistics  PROC MEANS will figure out how many visits are present in your data set, and then compute the statistics for each visit in the data set. You need to use the CLASS statement. https://documentation.sas.com/?docsetId=proc&docsetVersion=9.4&docsetTarget=p0gpxoqczfzcyln13ma53kpq38lo.htm&locale=en ... View more

please try   data orders; input order_date:date9. order_id Total_retail_price; month=month(order_date); format order_date date9.; cards; 02JAN2007 1241054779 195.60 03JAN2007 1241063739 160.80 04JAN2007 1241066216 306.20 06JAN2007 1241086052 37.80 13JAN2007 1241147641 362.60 23JAN2007 1241235281 72.60 24JAN2007 1241244297 258.20 24JAN2007 1241244297 81.20 24JAN2007 1241244297 358.20 25JAN2007 1241263172 102.40 25JAN2007 1241263172 113.20 28JAN2007 1241286432 174.40 29JAN2007 1241298131 37.40 05FEB2007 1241359997 117.60 07FEB2007 1241371145 656.60 07FEB2007 1241371145 129.00 09FEB2007 1241390440 36.20 16FEB2007 1241461856 29.40 28FEB2007 1241561055 192.00 06MAR2007 1241623505 46.90 09MAR2007 1241645664 150.10 09MAR2007 1241652707 140.70 13MAR2007 1241686210 32.60 16MAR2007 1241715610 16.90 18MAR2007 1241731828 22.70 18MAR2007 1241731828 41.50 25MAR2007 1241789227 121.00 05APR2007 1241895594 24.400 05APR2007 1241895594 13.50 07APR2007 1241909303 107.30 09APR2007 1241930625 58.70 09APR2007 1241930625 56.30 09APR2007 1241930625 90.00 15APR2007 1241977403 19.10 18APR2007 1242012259 231.60 18APR2007 1242012259 19.20 18APR2007 1242012269 142.40 18APR2007 1242012269 73.80 21APR2007 1242035131 147.10 25APR2007 1242076538 57.30 01MAY2007 1242130888 160.50 02MAY2007 1242140006 31.40 02MAY2007 1242140009 16.40 02MAY2007 1242140009 192.40 03MAY2007 1242149082 14.30 03MAY2007 1242149082 56.80 04MAY2007 1242159212 46.60 ; run; proc sort data=orders; by month order_date; run; data want; set orders; by month order_date; retain cum_sum; if first.month then cum_sum=Total_retail_price; else cum_sum+Total_retail_price; run; ... View more

I had the exact same problem. I switched printer preferences while having SAS open.    Closed program and re-ran same code and it worked just fine.  ... View more

@ambadi007 wrote:     My client is saying the input files will be coming in the below format   The files we are getting will be ~ delimmited and with no text qualifires and the freq is none   could you please explain me what is text qualifires and the freq is none  ? Here is an example of comma delimited with "quote qualified text" Column1, Column2, Column3 12345,"qualified, as this has a comma in the value",oneword Generally the quote qualifiers come in when the delimiter may appear as a value inside a variables value.   If a delimiter that does not appear in the values is use then the qualifier wouldn't be needed so if the delimiter is changed to a pipe character | which does not appear in text written by people very often you could have Column1, Column2, Column3 12345|qualified, as this has a comma in the value|oneword So the second column with the same text no longer needs the " " to protect the comma in the value.   Ideally the file supplier would tell you want each of the columns in the data represent, expected lengths of variables and whether the values are actually numeric (to calculate with) or not. The example column1 could be an identifier such as an account number which should not be numeric (especially if 16 or more digits long) as it is not numeric. Dates and such should also have the format specified.   Also stumped on the "freq is none". ... View more

See sample code below. It uses the macro facility to create the foldername. Then a LIBNAME statement together with the DLCREATEDIR system option is used to create the actual folder on the filesystem.   options dlcreatedir; %let todayFolderName = %sysfunc( today() , yymmddd10.); libname _cdir "c:\temp\&todayFolderName"; libname _cdir clear; Depending on your SAS version have a look at the DCREATE function as well.     ... View more