topic Manual input text via prompt to save in customer column of dataset in SAS Enterprise Guide

Manual input text via prompt to save in customer column of dataset

xiaoyao026 — Fri, 17 Aug 2018 08:46:02 GMT

Hello everyone

i'm trying to create a STP in EG, to allow user to manually type their comment, to save in dataset colume, for corresponding record.

i have tried following:

Step 1: create a customer data column (name as "user_comment") via advance expression like: &user_comment

Step 2: create a filter as "user_comment = $user_comment"

Step 3: in Prompt Manager, create a prompt as text (multi-line)

Step: 4: run the process, to see if i can manually type comment, and save in that customer column.

but i found it doesn't work as i thought, it shows error like "can not find column".

would it be possible to guide me how to achieve my purpose if above way is not right?

Thank you very much in advance.

FredrikE — Fri, 17 Aug 2018 09:01:24 GMT

You need to add "" to the expression in order to resolve the macro variable: "&user_comment".

//Fredrik

xiaoyao026 — Fri, 31 Aug 2018 05:49:00 GMT

Thank you very much, it works.

sorry for late feedback due to my business trip.