Hi all,
Using SAS EG while populating and then printing a control table with some test data I've encountered a case where the data messes-up the output (sample below).
Do you know of any way to avoid such a result without having to encode characters in the source data so they become "html safe"?
data work.sample;
infile datalines4 truncover dlm='|' dsd;
input
rule_type :$30.
rule_desc :$100.
;
datalines4;
Not Null|Raise issue if value is missing
In a List|Raise issue if value NOT found in a list
Not In a List|Raise issue if value found in a list
In Value Range|Raise issue if value NOT within boundaries
Not In Value Range|Raise issue if value within boundaries
Lookup Exist|<table for hash> <keyvar(s) hash> <keyvar(s) table if different names>
Not Lookup Exist|<table for hash> <keyvar(s) hash> <keyvar(s) table if different names>
Unique Key|<space separated list of variables that make up the unique key>
Custom Function|Any SAS expression that return True or False. Example: <var 1> = <var 2>
;;;;
proc print data=work.sample;
run;
Thanks,
Patrick
Patrick,
Try this one.
data work.sample;
infile datalines4 truncover dlm='|' dsd;
input
rule_type :$30.
rule_desc :$100.
;
datalines4;
Not Null|Raise issue if value is missing
In a List|Raise issue if value NOT found in a list
Not In a List|Raise issue if value found in a list
In Value Range|Raise issue if value NOT within boundaries
Not In Value Range|Raise issue if value within boundaries
Lookup Exist|<table for hash> <keyvar(s) hash> <keyvar(s) table if different names>
Not Lookup Exist|<table for hash> <keyvar(s) hash> <keyvar(s) table if different names>
Unique Key|<space separated list of variables that make up the unique key>
Custom Function|Any SAS expression that return True or False. Example: <var 1> = <var 2>
;;;;
proc report data=work.sample nowd style(column)={PROTECTSPECIALCHARS=yes};
run;
Patrick,
Try this one.
data work.sample;
infile datalines4 truncover dlm='|' dsd;
input
rule_type :$30.
rule_desc :$100.
;
datalines4;
Not Null|Raise issue if value is missing
In a List|Raise issue if value NOT found in a list
Not In a List|Raise issue if value found in a list
In Value Range|Raise issue if value NOT within boundaries
Not In Value Range|Raise issue if value within boundaries
Lookup Exist|<table for hash> <keyvar(s) hash> <keyvar(s) table if different names>
Not Lookup Exist|<table for hash> <keyvar(s) hash> <keyvar(s) table if different names>
Unique Key|<space separated list of variables that make up the unique key>
Custom Function|Any SAS expression that return True or False. Example: <var 1> = <var 2>
;;;;
proc report data=work.sample nowd style(column)={PROTECTSPECIALCHARS=yes};
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: