I want to count records from previous month and add it next to current month I.e. display all this information in a table. Id CurrentMonth Previousmonth currentCount previouscount 1 Jan Dec 10 15 2 Feb Jan 7 10 3. Mar Feb 2 7 4 Apr Mar 12 2 Thank you ... View more

I want to import a file into SAS Dataset. The file is in (.DAT) format. The file does not have delimiter. However I do know the position of the data.   eg. Data in the file is as below  D12302020.....745639200.89USD.......ACCOUNTNULL12354596895...CHN.........   Position information provided is as below  Field                        Data Length            Data Type Record Type                  1                          Char Date                               8                          Date Code                              6                          Number Amount                          11                        Decimal Country                           3                        Char     The data should be in output in this way  Col1         Col2           Col3            Col4              Col5 D           12302020        7           45639200.89    USD   So based on the start and end position of the string I should be able to separate the columns, i.e. Col1 position(1), Col2 position (2-9), Col3 position(10-15) etc. however I am unable to do import the data into the table.  ... View more

I want to do a sum of count of 3 tables.   Table 1  ColumnA 12 10 5 6   Table 2  ColumnB 8 13 34   Table 3 ColumnC 20 2 24 1 17   I want to do a sum of the count of the 3 tables i.e.  Sum (count(ColumnA) + count(columnB) + count(columnC)) as "Final Sum" Sum (4 +3 +5)   My final output should be Final Sum 12             ... View more

I have a string :20:catclimbedthetree:STOP:dogranaftercat:STOP:catwasinthehouse:-   I want to delete everything after the 2nd :START: and also delete :START: i.e. the desired output is as below, what should I do? I used index function and substr but it is truncating all the characters after the first :START:. Please help.    :20:catclimbedthetree:START:dogranaftercat   Thank you   ... View more

I am running the below query and I keep getting the error   data A; set B; length str_2 $1000 if ( startpos = index(str_1, "START") and  endpos - index(str_1, "STOP") ) then  str_2 = substr(str, startpos+7, endpos-(startpos+7)); str_1 = cats(substr(str_1, 1, startpos), substr(str_1, endpos)); else str_1; run;   I am getting the below error:   Error: No matching ID-THEN clause Error: Statement is not valid or it is not used out of proper order.   What am I doing wrong?   ... View more

I have 2 datasets    Dataset country 1  USA               Blue          32 2  UK.               Red           15 3  Australia       Green        52 5  Africa            Yellow        44   Dataset animal 1     15        Deer 2     52        Kangaroo 3     44        Lion 4     32       Bison     How do I use this lookup table to get the below output in the country dataset   Dataset country 1  USA               Blue          Bison 2  UK.               Red           Deer 3  Australia       Green        Kangaroo 5  Africa            Yellow        Lion   ... View more