About mmhxc5

mmhxc5 · ‎01-27-2019

@Tom, Thank you for your reply. This is what I wrote. %Let path =E:\Desktop\Idaho; data want; length filename $200; input "&path/ID*.txt" dsd filename=filename truncover; input @; year = input(substr(scan(filename,-2'./\'),3,4.); input Year; run; and the following is the error I am getting.

mmhxc5 · ‎01-26-2019

Hi, I would like import several comma delimited .txt files at once with names ID1992, ID1993, ..., ID2017, add variable YEAR from 1992, to 2017 based on the file name for each file and export it back as its original file, that is .txt. I appreciate your time and help. Thanks,

mmhxc5 · ‎01-12-2019

Thank you everyone for your time and help! Appreciated!

mmhxc5 · ‎01-12-2019

@novinosrinthank you for your reply. The inspection year variable contains only the year and is stored as Char $15. . I want to change its type to date type. If I use the date type as a variable it shall be considered as date not char of numeric. your code changed the char to numeric which is not the type I want. Thank you!

mmhxc5 · ‎01-12-2019

Hi dear members, I have a column variable for the year of inspection since 1992 up to now stored as char $ 15. 1992 1993 . . . 2017 ; I would be grateful if anyone could help me to convert this to date(only year) and use it as variable for x-axis. Thanks,

mmhxc5 · ‎01-09-2019

Thank you for your time. I found out the problem was with bridge observations less than 10. When I deleted bridges with less than 10 observations your code worked. Also, When I only replaced 10 in your code with 5 as follows, the code worked with observations less than 10 too. Does it affect my trimming in the wrong way if I do this? if count ge 5 then do; Thank you for your help. Could you please give comment about the your code that I could learn from it, specially the array part and if-else part. Thanks alot! I really appreciate it.

mmhxc5 · ‎01-08-2019

Thank you for you help. I run your code and the result was different from what I described in my first post. Please read my first post and let me know if there is need for clarification. Thanks,

mmhxc5 · ‎01-08-2019

Thank you for your help. I run your code and the result was different from what I described in my first post. I would be happy if you could read my first post to revise your code. Thanks,

mmhxc5 · ‎01-08-2019

Thank you for your reply. I don't want to delete the first five and last five identical observations for a bridge. But, I want to delete observations that is changed within first five and last five observations. For example if the first five or last five observation for a bridge is ( 7 7 7 7 7) I will retain all of them. But if the first five observation for a bridge is (8 8 8 7 7), I want to delete the first three observations which is (8 8 8). Similarly, if the last five observation is (6 6 6 6 5), I want to delete the last observation which in this case is 5. Thank you for your help!

mmhxc5 · ‎01-08-2019

Hi, I have a dataset of records for bridges (attached), each bridge has its own structure number given as STRUCTURE_NUMBER_008, and the dataset is ordered based on STRUCTURE_NUMBER_008 and Inspection_year. The frequency each bridge is recorded is different as seen in the last column variable Freq. The variable SUPERSTRUCTURE_COND_059 can take rating number of 4, 5, 6, 7, and 8. I would like to trim the dataset for each bridge based on the following condition. If the first 5 rating or last five rating for each bridge for variable SUPERSTRUCTURE_COND_059 is identical (e.g., 4 4 4 4 4 or 6 6 6 6 6, ...) I want to retain all the observations with the middle observations. But if the first five rating for each bridge for variable SUPERSTRUCTURE_COND_059 is different (e.g., 4 4 4 4 5 or 7 7 6 6 6 or 8 7 7 7 7) I would like to delete the observations encountered first. For the example above I want to delete 4 4 4 4 or 7 7 or 8 and retain the remaining observation with the middle observations for the bridge. if the the last five observations for a bridge is (e.g., 4 4 4 4 5 or 7 7 6 6 6 or 8 7 7 7 7), I want to delete observations that is changed, which in this case I would delete 5, 6 6 6, or 7 7 7 7. I would be grateful I anyone could help me on this. The data set is attached. Thanks,

mmhxc5 · ‎01-07-2019

Thank you @novinosrin, @Ksharp, @Rick_SAS, and @art297 for your help. Appreciated. @art297 your clarification was very helpful.

mmhxc5 · ‎01-07-2019

Thank you for your timely reply. I really appreciate it. There is only two data calling in your code, "sample" and "want". How can I link this code to the Bridge dataset I have? I mean, which part of your code will call the bridge dataset which has all the data that I want to process?

mmhxc5 · ‎01-07-2019

Thank you for your timely reply. I really appreciate it. Based on your code I created a "Sample" data, then I defined the "want" and also the set "sample" to the end of your code. How can I link this code to the Bridge dataset I have? I mean, which part of your code will call the bridge dataset which has all the data that I want to process?

mmhxc5 · ‎01-04-2019

Thank you for you response. Your code only removes the first five and last five observation of the whole dataset which is over 3000 observations. What I want is to remove first five and last five observation for each bridge which has 25 observation each. The dataset of 120 bridges makes the 3000 observations. I only want to retain the middle 15 observation for each bridge. The STRUCTURE _NUMBER_008 is a mix of character and numeric. The dataset is ordered based on the STRUCTURE_NUMBER_008 and Inspection_Year. Thanks,

mmhxc5 · ‎01-03-2019

Hi, I have a dataset of over 3000 observations for bridges inspected since 1992 -2017. Each bridge is inspected once each year. I would like to delete the first five years and last five years of inspection result for each bridge. Chosing STRUCTURE_NUMBER_008 or Inspection_Year might work as the variable to delete, because the beginning and last year of inspection is not the same for all bridges. The attached image shows two bridge IDs sorted by STRUCTURE_NUMBER_008 (First column) and Inspection_Year(Last column). STRUCTURE_NUMBER_008 is random name given for each bridge. I would be glad if anyone could help me to do this task. I use SAS 9.4 in Windows 10 and I have the dataset as permanent SAS files. Thanks,

Online Status	Offline
Date Last Visited	‎02-08-2021 08:45 PM

How to plot only a specific stratum from proc PHREG

How to combine multiple select statements under one PROC SQL

merge by two variables produce zero ouput observation

Re: choosing a value conditional on two different variables

Re: choosing a value conditional on two different variables

choosing a value conditional on two different variables

Re: Remove a specific letter and only the number following it

Re: Remove a specific letter and only the number following it

Re: Remove a specific letter and only the number following it

Re: Remove a specific letter and only the number following it

Re: Remove a specific letter and only the number following it

Re: How to attach the second variable value to make the first variable...

Re: Printing programs in color

Re: how to get mean of each step of a step function

Re: Replace a variable name conditionally

How to use black and white fill patterns for bar graphs in ODS Graphic...

Replace a variable name conditionally

Re: How to add a variable column based on the filename

How to add a variable column based on the filename

Re: Character $ 15. to date conversion

Re: Character $ 15. to date conversion

Character $ 15. to date conversion

Re: Conditional data trimming

Re: Conditional data trimming

Re: Conditional data trimming

Re: Conditional data trimming

Conditional data trimming

Re: How to delete first five and last five observations from a dataset

Re: How to delete first five and last five observations from a dataset

Re: How to delete first five and last five observations from each vari...

Re: How to delete first five and last five observations from each vari...

How to delete first five and last five observations from a dataset