Anyone know how I can use this and not output all of the FREQ of the variables? Thank you! ... View more

I used data step to import with the following option, this resolved the issue with unwanted quotes I got for the last column. Hope this helps. Thanks.   TERMSTR= option—Specifies what end-of-line character to use for a file. This option is specific to ASCII operating systems and is documented in the SAS 9.2 companion for your operating system. This option is useful when you want to share data files that are created on one operating system with another operating system. For example, if you are working in a UNIX environment and you need to read a file that was created under Windows, use TERMSTR=CRLF. Similarly, if you are in a Windows environment and you need to read a file that was created under UNIX, use TERMSTR=LF. The following INFILE statement illustrates reading a MAC file from a PC: infile 'C:\mydata\test.dat' dsd dlm='|' termstr=cr; ... View more

Hi there,    I abit wonder how I can get the user information u58437933?   Thanks ... View more

Same issue here for SAS9.4M7 for OS license for WX64_WKS and not as documented: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.2/lefunctionsref/p12v9lpx7rlthin1cnpd320l3mj3.htm  Suggest you raise a defect with SAS TechSupport data test; infile datalines truncover; input holiday_value $40.; result_dt=holiday(holiday_value,2022); format result_dt date9.; datalines; BOXING CANADA CANADAOBSERVED CHRISTMAS COLUMBUS EASTER FATHERS HALLOWEEN Juneteenth LABOR MLK MEMORIAL MOTHERS NEWYEAR THANKSGIVING THANKSGIVINGCANADA USINDEPENDENCE USPRESIDENTS VALENTINES VETERANS VETERANSUSG VETERANSUSPS VICTORIA ; proc print data=test; run;   ... View more

I think this person was looking under the Practices folder and not the Activities folder. Read the instructions carefully. Like Bill Murray says, Baby Steps.  ... View more

When SAS reads the row of a data into PDV, two variables will be created i.e. the FIRST.variable and LAST.variable. These variables are not in the input table . Therefore, you can't use the WHERE statement to subset rows of variables which are not yet in the input data. Instead, you can use the subsetting IF statement. ... View more

@tocilj    The double proc transpose is nice in that it has a simple structure, and it uses a pre-packaged sas routine.   But it may not scale well.  Transposing 1,000,000 observations will create a dataset with 1,000,000 variables in the intermediate data set TEST1.  The entire dataset would have to be processed two times, which can begin to use significant resources. ... View more