topic Re: script in New SAS User https://communities.sas.com/t5/New-SAS-User/script/m-p/608096#M17622 Not possible.<BR /><BR />Text files don't have variables. SAS data sets have variables.<BR /><BR />When reading a text file into a SAS data set it is possible to combine five lines of text into a single observation. It is also possible to create three observations from a single line of text.<BR /><BR />Some things are possible. You can count the number of lines of text. With a little programming you can count the maximum number of commas in the first few lines of text. But you can't report on variables when there are no variables. Thu, 28 Nov 2019 17:26:47 GMT Astounding 2019-11-28T17:26:47Z script https://communities.sas.com/t5/New-SAS-User/script/m-p/608018#M17610 <P>Hi Guys. Please help. I need to create a script that shows me how many records and variables are in that text file I'm working on</P> Thu, 28 Nov 2019 10:31:24 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608018#M17610 Dumi1 2019-11-28T10:31:24Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608027#M17612 <P>Can you show us a sample / example of the text file and how variables are delimited, e.g., tab character, comma, column position, etc.</P><P>&nbsp;</P><P>Is the text file on Unix / Linux or DOS / Windows or Mainframe Operating System?</P><P>&nbsp;</P><P>Any other information you could supply that you think would be useful.</P><P>&nbsp;</P><P>&nbsp;</P><P>Kind regards,</P><P>Amir.</P> Thu, 28 Nov 2019 10:53:53 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608027#M17612 Amir 2019-11-28T10:53:53Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608035#M17614 <P>Please post a few lines of the file into a window opened with the {i} button.</P> Thu, 28 Nov 2019 11:59:26 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608035#M17614 Kurt_Bremser 2019-11-28T11:59:26Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608096#M17622 Not possible.<BR /><BR />Text files don't have variables. SAS data sets have variables.<BR /><BR />When reading a text file into a SAS data set it is possible to combine five lines of text into a single observation. It is also possible to create three observations from a single line of text.<BR /><BR />Some things are possible. You can count the number of lines of text. With a little programming you can count the maximum number of commas in the first few lines of text. But you can't report on variables when there are no variables. Thu, 28 Nov 2019 17:26:47 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608096#M17622 Astounding 2019-11-28T17:26:47Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608104#M17624 <P>this is what I mean, I need to make sure that on the text files that am working on all this exacts headers are in the text file and currently I have to manually open the text file and make sure all these headers are on the text file so I'm wondering if there's any script to run that will show me that there's 532 headers in that file, not more not less because if theres more it means I have run a wrong product. This is part of my QA. Please help</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>HD003</TD><TD>EQ001</TD><TD>EQ002</TD><TD>EQ003</TD><TD>EQ004</TD><TD>EQ005</TD><TD>EQ006</TD><TD>EQ007</TD><TD>EQ008</TD><TD>EQ009</TD><TD>EQ010</TD><TD>EQ011</TD><TD>EQ012</TD><TD>EQ013</TD><TD>EQ014</TD><TD>EQ015</TD><TD>EQ016</TD><TD>EQ017</TD><TD>EQ018</TD><TD>EQ019</TD><TD>EQ020</TD><TD>EQ021</TD><TD>EQ022</TD><TD>EQ023</TD><TD>EQ024</TD><TD>EQ025</TD><TD>EQ026</TD><TD>EQ027</TD><TD>EQ028</TD><TD>EQ029</TD><TD>EQ030</TD><TD>EQ034</TD><TD>EQ035</TD><TD>EQ036</TD><TD>EQ037</TD><TD>EQ038</TD><TD>EQ039</TD><TD>EQ040</TD><TD>EQ041</TD><TD>EQ042</TD><TD>EQ043</TD><TD>EQ044</TD><TD>EQ045</TD><TD>EQ046</TD><TD>EQ047</TD><TD>EQ048</TD><TD>EQ049</TD><TD>NQ001</TD><TD>NQ002</TD><TD>NQ003</TD><TD>NQ007</TD><TD>NQ008</TD><TD>NQ009</TD><TD>NQ010</TD><TD>NQ011</TD><TD>NQ012</TD><TD>NQ013</TD><TD>NQ014</TD><TD>NQ015</TD><TD>NQ016</TD><TD>NQ017</TD><TD>NQ018</TD><TD>NQ019</TD><TD>NQ020</TD><TD>NQ021</TD><TD>DF001</TD><TD>DF002</TD><TD>DF005</TD><TD>DF006</TD><TD>DF007</TD><TD>DF008</TD><TD>DF009</TD><TD>DF010</TD><TD>DF011</TD><TD>DF015</TD><TD>DF016</TD><TD>DF023</TD><TD>DF024</TD><TD>DF025</TD><TD>DF026</TD><TD>DF027</TD><TD>DF028</TD><TD>JD001</TD><TD>JD005</TD><TD>JD006</TD><TD>JD007</TD><TD>JD008</TD><TD>JD009</TD><TD>JD010</TD><TD>JD011</TD><TD>JD012</TD><TD>JD013</TD><TD>JD014</TD><TD>JD015</TD><TD>JD016</TD><TD>JD018</TD><TD>JD020</TD><TD>JD022</TD><TD>JD023</TD><TD>JD024</TD><TD>JD025</TD><TD>NG001</TD><TD>NG005</TD><TD>NG006</TD><TD>NG007</TD><TD>NG008</TD><TD>NG009</TD><TD>NG010</TD><TD>NG011</TD><TD>NG012</TD><TD>NG013</TD><TD>NG014</TD><TD>NG024</TD><TD>NG025</TD><TD>NT001</TD><TD>NT009</TD><TD>NT010</TD><TD>NT011</TD><TD>NT012</TD><TD>NT013</TD><TD>NT014</TD><TD>NT015</TD><TD>NT016</TD><TD>TA001</TD><TD>TA002</TD><TD>TA003</TD><TD>TA004</TD><TD>TA005</TD><TD>TA006</TD><TD>TA007</TD><TD>PP001</TD><TD>PP002</TD><TD>PP003</TD><TD>PP004</TD><TD>PP005</TD><TD>PP006</TD><TD>PP010</TD><TD>PP011</TD><TD>PP012</TD><TD>PP016</TD><TD>PP018</TD><TD>PP019</TD><TD>PP020</TD><TD>PP021</TD><TD>PP023</TD><TD>PP024</TD><TD>PP025</TD><TD>PP026</TD><TD>PP028</TD><TD>PP029</TD><TD>PP030</TD><TD>PP031</TD><TD>PP032</TD><TD>PP033</TD><TD>PP035</TD><TD>PP039</TD><TD>PP040</TD><TD>PP041</TD><TD>PP042</TD><TD>PP043</TD><TD>PP044</TD><TD>PP045</TD><TD>PP046</TD><TD>PP047</TD><TD>PP049</TD><TD>PP050</TD><TD>PP059</TD><TD>PP063</TD><TD>PP074</TD><TD>PP089</TD><TD>PP103</TD><TD>PP105</TD><TD>PP106</TD><TD>PP107</TD><TD>PP108</TD><TD>PP109</TD><TD>PP110</TD><TD>PP111</TD><TD>PP112</TD><TD>PP113</TD><TD>PP114</TD><TD>PP115</TD><TD>PP116</TD><TD>PP126</TD><TD>PP135</TD><TD>PP136</TD><TD>PP137</TD><TD>PP138</TD><TD>PP139</TD><TD>PP140</TD><TD>PP141</TD><TD>PP142</TD><TD>PP143</TD><TD>PP144</TD><TD>PP145</TD><TD>PP146</TD><TD>PP147</TD><TD>PP148</TD><TD>PP149</TD><TD>PP150</TD><TD>PP151</TD><TD>PP152</TD><TD>PP153</TD><TD>PP154</TD><TD>PP155</TD><TD>PP156</TD><TD>PP157</TD><TD>PP158</TD><TD>PP159</TD><TD>PP160</TD><TD>PP161</TD><TD>PP162</TD><TD>PP163</TD><TD>PP164</TD><TD>PP165</TD><TD>PP166</TD><TD>PP167</TD><TD>PP168</TD><TD>PP169</TD><TD>PP170</TD><TD>PP171</TD><TD>PP172</TD><TD>PP173</TD><TD>PP174</TD><TD>PP175</TD><TD>PP176</TD><TD>PP177</TD><TD>PP178</TD><TD>PP179</TD><TD>PP180</TD><TD>PP181</TD><TD>PP182</TD><TD>PP183</TD><TD>PP186</TD><TD>PP187</TD><TD>PP188</TD><TD>PP189</TD><TD>PP190</TD><TD>PP191</TD><TD>PP192</TD><TD>PP193</TD><TD>PP194</TD><TD>PP195</TD><TD>PP196</TD><TD>PP197</TD><TD>PP198</TD><TD>PP199</TD><TD>PP200</TD><TD>PP201</TD><TD>PP202</TD><TD>PP203</TD><TD>PP204</TD><TD>PP205</TD><TD>PP206</TD><TD>PP207</TD><TD>PP208</TD><TD>PP209</TD><TD>PP210</TD><TD>PP211</TD><TD>PP212</TD><TD>PP213</TD><TD>PP214</TD><TD>PP215</TD><TD>PP216</TD><TD>PP217</TD><TD>PP218</TD><TD>PP219</TD><TD>PP220</TD><TD>PP221</TD><TD>PP222</TD><TD>PP223</TD><TD>PP224</TD><TD>PP225</TD><TD>PP226</TD><TD>PP227</TD><TD>PP228</TD><TD>PP229</TD><TD>PP230</TD><TD>PP231</TD><TD>PP232</TD><TD>PP233</TD><TD>PP237</TD><TD>PP238</TD><TD>PP239</TD><TD>PP240</TD><TD>PP241</TD><TD>PP242</TD><TD>PP243</TD><TD>PP244</TD><TD>PP245</TD><TD>PP246</TD><TD>PP247</TD><TD>PP248</TD><TD>PP249</TD><TD>PP250</TD><TD>PP251</TD><TD>PP252</TD><TD>PP253</TD><TD>PP254</TD><TD>PP255</TD><TD>PP256</TD><TD>PP257</TD><TD>PP258</TD><TD>PP259</TD><TD>PP260</TD><TD>PP261</TD><TD>PP262</TD><TD>PP263</TD><TD>PP264</TD><TD>PP290</TD><TD>PP291</TD><TD>PP292</TD><TD>PP293</TD><TD>PP294</TD><TD>PP295</TD><TD>PP296</TD><TD>PP297</TD><TD>PP298</TD><TD>PP301</TD><TD>PP302</TD><TD>PP303</TD><TD>PP304</TD><TD>PP305</TD><TD>PP306</TD><TD>PP307</TD><TD>PP308</TD><TD>PP309</TD><TD>PP310</TD><TD>PP311</TD><TD>PP312</TD><TD>PP313</TD><TD>PP314</TD><TD>PP315</TD><TD>PP316</TD><TD>PP317</TD><TD>PP318</TD><TD>PP319</TD><TD>PP320</TD><TD>PP321</TD><TD>PP322</TD><TD>PP323</TD><TD>PP324</TD><TD>PP325</TD><TD>PP326</TD><TD>PP327</TD><TD>PP328</TD><TD>PP329</TD><TD>PP330</TD><TD>PP331</TD><TD>PP332</TD><TD>PP333</TD><TD>PP334</TD><TD>PP335</TD><TD>PP336</TD><TD>PP337</TD><TD>PP338</TD><TD>PP339</TD><TD>PP340</TD><TD>PP341</TD><TD>PP342</TD><TD>PP343</TD><TD>PP344</TD><TD>PP345</TD><TD>PP346</TD><TD>PP347</TD><TD>PP348</TD><TD>PP349</TD><TD>PP350</TD><TD>PP351</TD><TD>PP352</TD><TD>PP353</TD><TD>PP354</TD><TD>PP355</TD><TD>PP356</TD><TD>PP357</TD><TD>PP358</TD><TD>PP359</TD><TD>PP360</TD><TD>PP361</TD><TD>PP362</TD><TD>PP363</TD><TD>PP364</TD><TD>PP365</TD><TD>PP366</TD><TD>PP367</TD><TD>PP368</TD><TD>PP369</TD><TD>RE001</TD><TD>RE002</TD><TD>RE003</TD><TD>RE004</TD><TD>RE005</TD><TD>RE006</TD><TD>RE015</TD><TD>RE020</TD><TD>RE021</TD><TD>RE022</TD><TD>IN001</TD><TD>IN002</TD><TD>IN003</TD><TD>IN004</TD><TD>IN005</TD><TD>IN006</TD><TD>IN020</TD><TD>IN021</TD><TD>IN022</TD><TD>DP001</TD><TD>DP010</TD><TD>DP013</TD><TD>DP018</TD><TD>JN001</TD><TD>JN010</TD><TD>JN013</TD><TD>JN018</TD><TD>SP001</TD><TD>SP003</TD><TD>SP004</TD><TD>SP006</TD><TD>SP007</TD><TD>SP009</TD><TD>SP010</TD><TD>SP012</TD><TD>SP013</TD><TD>SP015</TD><TD>NP001</TD><TD>NP002</TD><TD>NP003</TD><TD>NP004</TD><TD>NP005</TD><TD>NP006</TD><TD>NP010</TD><TD>NP011</TD><TD>NP012</TD><TD>NP016</TD><TD>NP017</TD><TD>NP018</TD><TD>NP019</TD><TD>NP020</TD><TD>NP021</TD><TD>NP022</TD><TD>NP023</TD><TD>NP024</TD><TD>NP025</TD><TD>NP031</TD><TD>NP033</TD><TD>NP039</TD><TD>NP040</TD><TD>NP041</TD><TD>NP042</TD><TD>NP044</TD><TD>NP045</TD><TD>NP047</TD><TD>NP057</TD><TD>NP103</TD><TD>NP104</TD><TD>NP105</TD><TD>NP106</TD><TD>NP107</TD><TD>NP108</TD><TD>NP109</TD><TD>NP110</TD><TD>NP111</TD><TD>NP113</TD><TD>NP147</TD><TD>NP186</TD><TD>NP187</TD><TD>NP188</TD><TD>NP189</TD><TD>NP190</TD><TD>NP191</TD><TD>NP192</TD><TD>NP193</TD><TD>NP194</TD><TD>NP195</TD><TD>NP196</TD><TD>NP197</TD><TD>NP198</TD><TD>NP199</TD><TD>NP200</TD><TD>NP201</TD><TD>NP202</TD><TD>NP203</TD><TD>NP204</TD><TD>NP205</TD><TD>NP206</TD><TD>NP207</TD><TD>NP208</TD><TD>NP209</TD><TD>NP210</TD><TD>NP211</TD><TD>NP212</TD><TD>NP213</TD><TD>NP214</TD><TD>NP215</TD><TD>NP216</TD><TD>NP217</TD><TD>NP218</TD><TD>NP219</TD><TD>NP220</TD><TD>NP221</TD><TD>NP222</TD><TD>NP223</TD><TD>NP224</TD><TD>NP225</TD><TD>NP226</TD><TD>NP227</TD><TD>NP228</TD><TD>NP229</TD><TD>NP230</TD><TD>NP231</TD><TD>NP232</TD><TD>NP233</TD><TD>NP239</TD><TD>NP240</TD><TD>NP241</TD><TD>NP242</TD><TD>NP243</TD><TD>NP244</TD><TD>NP245</TD><TD>NP246</TD><TD>NP247</TD><TD>NP262</TD><TD>NP278</TD><TD>NP279</TD><TD>NP280</TD><TD>NP281</TD><TD>NP282</TD><TD>NP283</TD><TD>NP284</TD><TD>NP285</TD><TD>NP286</TD></TR></TBODY></TABLE> Thu, 28 Nov 2019 17:48:43 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608104#M17624 Dumi1 2019-11-28T17:48:43Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608110#M17627 <P>What does your text file look like?&nbsp; What you posted into the forum looks like an HTML table.&nbsp; Perhaps that is because your text file is using tabs as the delimiter? Perhaps it is because you opened the text file with Excel or some other program that converted the text into cells in a table?</P> <P>&nbsp;</P> <P>You might want to also look at the names of the columns and not just the number of them to make sure you have the right file.</P> <P>&nbsp;</P> <P>So if the file is using TAB as the delimiter and there are no more than 1,000,000 bytes in the first line here is a program generate a dataset with the names of the columns.&nbsp; It will also print the number of columns in the log and set a macro variable to the number. For other delimiters change the DLM= (aka DELIMITER=) option.</P> <PRE><CODE class=" language-sas">data names ; if eof then do; put 'There are ' column 'columns in this file.'; call symputx('num_columns',column); end; infile 'myfile' dsd dlm='09'x truncover end=eof lrecl=1000000 obs=1; column+1; input name :$32. @@; run;</CODE></PRE> <P>&nbsp;</P> Thu, 28 Nov 2019 19:21:22 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608110#M17627 Tom 2019-11-28T19:21:22Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608112#M17629 <P>yes the file is tab delimited and I opened the text file with excel so that I can count the number of headers.</P><P>&nbsp;</P><P>Thank you so much, I'll try this script</P> Thu, 28 Nov 2019 18:41:41 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608112#M17629 Dumi1 2019-11-28T18:41:41Z Re: script https://communities.sas.com/t5/New-SAS-User/script/m-p/608121#M17632 <P>You use '09'x to represent a TAB in the infile statement.&nbsp; Also make sure to include OBS=1 in the infile statement or it will read the whole file!</P> Thu, 28 Nov 2019 19:22:19 GMT https://communities.sas.com/t5/New-SAS-User/script/m-p/608121#M17632 Tom 2019-11-28T19:22:19Z