topic Re: I need to manipulate a previous sas program in New SAS User

I need to manipulate a previous sas program

zhawasli1 — Tue, 22 Mar 2022 16:10:19 GMT

How do I format an old sas program that has one column of a list of different variables that need sorting. Especially if the variables have a period in their names? I hope you understood. Thank you.

Re: I need to manipulate a previous sas program

zhawasli1 — Tue, 22 Mar 2022 16:14:47 GMT

the question goes for finding a confidence interval for these variables that are categorical variables and when i did proc contents there was only one variable listed instead of the five different variables that are in the old sas program. So I need to resort the program so it shows that there are five different variables instead of one and need an analysis of that data after its been manipulated. I think I know how to do the analysis part but I'm having trouble with formatting the old information.

Re: I need to manipulate a previous sas program

zhawasli1 — Tue, 22 Mar 2022 16:15:48 GMT

Re: I need to manipulate a previous sas program

ballardw — Tue, 22 Mar 2022 16:51:07 GMT

Show the program.

Variables typically do not have periods in their names. That would require creating variables with the System option VALIDVARNAME set to ANY and would require referencing them as name literals such as 'stupid.variablename'n

Re: I need to manipulate a previous sas program

zhawasli1 — Sat, 26 Mar 2022 14:29:26 GMT

Re: I need to manipulate a previous sas program

Tom — Sat, 26 Mar 2022 21:04:11 GMT

You posted a screenshot of something that seems to be showing a variable named TYPE. Type looks like it is a character variable with values that contain periods.

Do you have a quesiton?

Re: I need to manipulate a previous sas program

zhawasli1 — Sat, 26 Mar 2022 23:34:54 GMT

Yes, in this sas program under the proc contents it says one variable, There are actually 206 observations with 5 different variables written in the same column. How do I tell SAS that I need it to pick out each variable and count how many observations are for each variable?? Thanks

Re: I need to manipulate a previous sas program

Tom — Sun, 27 Mar 2022 03:30:59 GMT

You seem to be having a lot of trouble explaining what you want. It does not help that you appear to be using two different definitions of the word variable at the same time. In SAS a dataset has one or more variables. The dataset can have multiple observations. Each observation in the dataset has one value for each of the variables.

Perhaps you are asking how to parse a string into multiple values? If you have variable with values like

B1.1.2
B2.2.3

And you want to split those at the periods then use the SCAN() function.

data want;
   set have;
   length new1-new3 $10;
   new1=scan(type,1,'.');
   new2=scan(type,2,'.');
   new3=scan(type,3,'.');
run;