If I have a data with these variables:   product   year   sales_jan   sales_feb   sales_mar....sales_nov   sales_dec   How can I transpose it to something like this?   product   year   month   sales   Month is a number (1-12).Thank you. ... View more

I have a character variable that takes on the following values.   A 111 C111 AB 1234 D311 A/B AA A1212 BC 123 D123 CSA JJK P00   I would like to grab the number between the first and second space, if that part is indeed a number. I would like to get: 111 1234 . 123 .   How can I achieve this? Thanks. ... View more

Say I want to define a macro variable "num" to be 10 to the negative 2 power (0.01). I do:   %let num=%eval(10**(-2)); %put &num.;   but I get   %put &num.; SYMBOLGEN: Macro variable NUM resolves to 0 0    What's wrong here? Thanks. ... View more

I have a csv file with some non-English characters in it. Using data infile in regular SAS, once the foreign character is encountered, the system stops reading in more data and ignores the remainder of the dataset, resulting in a large chunk of the file not imported. I then tried the same code under SAS 9.4 with unicode support, which seems to read in the correct number of rows. The problem is when I try to save it as a dataset on a pre-defined library:   "ERROR: Some character data was lost during transcoding in the dataset lib1.dat1. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding." and  "WARNING: The data set lib1.data1 may be incomplete. When this step was stopped there were x observations and y variables." x is way less than the number of records in the dataset in the work library.   Is this because dataset is currently in unicode and needs to be converted to regular coding somehow before it can be saved and used? Thanks. ... View more

Let's say I define %let person=John James Doe   How do I substitue the spaces with underscores, so I get the following effect, without typing the person's name? %let person=John_James_Doe;   Thanks. ... View more