Hi, I I want to exclude last month from a dynamic date (The time frame keeps changing) e.g. if I select quarter 1 (i want to exclude March data) if I select a year from Jan to Dec - I want  to exclude Dec data, or if I select data from Feb to May I want to exclude May from the results so exclude last month every time a user selects a time frame.   Have: Date Goal 1-Feb 0 2-Feb 1 3-Feb 1 4-Feb 1 1-Mar 1 2-Mar 1 3-Mar 0 4-Mar 0 5-Mar 1 6-Mar 1 1-Apr 0 2-Apr 1 3-Apr 0 4-Apr 1 5-Apr 0 6-Apr 0   Want (Exclude last month) it could  be any in this example its April  Date Goal 1-Feb 0 2-Feb 1 3-Feb 1 4-Feb 1 1-Mar 1 2-Mar 1 3-Mar 0 4-Mar 0 5-Mar 1 6-Mar 1                         ... View more

Hi, I want to rename a variable in my data tables. I have 50 data sets. The field in all tables has the same starting name "Table_" etc. example: Table_1 in data set 1 Table_2 in data set 2 Table_3 in data set 3   I want to use a single rename statement in a macro to rename all "Table_:" to "ID_Number" I tried using wild card ":" but it did not change it.   I used this code: rename Table: = Id_Number;   Thank you ... View more

Hi, I am trying to import a csv file in SAS using data step, but I want SAS read the variables as I order them e.g. Have: Var3 Var2 Var1 Cat 44 Grade 1 Dog 22 Grade 3 Bird 5542 Grade 9   Want: Var1 Var2 Var3 Grade 1 44 Cat Grade 3 22 Dog Grade 9 5542 Bird   When I tried to rearrange the order of variables , SAS is importing/reading it incorrectly - here is the output from SAS - Its putting the rows under different headers like this - Notice Var1 and Var3 : Issue: Var1 Var2 Var3 Cat 44 Grade 1 Dog 22 Grade 3 Bird 5542 Grade 9   How do I fix this without sorting the vars in the csv file Thank you ... View more

Hi, I am trying to delete the first 3 rows and rename variables from my data sets. How can I use 1 statement that applies to all my data sets, I have 42 files.   All my filename start with "_" I tried something like this but you can tell I don't know how it can be done:   data _: ; set _: ; rename first = First_name; run;     Thank you   ... View more

Hi, I need help with creating a flag whenever there is the first occurrence of value >180, and order the subsequent values that are >18  Have: id date Value 1 First_date 113 2 next_2 97 3 next_3 86 4 next_4 138 5 next_5 193 6 next_6 90 7 next_7 197 want:   id date Value Flag > 180 values in that order 1 First_date 113 0 2 next_2 97 0 3 next_3 86 0 4 next_4 138 0 5 next_5 193 1 6 next_6 90 0 7 next_7 197 2 Thank you, I will appreciate your help. ... View more

Hi, I am a beginner to intermediate SAS user and need help.   Here is a sample excel file that I want to import in SAS: This is a sample file           This is a sample file           This is a sample file     This is a sample file     School A     Class Grade Pass 1 A Yes 2 B Yes 3 E No This is a sample file           This is a sample file           This is a sample file     This is a sample file     School B     Class Grade Pass 4 A Yes 5 E No 6 E No   I want SAS to read the data every time it hits the column header "Class" so the final data looks like a clean SAS data set with single column header and all the data and delete the rows in between:   Class Grade Pass 1 A Yes 2 B Yes 3 E No 4 A Yes 5 E No 6 E No   Thank you ... View more