Hi Team,
Iam running the code in which using proc transpose procure.but here the step gets failed .Error is "No columns are available "
Actually error is clear that there are no columns in that dataset which is being transposed.
but these columns are getting created using the data coming from the dataset .
Actually i have dataset having columns called "Name" which has data values "JOHN" "JAMES" "PETER" "PAUL" "RUTH" "DAVID"
so after this step running proc transpose statemnet where we are using above columns values (john,james..) are converting to columns.
problem here is there is no name values ("JOHN" "JAMES" "PETER" "PAUL" "RUTH" "DAVID") in test environmnet and present in live environmnet,so iam running this code in test enviornmet and getting error under porc_tranpose step saying "no columns present"
Would you please help how can we optimise the code in such a way that it will handle this scenario please
Please provide before/after data, as well as the code you tried.
HI @ChrisNZ ,
kindly find below core where we are getting error like john is not present,james is not present.
proc transpose data=namedetails out=trans_name(drop=_name_ _label_);
by id;
var count;
id name;
run;
HI @ChrisNZ ,
kindly find below sample code where we are getting error like john is not present,james is not present.
proc transpose data=namedetails out=trans_name(drop=_name_ _label_);
by id;
var count;
id name;
run;
Proc Transpose is very data sensitive. Provide example input data that causes the error messages.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.