Hello,    I wrote a SAS code to import a raw file which looks something like the attached snapshot in the end data WORK.UPCS_FILE ; infile 'temp_all.upcs' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=3 ; input xab 1-6 UPC 9-20 UPC_Desc$ 22-51 size$ 52-64 MUP 67-69 date 70-76 storeweeks 78-87 caus_sw 88-92 median_price 93-99; run; . The output data looks perfectly alright except the fact that the last column (median price) comes out blank for quite a few observations. e.g below   xab UPC UPC_Desc size MUP date storeweeks caus_sw median_price 1 1724 '99' 1.0 LTR 1.000 LTR 12 0 129 0   2 4091 '99' 1.0 LTR 1.000 LTR 12 0 78 0   3 1586 '99' LIGHT 1.0 LTR 1.000 LTR 12 0 76 0   4 4024 '99' LIGHT 1.0 LTR 1.000 LTR 12 0 38 0   5 44872 1 BARREL RUM 1.0 LTR 1.000 LTR 12 0 7 0   6 27148 1 BARREL RUM 750 ML 750.000 ML 12 0 123 0     I am also attaching a snapshot of raw data. I can't copy paste the raw data here because it looses format.    ... View more

Hello All,   Good evening.    I am working on a code in which I have to reproduce all observations in loop (max iteration of loop will be decided by number of observations) in such a way that each variable value is reproduced against all values and so on.   have Apple Orange Banana   Want Apple, Apple Apple, Orange Apple, Banana Orange, Apple Orange, Orange Orange, Banana Banana,Apple Banana, Orange Banana, Banana   The number of observations in "have" list can change each time.   Please help! ... View more

Hello,   Good Evening.   I am trying to extract date from a string variable. The variable is called period_desc. It looks like below. I want the date part out of it in mmddyy6. format or any other date format.    period_desc 1 WEEK ENDING 10/28/2017 1 WEEK ENDING 11/04/2017   I want just the date part out of it. Here is what I have done so far. i did proc contents to check the type of variables that are being produced and it doesn't seem to be doing the job. P.S I used this code after reading it on this forum but not working for me.  # Variable Type Len Format 4 DATE Num 8 MMDDYY10. 3 DATE1 Char 24   2 period_desc Char 24   1 period_id Num 8     Please help! data period ; infile "&input_dir_path.us_period.csv" delimiter = '|' MISSOVER DSD lrecl=32767 firstobs=2 ; input period_id :best12. period_desc :$24. period_type :$4. period_start_date :yymmdd10. period_end_date :yymmdd10. load_execution_id :best12. last_update_datetime :datetime.; run; data period_formatted (keep=period_id period_desc DATE1 DATE); set period; DATE1 = trim(substr(period_desc,14,11)); DATE = input(DATE1,MMDDYY10.); format DATE mmddyy10.; run; ... View more