topic Re: Trouble with SAS on demand. in SAS Programming

Trouble with SAS on demand.

FrustratedBio — Thu, 24 Jun 2021 19:44:43 GMT

Data Florida;
set work.projectdat;
if State_Province_Of_Loss= 'FL';
/*if Recordable='Yes';*/
run;

Hello, is anone else having issues with the new SAS stuff. I reuploaded my codebook and related files but for some reason my code isn't working like it did before. The if statement in particular. I can see the variable in the uploaded data but when I try to perform this action it doesn't work.

Re: Trouble with SAS on demand.

FrustratedBio — Thu, 24 Jun 2021 19:51:23 GMT

The varible name in excel is State/Province of Loss.

Re: Trouble with SAS on demand.

Kurt_Bremser — Thu, 24 Jun 2021 19:51:30 GMT

Please post your log.

Re: Trouble with SAS on demand.

FrustratedBio — Thu, 24 Jun 2021 19:53:26 GMT

Re: Trouble with SAS on demand.

FrustratedBio — Thu, 24 Jun 2021 19:54:46 GMT

Re: Trouble with SAS on demand.

FrustratedBio — Thu, 24 Jun 2021 19:55:43 GMT

this is the problem. A variable name that used to work before their update, now when ran produces no data. Makes no sense. I can get the data uploaded but can't manipulate it.

Re: Trouble with SAS on demand.

Reeza — Thu, 24 Jun 2021 19:56:11 GMT

What does your log show? What happens if you run a proc contents on your input data set?

Did you re-setup any autoexec that you may have set in SAS UE? Such as options validvarname?

Re: Trouble with SAS on demand.

Kurt_Bremser — Thu, 24 Jun 2021 19:58:42 GMT

The first NOTE tells you that the variable is not present in the dataset. If you work with VALIDVARNAME=ANY, the import will keep the original name, which means you have to use a name literal:

'State/Province of Loss'n

Re: Trouble with SAS on demand.

FrustratedBio — Thu, 24 Jun 2021 19:58:49 GMT

The proc contents step runs as normal. Same number of observations, same everything. I'm having problems with variables name "X"_"X"....which until the update was the way I believed I was supposed to format multi-word variable names. Like I said, it worked perfectly before the update.

Re: Trouble with SAS on demand.

Reeza — Thu, 24 Jun 2021 20:08:03 GMT

Go to your autoexec. Add this line of code, save the file and then restart & re-run everything.
Or put it at the top of your program to try it first.

options validvarname=v7;