Is there a way to read in a csv data set that has "." in some cells and replace those with "*"? The things inside the quote marks, e.g., period and star. This is the import statement, I'm sure I can't do it here, probably in a data step.   proc import datafile = "\\folder\data.csv" out=workingdata dbms=csv replace; getnames=yes; run;   The data set came in with "."  I use * to represent suppressed data, and have a footnote explaining the symbol.   If you know how to do this, that would be very helpful.   FYI, I do NOT was to talk about why I'm doing this, why I should not do this, why doing this is never the right thing to do. Those points are not at all helpful.   ... View more

I'm importing two data sets, then combining, but i need to change the length and format of some variables (to combine them with other data sets later). The  problem is i can't seem to get the variables in the right order in the output data set. In particular, in the following, I want to get "year" to be length 20, and format $9., and order in the format statement below. Suggestions?   PROC IMPORT DATAFILE= "\\folder\pa1_demo.xls" out=pa1_demo dbms=xls replace; sheet='pa1_demo'; RUN; PROC IMPORT DATAFILE= "\\folder\pa1_zip.xls" out=pa1_zip dbms=xls replace; sheet='pa1_zip'; RUN; data pa1_00; set pa1_zip pa1_demo; rename Indicator=Ind_id_0 Demographic=Group Category_Description=Characteristics Rate__Percentage=rate_percent year=year_0 ; label Indicator=Ind_id_0 Demographic=Group Category_Description=Characteristics Rate__Percentage=rate_percent year=year_0; run; * bunch of blank lines. Deleting them; data pa1_0; set pa1_00; if Ind_id_0 = "pa1"; run; data pa1; format Ind_id $8. Title $200. Year $9. Group $30. Characteristics $50. Rate_percent 8.1 Low 8.1 High 8.1 Axis $32. Objective 6.1 rate_percent_ci $char18. rate_percent_tx $char5. rev_color 8. Data_Source $200. Footnotes1 $300. Footnotes2 $210. Header2 $32. PA_2024_Objective 6.1; set pa1_0; if ind_id_0 eq "pa1" then ind_id = "pa1_0"; year = put (year_0,9.); drop year_0 Rate__Percentage_Text numerator denominator numerator_text denominator_text category ind_id_0; run; ... View more

Hi all Somewhere in my set up, sas 9.4 has a default of, when starting, look for specific folders.  When I click on the SAS icon, to start, i get errors that two specific folders can't be found. I'm not running any programs. I just click on the icon. Any ideas of where to look at the sas set up? Thanks Gene ... View more