topic Proc Transpose in SAS Programming

Proc Transpose

myboys2 — Fri, 07 Dec 2018 19:41:52 GMT

i have a csv file as an example below

fname lname dob servicedate 11111 44444 55555 22222

joe smith 1/1/1970 12/1/2017 5 9 100 120

mary doe 8/12/1901 07/03/2017 40 20 60 80

proc transpose data= r_test out=r_test_tp(rename =(_name_=testname2 col1=resno));

by fname lname dob servicedate;

var

11111

44444

55555

22222

I am getting an error because of my var statement. I have only used it if the columns were titles not numbers . is there a way around this?

syntax error, expecting one of the following: a name, ;, -, :,

_ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

Re: Proc Transpose

Reeza — Fri, 07 Dec 2018 20:23:17 GMT

It helps if you post the full log. SAS underlines the section in the code which makes it easy to find.
You can try removing the RENAME statement to see if that helps, but it looks fine to me.

Re: Proc Transpose

ballardw — Fri, 07 Dec 2018 20:36:52 GMT

Generally variable names in SAS are not allowed to start with digits. Examine your data set r_test to douple check. If so then they are called "name literals" and because they violate the standard naming conventions each one needs to be enclosed in parentheses and followed with n

'11111'n for example. It is possible that you are seeing a LABEL and not the actual variable's name. Use Proc Content or your other preferred tool for examining data set description information.