Hi Guys,  I need a command used to populate a variable as numeric in datasets. The visit number variable for a visit 99.1.01 is considered as character variable in SAS program since it has 2 decimal values. I need to populate this value (99.1.01) as a numeric value. Kindly suggest me how to move forward with it. There are totally 8 other variables which are working fine. Only the VISIT variable has issue. I have pasted the program below.   data datadir.ABCD; label STUDY = 'Study Code' SUBJECT = 'Enrolment Code' VISIT = 'Visit Number' SPECDAT = 'Date of Collection' SPECTIM = 'Time of Collection' SPECID = 'Specimen ID' PROTSCHD = 'Protocol Schedule' COMMENTS = 'Specimen Comments';   length STUDY $11. SUBJECT $8. VISIT 8. SPECDAT $10. SPECTIM $5. SPECID $20. PROTSCHD $20. COMMENTS $200.;   infile datafile delimiter = '|' dsd missover lrecl=2000; input STUDY SUBJECT VISIT SPECDAT SPECTIM SPECID PROTSCHD COMMENTS;   run:   Many Thanks, Harsha ... View more

Hi All, I need a SAS program which extract only two variables from a dataset (.dat, .txt or .cum file) that has more than 30 variable data.  For Example: An input .dat file contains 25 variables. However i want to pull only the 18th and 22nd variable in my SAS output file. Condition is I dont want to define all 25 variables in my SAS program. Only the 2 variable names, length and position should be mentioned in program. Basically, I need this program for a QC purpose wherein - if one variable has a value, then the second should be Blank. If both values are present then such data is of interest. Its a kind of filter that is required. I can use the IF and ELSE statement to populate or delete the data in output. However not sure how to filter the larger data into only area of interest.  I have attached a sample .dat file. Kindly request to provide a solution for my requirement.   Thanks, Harsha ... View more